โ09-14-2023 10:54 PM
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?
Solved! Go to Solution.
โ09-15-2023 07:43 AM
@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
โ09-22-2023 03:19 AM
Hi @prp_proton ,
An alternate solution is using a formula to pluck the nextRecordsUrl as a datapill. See sample below:
โ09-15-2023 07:43 AM
@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
โ09-16-2023 08:25 PM
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?
โ09-22-2023 03:19 AM
Hi @prp_proton ,
An alternate solution is using a formula to pluck the nextRecordsUrl as a datapill. See sample below: