'out of memory exception' from the API request

Help Activities
, ,
1

I have an API request which gives 18Lakh records as a response. When I try to execute HTTP request activity gives ‘out of memory exception’.Is there any solution for this.Please find attached screenshot

image
image923×1003 72.7 KB

2

@Raj578

Try to decrease the maximum limit and get them in chunks using a loop…you can use the skiprows property to skip the rows and get the new set

Cheers

3

Well is there is an option to add some INDEX to the api call along with its url or even as a parameter so that you can get some batch of response
Then you can loop it to get all the batches one by one and get them consolidated

Cheers @Raj578