Define the SOQL query statement. You can enter a JavaScript an 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.This Snap supports the SOQL keyword FIELDS(), which can be used to select a pre-defined collection of fields from an object in place of the typical field list. Learn more. To use FIELDS() in a SOQL query, the Snap’s service version must be set to 51.0 or higher.

Example:

"SELECT Name FROM Account"

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

Default value: [None]

Specify the number of records to process in a batch. This refers to the number of records in each batch during the download of large query results. Each batch read requires an API call against Salesforce to retrieve the set of records.

1. REST API:
   The batch sizes 200 and 2000 are valid in REST API.
   According to the SFDC REST API documentation:
   "There is no guarantee that the requested batch size is the actual batch size. Changes are made as necessary to maximize performance."
   In fact, if the size of each record in the query result is relatively large (e.g. a few hundred output fields), SFDC may respond in a batch size of 200, And if the size of each record in the query result is relatively small, SFDC may respond in a batch size of 2000 regardless if the Batch size is set to 200 or 2000.
2. Bulk API:
   Selecting the values 100,000 or 250,000 will make the Bulk API request as PK-chunking with a chunk size of 100,000 or 250,000. Other values 200 or 2000 will have the Snap submit a single regular Bulk API batch job to SFDC.
   According to the SFDC Bulk API documentation (Number of attempts to query):
   "15 attempts at 10 minutes each to process the batch. There is also a 2-minute limit on the time to process the query. If more than 15 attempts are made for the query, an error message of 'Tried more than fifteen times' is returned. If the query takes more than 2 minutes to process, a QUERY_TIMEOUT error is returned."
   Therefore, if the query is expected to take a long time to execute (e.g. the target SObject has more than several hundred thousand records and the number of output fields in a record is more than a few hundreds), it is highly recommended to set this property to 100,000 or 250,000 to avoid timeout errors.

Default Value: 2000 
Example: 2000

Select the content type for Bulk API: JSON or XML.  

Default Value: XML 
Example: JSON

Specify the number of records to process in a batch. This refers to the number of records in each batch during the download of large query results. Each batch read requires an API call against Salesforce to retrieve the set of records. This Snap does not honor the selection of the Match Data Type checkbox when the valued entered for Batch Size is greater than 50,000.

1. REST API:
   The batch sizes 200 and 2000 are valid in REST API.
   According to the SFDC REST API documentation:
   "There is no guarantee that the requested batch size is the actual batch size. Changes are made as necessary to maximize performance."
   In fact, if the size of each record in the query result is relatively large (e.g. a few hundred output fields), SFDC may respond in a batch size of 200, And if the size of each record in the query result is relatively small, SFDC may respond in a batch size of 2000 regardless if the Batch size is set to 200 or 2000.

2. Bulk API:
   Selecting the values 100,000 or 250,000 will make the Bulk API request as PK-chunking with a chunk size of 100,000 or 250,000. Other values 200 or 2000 will have the Snap submit a single regular Bulk API batch job to SFDC.
   According to the SFDC Bulk API documentation (Number of attempts to query):
   "15 attempts at 10 minutes each to process the batch. There is also a 2-minute limit on the time to process the query. If more than 15 attempts are made for the query, an error message of 'Tried more than fifteen times' is returned. If the query takes more than 2 minutes to process, a QUERY_TIMEOUT error is returned."
   Therefore, if the query is expected to take a long time to execute (e.g. the target SObject has more than several hundred thousand records and the number of output fields in a record is more than a few hundreds), it is highly recommended to set this property to 100,000 or 250,000 to avoid timeout errors.
   
   

Default Value: 2000 
Example: 2000

Specify the name of the Salesforce object or select one from the suggested list.

Default Value: Account
Example: Account  

Select this checkbox to ignore empty result, so no document will be written to the output view when the operation does not produce any result.

If you deselect this checkbox and select Pass Through, the input document will be passed through to the output view.

If you do not select both the checkboxes, Ignore Empty Result and Pass Through, the Snap writes an empty output as below:

[{}]

Default value: Selected

Select the content type for Bulk API: JSON or XML.  

Default Value: XML 
Example: JSON

Select this checkbox to view the preview in Bulk API. If you select this option and the Salesforce API property is Bulk API, the Snap is executed in Bulk API during the preview.

Default Value: Not selected

Specify the maximum number of retry attempts in case of a network failure. 

Minimum value: 0

Default Value: 1
Example: 3