• Min: 0
• Max: 1

• Mapper Snap
• Filter
• Router

• Min: 1
• Max: 1

• Document to Binary
• Salesforce Upsert

A document containing the results of the query performed by the Snap.

Document

• Min: 1

• Max: 1

N/A

The error view contains error, reason, resolution and stack trace. For more information, see Handling Errors with an Error Pipeline.

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter while running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab. The available options are:

• Stop Pipeline Execution: Stops the current pipeline execution when the Snap encounters an error.

• Discard Error Data and Continue: Ignores the error, discards that record, and continues with the rest of the records.

• Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

Label*

DefaultValue:Salesforce Bulk Query
Example:Salesforce Bulk Query

Specify the name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline.

Service Version*

Default Value:

52.0 





Example:

41.0

SOQL Query*

DefaultValue:  52.0 
Example: 41.0

None
Example:"select FirstName, LastName from " + $object + " order by Name LIMIT 5"

"SELECT Name FROM Account"
"SELECT Id,Name,Phone FROM Account WHERE Id='" + $Id + "'and
Name='" + $name + "'"

Max Records Per Set*

Default Value:10000
Example:5000

Specify the number of records that you want the Snap to fetch in a single set.

Maximum threads

Default Value:

10
Example: 9

Specify the maximum number of threads to download query results simultaneously in multiple threads. The Snap uses the thread pool to download the query results.

Minimum value: 1
Maximum value: 200

Polling Interval*

Default Value: 5
Example:10

Specify the number of seconds for which you want the Snap to wait between two queries. At each polling interval, the Snap checks the status of the Bulk API query batch processing status.

Minimum value: 1
Maximum value: 60Default

Polling Timeout*

Default Value: 53000
Example:10

300

Specify the number of seconds into the query batch execution before the query fails if it receives no response. If the timeout occurs while waiting for the completion of the query batch execution, the Snap throws a SnapExecutionException.

Minimum value: 10 Default

Retry Interval (seconds)

Default Value:3
Example:

3

Specify the minimum number of seconds

the Snap must wait before attempting recovery from a network failure.

Minimum value: 0

Include Deleted Records

Match Data Type

Default Value: Deselected

Display null or empty values as null

Default Value

: Deselected

Checkbox

Object Type

Default Value: N/A
Example: String

Appears on selecting the Match Data Type checkbox.

Specify the object type to match. Alternatively, select an object type from the suggestions list to match the data type.

Snap Execution

DefaultValue: Validate & Execute
Example:Execute only

Select one of the three modes in which the Snap executes. Available options are:

• Validate & Execute: Performs limited execution of the Snap , and generates a data preview during Pipeline validation. Subsequently, it performs full execution of the Snap (unlimited records) during Pipeline runtime.
• Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.

• Disabled: Disables the Snap and all Snaps that are downstream from it.

Default Value: Validate & Execute
Example: Execute only