Using custom SOQL in Salesforce Get operations
Custom SOQL allows you to create advanced and complex queries and insert the custom SOQL into the Salesforce connector's Get operations.
About this task
SELECT Id from Account where BillingCity = ‘Atlanta’ and (NOT BillingZip like ‘33%’)You typically use the Message shape to send custom SOQL as an input document to the Salesforce connector's Get operation. You can send multiple SOQL queries as multiple documents to retrieve records. Custom SOQL is not supported for bulk operations.
Build the SOQL.When building the SOQL, be aware of certain SOQL feature limits. For more information, see the SOQL and SOSL Limits topic in the Salesforce Developer documentation.
In Boomi Integration, build the process to move and process the Salesforce data.
The process appears on the process canvas, as shown in the following image:
In the process, copy the SOQL into the shape (typically the Message shape) that comes before and is connected to the Salesforce connector. This shape provides an input document to the Salesforce connector's Get operation.
The Message shape appears, as shown in the following image:
In the Salesforce connector operation's Get action, click the Advanced tab and select Use Custom Soql. If the operation already has an object configuration with fields, filters, and sorts that is created by an import, the configuration is removed when you select Use Custom Soql. This happens because the connector expects the SOQL to be passed as an input document to the connector.
The Salesforce operation Advanced tab appears, as shown in the following image: