How to hold session Id in salesforce connector to use in next actions in logic apps

Nagasudhakar Patamsetty 1 Reputation point
2020-12-14T12:51:44.117+00:00

Hi,

I want to query huge number of records (in millions) from salesforce. so I used salesforce connector in logic app and used action as "Get Records" which is returning first 200 records and @odata.nextLink which will have URI for next set of records. but when I tried to do http call as next action with the given url (@odata.nextLink) it's throwing error and I am not seeing any way on how to get session id of salesforce connection so i can use the same in next actions.

will connector support if we need to query millions of records ?
how to hold the session id/access token for of salesforce to use in next actions?

please let me know on your suggestions.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,772 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,517 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Mike Urnun 9,481 Reputation points Microsoft Employee
    2020-12-15T03:39:47.247+00:00

    @Nagasudhakar Patamsetty I believe the Salesforce connector supports the Pagination feature so the connector should automatically fetch the records for you. All you'd have to do is turn on Pagination in the Settings of the connector, please review: Get more data, items, or records by using pagination in Azure Logic Apps