Does anybody else have trouble trying to use pagination with n8n API calls? I have a project set up that needs 3 different API calls. Two of them are for 6,000 and 13,000 rows and they work just fine, but the third is for 960K rows of data!
From troubleshooting I believe it is not my pagination but the sheer size of the call that makes the workflow crash. Has anybody made a successful API call as large as this one?
My current next thought is to limit the API call and loop it with a set batch size and an offset parameter.
Here’s a picture of the error I get! Thanks for the help in advance everyone!