How to retrieve data in chunks or batches ?

[Sourabh1]

Hi All,

I would like to request for help on a scenario. We would like to share a GET API details with a third party, using which they will retrieve data from ServiceNow table. The number of rows are estimated to be around 100,000. We want to send these huge chunk of data in small batches say 1000 records in each chunk. Request for help on how to achieve this.

Thanks and Regards

Sourabh

[Animesh Das2]

Hi @Sourabh1 ,

You need to use sysparm_limit (and mostly together with sysparm_offset) in the GET API URL shared with third party. Please go through the below article to have better clarity and how to use these two parameters in URL.

KB0727636 

If this address your question, please don't forget to mark this response correct by clicking on Accept as Solution and/or Kudos.

You may mark this helpful as well if it helps you.

Thanks, 

Animesh Das