psarojanand-pagination | Stripe Developers | Page 1

slate geode Aug 4, 2022, 6:04 AM

#

👋 Happy to help

#

Can you share what you want to achieve?

slate vine Aug 4, 2022, 6:15 AM

#

The above Payout id - po_1LPgmpPOIi7gUqPA5baI1Fer has 463 transfers under it.
when I am fetching the record I received only 100 at time. How to fetch all or next set of data for this Payout.
I tried limit and starting_after but it didn't work
$payout_details = \Stripe\BalanceTransaction::all(['limit'=>500,'payout' => 'po_1LPgmpPOIi7gUqPA5baI1Fer','expand' => ['data.source.source_transfer.source_transaction']],['stripe_account'=>"acct_xxxxx"],['starting_after'=>'txn_1LPKVpPOIi7gUqPAJuQpxgBb']);

slate geode Aug 4, 2022, 6:16 AM

#

I see! You can use auto-pagination provided by Stripe, so that you don't have to handle pagination on your own for large lists: https://stripe.com/docs/api/pagination/auto

slate vine Aug 4, 2022, 6:17 AM

#

ok 2 mins let me check

slate geode Aug 4, 2022, 6:20 AM

#

In your case, limit of 500 won't work since List Retrieval API is limited to 100 objects max: https://stripe.com/docs/api/pagination#pagination-limit

#

So, you can:

manually loop through by using starting_after or ending_before; OR
use auto-pagination provided by library: https://stripe.com/docs/api/pagination/auto

#

In either case, you can refer to the video here: https://stripe.com/docs/videos/developer-foundations?video=pagination&lang=php

slate vine Aug 4, 2022, 6:24 AM

#

ok auto pagination did work but not for all records as I said this payoutid has 460 records but in API I have received only 280

#

I will watch the video

#

if it didn't resolve my problem will come back

#

Thanks for your kind help

slate geode Aug 4, 2022, 6:27 AM

#

No problem! Happy to help 😄

#psarojanand-pagination