Salesforce Lookup
In this article
Overview
The Salesforce Lookup Snap is a Read-type Snap that provides the ability to format WHERE clause from input document stream for a SOQL (Salesforce Object Query Language) query. See Introduction to SOQL and SOSL for more information.
To use newer Salesforce objects, use the latest API versions where those objects are available.
Prerequisites
A valid Salesforce account with the required permissions.
Support for Ultra Pipelines
Works in Ultra Pipelines.
In Ultra mode, ensure that you enable the Single Lookup Request property checkbox to process one document at a time.
Limitations and Known Issues
None.
Snap Views
Type | Format | Number of Views | Examples of Upstream and Downstream Snaps | Description |
---|---|---|---|---|
Input | Document |
|
| This Snap has exactly one input view and receives Document(s) in the view. Expressions in the Object type, Output fields, Conditions and Correlation ID properties can be evaluated with values from the input view during the execution. |
Output | Document |
|
| Documents |
Error | The error view contains error, reason, resolution and stack trace. For more information, see Handling Errors with an Error Pipeline. |
Snap Settings
Field | Field Type | Description | |
---|---|---|---|
Label*
| String | Specify a unique 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. Default Value: Salesforce Lookup | |
Service Version* | String/Expression | Specify the version number associated with the Salesforce service that you want to connect to. Alternatively, click the Suggestion icon to fetch the list of versions and select the desired version. | |
Salesforce API* | Dropdown list | This property sets the Salesforce API mode to Bulk API or REST API during the pipeline execution. | |
Object Type* | String/Expression/Suggestion | Specify the name of the Salesforce object or select one from the suggested list. This Snap does not support Net Zero Cloud Salesforce objects. Default Value: Account | |
Output Fields* | Use this field set to define the field names for the Salesforce Object Query Language (SOQL) SELECT statement. Specify each output field as a separate row. Click to add a new row. | ||
Output Fields* | String/Expression/Suggestion | Specify a list of field names for the SOQL SELECT statement. Alternatively, click the Suggestion icon to fetch the list of field names associated with the object type and select a field. The value for this field can also be an expression that will be evaluated against the values configured in Pipeline parameters only. Default Value: N/A | |
Conditions* | Use this field set to define conditions. Specify each condition as a separate row. Click to add a new row. | ||
Conditions* | String/Expression | Specify the condition for the WHERE clause. The values in this field forms an AND clause in the SOQL WHERE statement. Each entry in the Conditions row can be an expression to be evaluated with the values from the input view. The Snap receives a stream of document data, where each document is formatted into an AND clause and all AND clauses are ORed together to form an entire WHERE statement. If the size of SOQL statement exceeds 10,000 characters, the Snap sends the SOQL query request, retrieves the resulting records which are sent to the output view, and restarts forming a new WHERE statement. Example: "Name = '" + $Name + "'" Using quotes in the WHERE clause
Default Value: N/A | |
Correlation ID | String/Expression/Suggestion | Specify an ID field name which the Snap uses to correlate input document to the output record when you want to pass through input data to the output view. Alternatively, click the Suggestion icon to fetch a list of IDs and select a ID.
Default Value: N/A | |
Single Lookup Request | Checkbox | Select this checkbox to enable the Snap to send one lookup request for each input document. In Ultra mode, ensure that you select this checkbox to process one document at a time. Default Value: Not selected | |
Polling Interval* | Integer/Expression | Specify the polling interval in seconds for the Bulk API query execution. At each polling interval, the Snap checks the status of the Bulk API query batch processing. Maximum value:: 60 This field can be an expression that will be evaluated against the values configured in Pipeline parameters only. Default Value: 5 | |
Polling Timeout*
| Integer/Expression | Specify the polling timeout in seconds for the Bulk API read batch execution. If the timeout occurs while waiting for the completion of the read batch execution, the Snap throws a SnapExecutionException. This field can be an expression that will be evaluated against the values configured in Pipeline parameters only. Default Value: 3000 | |
Process Date/Time
| Checkbox | All date/time fields from Salesforce.com are retrieved as string type. If this property is unchecked, the Snap sends these fields without any conversion. If checked, the Snap converts date/time fields to corresponding date/time types by accessing the meta data of the given SObject. Salesforce datetime is converted to Joda DateTime, Salesforce date to Joda LocalDate and Salesforce time to Joda LocalTime. | |
Include Deleted Records
| Checkbox | Select this checkbox to include deleted records in the query result. This feature is supported in REST API version 29.0 or later and Bulk API version 39.0 or later. Default Value: Not selected | |
Pass-through on No Lookup Match | Checkbox | Select this checkbox to allow the input document to pass through to the output view when there is no lookup matching an input document. Else, the input document is written to the error view as an error condition. Default Value: Not selected | |
Match Data Type
| Chec |