slowgen-transactions-express

[plush aspen]

Hi there! You are looking to retrieve the balance transactions on your Express accounts?

[deep crater]

yes i think so

[plush aspen]

Gotcha. So you can list the balance transactions via the API using https://stripe.com/docs/api/balance_transactions/list and passing the Stripe Account header of the account you want to list transactions for (see: https://stripe.com/docs/connect/authentication) or you can look into our Connect Reports from our Reporting API: https://stripe.com/docs/reports/report-types#connect

Lastly, you could use Sigma to write a SQL query if you have Sigma enabled on your account.

[deep crater]

Cheers, using the connect reports is it possible to get transaction between dates for a specific account?

[plush aspen]

Yep

[deep crater]

would you kindly show me the api docs for this

[plush aspen]

https://stripe.com/docs/api/reporting/report_run/create

[deep crater]

Hi using this with a connected account how can I get more than 100 transactions? https://stripe.com/docs/api/balance_transactions/list

[plush aspen]

You will need to paginate: https://stripe.com/docs/api/pagination

[deep crater]

Thank you!

does the pagination ignore the limit property

[plush aspen]

No the limit property still applies. You likely want to just use auto-pagination to make this easy. See: https://stripe.com/docs/api/pagination/auto

[deep crater]

do I omit the limit then? But it says default limit is 10

[plush aspen]

You likely still want to set the limit to 100 so that you have the least amount of requests

[deep crater]

OK, I get more than 100 results with auto pagination if I leave the 100 limit. So assuming it's somehow ignored

[civic haven]

well autopagination will fetch 100 items (per page) in each request, then iterate over them, then fetch the next 100 and so on