When outputting data via the Salesforce Output tool, if there are no records to output Salesforce still creates a job with zero batches and never closes it. If the workflow produces no data to be sent to Salesforce then how do I: * Close the Salesforce job after the workflow completes? ...or... * Prevent the Salesforce job from being created in the first place if no records will be outputted? I tried using the block tool to prevent data from being sent to the output tool in the first place, but it apparently still creates a job with no batches in Salesforce.

Alteryx rep recommended using the Detour tool. This is a bit of a workaround and requires batch macros for each Salesforce output, but it works! First, create a batch macro with your Salesforce destination that accepts the count of records being sent via the control parameter as well as the fields being sent to the Salesforce output via the macro input: When data is sent to the macro it will be sent directly to the Salesforce output, otherwise the output is bypassed and the flow ends. Second, add the macro to your workflow, sending in the count of records and field mapping to your batch input: When there are territory updates, but no inserts, Salesforce creates only the job for updates:

Salesforce Output Batch Jobs Not Closing

rpaugh

When outputting data via the Salesforce Output tool, if there are no records to output Salesforce still creates a job with zero batches and never closes it. If the workflow produces no data to be sent to Salesforce then how do I:

Close the Salesforce job after the workflow completes?
...or...
Prevent the Salesforce job from being created in the first place if no records will be outputted?

I tried using the block tool to prevent data from being sent to the output tool in the first place, but it apparently still creates a job with no batches in Salesforce.

Connectors

Salesforce

Accepted answers

rpaugh

Alteryx rep recommended using the Detour tool. This is a bit of a workaround and requires batch macros for each Salesforce output, but it works!

First, create a batch macro with your Salesforce destination that accepts the count of records being sent via the control parameter as well as the fields being sent to the Salesforce output via the macro input:

Alteryx Batch Macro with Detour - 2017-03-15_10-27-05.png

When data is sent to the macro it will be sent directly to the Salesforce output, otherwise the output is bypassed and the flow ends.

Second, add the macro to your workflow, sending in the count of records and field mapping to your batch input:

Alteryx Batch Macro Example - 2017-03-15_10-30-44.png

When there are territory updates, but no inserts, Salesforce creates only the job for updates:

Alteryx Batch Macro Job Result - 2017-03-15_10-33-50.png

All comments

rpaugh

Alteryx rep recommended using the Detour tool. This is a bit of a workaround and requires batch macros for each Salesforce output, but it works!

Alteryx Batch Macro with Detour - 2017-03-15_10-27-05.png

When data is sent to the macro it will be sent directly to the Salesforce output, otherwise the output is bypassed and the flow ends.

Second, add the macro to your workflow, sending in the count of records and field mapping to your batch input:

Alteryx Batch Macro Example - 2017-03-15_10-30-44.png

When there are territory updates, but no inserts, Salesforce creates only the job for updates:

Alteryx Batch Macro Job Result - 2017-03-15_10-33-50.png

calebdugger

Thank you for posting this! I was having the same problems and it looks like this doesn't create the bulk load jobs with nothing in them.

I do have a question: do you have to create a different macro for each different workflow you create (if it has different fields you are updating in the Salesforce output)? I'm hoping there is an easy way to dynamically select the fields being passed through to the macro so I don't have to create a new macro for every scenario i have where different fields are selected to be updated. - I get that a different one would have to be created for each table.

Any help is appreciated!

Abmillh

I just had to solve this problem for one of my workflows. With control containers, it's a lot easier (Record Count tool -> Filter !=0 -> Control Container with Salesforce Output tool).

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703