Part 1: How to get records from Salesforce in Logic App – Using built in Salesforce GET Records Connector
Working with Salesforce connectors can be a bit tricky as you have to convert your SOQL into a set of built-in parameters provided by the Salesforce GET records connector. This blog will show you how you can easily handle this in two parts as follows:
Part 1: How to GET records from Salesforce using Logic App Salesforce GET Records Connector
Part 2: How to GET records from Salesforce using Salesforce SOQL in Logic App
Salesforce Built-In GET Records connector
Following a sample sequence of steps that can be used fetch the Accounts from salesforce and further its related records. This example also shows how you can use the different parameters provided by this built in GET Records connector.
Step 1: Add the Get Records block of Salesforce and Select the Object type as Accounts. Add parameters as following
Select Query to select specific fields
Filter to add a filter condition for records to be fetched. Note this query should be a An ODATA filter query. Refer to this link for reference Using Filter Expressions in OData URIs – Dynamics NAV | Microsoft Docs
Top Count to specify the total records to be fetched. Here we have used a variable which has the int value of the Total number of records.
Skip Count to specify the number of entries to skip (default = 0). Here we have used expression mul(variables(‘total-records’),sub(variables(‘page-number’),1)) to handle Pagination.
For more information on Salesforce GET records connector of Salesforce refer to: Salesforce – Connectors | Microsoft Docs
Step 2: Add a For Each block and in Select an Output from previous steps add ‘value’ to loop over each account.
Step 3: Add the Get Records block of Salesforce and Select the Object types shown below. Add parameters for Select Query and Top Count and configure them as follows.
Here we have learned how to use the Logic App Salesforce GET records connector and the parameters that it provides out of box.