How to loop API call and collect all paginated results into 1 JSON file

Searched and found no answer. Question very similar to someone else’s (who has not yet been answered) but I’ll give it a go.

I have to retrieve 50,000 records, but the page limit is 1,000. This means I have to run the call 50 times, each time clicking on the “offset=1,000” link. The problem is this takes a lot of time to run the calls, and THEN I have to stitch together the 50 individual JSON files as a result.

I’ve done a lot of looking on the internet, looking on this forum, and found nothing. It must be (must be…?!) a fairly common requirement. I hope someone can help?

I know it involves writing a script, but don’t know what language I should use, and it involves incrementing the offsets and saving the JSON files as one file…but have no idea how to actually implement using the POSTMAN tool. :frowning:

Any help would be 100% appreciated!!?! Can I post you a lattee?

Ben