SOQL for getting partition of the data

Question

Hi,

I have an object with milions of records and would like to extract it from salesforce. As the number of lines is very big, I get a timeout error or the job is failing. How can I devide the query into partitions. I was trying to use the funtion to get the minimum Id and Maximum Id, but now when I try to query the first 2000 records, I don't know what is the next Id (after 2000 records) that I should start my next partition from.

So my question, by having a specific Id, how can I know what is the Id after 2000 records?

Sathishkumar Periyasamy · Answer

Please use PK Chunking to extract data from Salesforce. Please refer below link.

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

https://developer.salesforce.com/blogs/engineering/2015/03/use-pk-chunking-extract-large-data-sets-salesforce.html

SOQL for getting partition of the data

Integration

Related Learning

More Help