topic Re: Salesforce SOQL connector : nextRecordsUrl response in Workato Pros Discussion Board

Salesforce SOQL connector : nextRecordsUrl response

prp_proton — Fri, 15 Sep 2023 05:54:56 GMT

Hi,

When using the SOQL query on salesforce, it is not returning the entire data. Instead it is returning a variable nextRecordsUrl to fetch the rest of the data.

How can we get the entire data in one shot.

Also if to get the whole data is not possible, how to read the variable value of nextRecordsUrl as it is not show as variable in workato. Only while checking the output in the job, able to see this variable.

Any suggestion on this?

Re: Salesforce SOQL connector : nextRecordsUrl response

mppowe — Fri, 15 Sep 2023 14:43:40 GMT

@prp_protonYou should be able to use the "Search records in bulk using SOQL query (API 2.0) in Salesforce" action as a part of the Salesforce connector. That way you'll get the entire result set streamed into a CSV and don't have to page through the results.

Hope that helps.

Reference:

https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/queries.htm

Re: Salesforce SOQL connector : nextRecordsUrl response

prp_proton — Sun, 17 Sep 2023 03:25:27 GMT

But bulk api does not support aggregated relationship. So, in that scenario what is the alternate solution?

Also I found that in workato, the nextRecordsUrl variable does not show during design phase. Only it is shows in job report in json format. So how can we get the urls details in workato to do a API call for the next time?

Re: Salesforce SOQL connector : nextRecordsUrl response

marlon-muela — Fri, 22 Sep 2023 10:19:14 GMT

Hi @prp_proton ,

An alternate solution is using a formula to pluck the nextRecordsUrl as a datapill. See sample below: