Stripe API GET Request - Pagination Limit

Hi all!

I'm trying to make a get request to the Stripe API to return the information from the "balance_transfer" table - at the moment the query works but only with a auto-pagination limit of up to 1000, if I try to increase the limit the requests just times out. The table has currently 12K lines and counting, so is there any way of getting all the information I need in the same call?

Hopefully this makes sense! Thanks in advance :blush:

Hi @mcrisb!

Stripe's API utilizes cursor-based pagination, so you won't be to get those 12K+ results in a single call -- you'll need to paginate.

For performance reasons, you'll want to use a table with server-side pagination enabled. We have some docs on getting started with that, so please do check those out!

Let us know if you need any additional help as you follow those steps.