"I’m making a call in the API Connector to capture 432 items from a table called ‘plano_contas’. Here’s how I’m doing it:
After that, I use a POST call in the API Connector to write the captured data into another table. I do it like this:
The problem is that only the first 100 items out of the 432 are being returned.
What am I doing wrong?
Your API probably has pagination, so you’ll need to make multiple API calls to get all results, or there may be a parameter to increase the page size limit. This would be detailed in the API docs.
There is a hard limit on what the API connector can return in length. I don’t recall the limit, but I’ve faced this before. You need to loop and get all items to solve this problem.
(That’s assuming the limit is in your side. Your API provider could have a 100 item limit too. Regardless, the solution is the same)
Oh, your API is the Bubble data API. Yes, iterate through the pages.