How to GET records from Salesforce using Logic App

Posted On March 9, 2021 by Rushank Karekar Posted in

Tagged in Azure Logic App, How to fetch Salesforce Records from Salesforce, SOQL in Logic App

Part 1: How to get records from Salesforce in Logic App – Using built in Salesforce GET Records Connector

Introduction:

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.