Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

On this page

Table of Contents
maxLevel2
absoluteUrltrue

...

Input/OutputType of ViewNumber of ViewsCompatible Examples of Upstream and Downstream SnapsDescription
Input Document
  • Min: 0
  • Max: 1
  • Mapper Snap
  • Filter
  • Router
A document containing values required for the bulk query.
OutputDocument
  • Min: 1
  • Max: 1
  • Document to Binary
  • Salesforce Upsert

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

...

Parameter NameData TypeDescriptionDefault ValueExample 
LabelStringThe name for the Snap. We recommend you to update the Snap name if there is more than one Snap of the same type in your Pipeline.Salesforce Bulk QueryN/A

Service version

String

The Salesforce Bulk Query service version that you want to use for this query.

47.047.0
SOQL queryString

Required. This property enables you to define the SOSL query statement. You can enter a JavaScript expression, which is evaluated each time the Snap is executed. As in the second example below, on each document received from the input view, the % symbols will be replaced with the value pointed to by the JSON path $.Id in the input data.

Example:

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


Note
titleUsing quotes in the WHERE clause
  • Do not use quotes for field names in the WHERE clause. Using quotes results in an error.
  • Use only single quotes for values in the WHERE clause as using double quotes results in an error.
  • The above rules do not apply when you are using SnapLogic expressions, you can use quotes for the field names and values as applicable. 

Default value: [None]



Max records per setIntegerThe number of records that you want the Snap to fetch in a single set.100005000

Polling interval

Integer

Required. 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.

Minimum value: 1

Maximum value: 60

510
Polling timeoutInteger

Required. 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 

3000300
Maximum retry attemptsInteger

The maximum number of retry attempts that the Snap must make in case of a network failure. 

Minimum value: 1

Multiexcerpt include macro
nameretries
pageFile Reader

51
Retry interval (seconds)Integer

The minimum number of seconds for which the Snap must wait before attempting recovery from a network failure.

Minimum value: 0

13
Snap ExecutionString

Specifies the execution type:

  • Validate & Execute: Performs limited execution of the Snap (up to 50 records) during Pipeline validation; performs full execution of the Snap (unlimited records) during Pipeline execution.
  • Execute only: Performs full execution of the Snap during Pipeline execution; does not execute the Snap during Pipeline validation.
  • Disabled: Disables the Snap and, by extension, the downstream Snaps.

Default value: Validate & Execute

Validate and ExecuteN/A

Insert excerpt
Salesforce Batch Create
Salesforce Batch Create
nopaneltrue

Multiexcerpt include macro
nameTemporary Files
pageJoin

Examples

Querying for Contacts in Salesforce Using Upstream Parameters in the Bulk Query Snap

...