#FasterThanFlash-balance-transaction-filter
vast urchin
Hey! Which field is that exactly?
Anyway, there's no filter parameter for that so you'd need to handle that in your integration
median lily
Hey @vast urchin - While fetching balance transactions, I see there are more than 10k rows.
And Stripe only allows 100 rows to be retrieved via api
So we are hitting the API limit per transaction
vast urchin
You should use auto pagination: https://stripe.com/docs/api/pagination/auto
median lily
Can you get me a sample code please? I saw this documentation and it was not clear
Our libraries support auto-pagination. This feature easily handles fetching large lists of resources without having to manually paginate results and perform subsequent requests.
This is the only information provided, no sample code nothing
vast urchin
What library/language are you using? There's a sample right there on the side.
median lily
I'm using salesforce.
vast urchin
Ah, yeah the auto pagination feature is only available in our client libraries
median lily
So my requirement is to reconcile all the payments made via stripe in our system. So I'm fetching all the payouts and then listing the balance transactions.
However, I only need those balance transactions where "originating_transaction" field is populated. The "originating_transaction" field contains the stripe Id of the transaction.
But Balance Transactions that are being retrieved are more than 10k, and we can only fetch 100 items per callout. So our process is hitting the API callout governor limits.
vast urchin
Must this be done via the API? Could you not use the reporting feature to got a CSV export instead?
median lily
It looks like I can filter by param "type". There are only a certain type of balance transactions that I need to retrieve. Is there any way you can let me know which "type" of balance transactions have this "originating_transaction" populated?
Yes, it must be done via API. We need to automate the reconciliation of stripe payments with client's bank account
vast urchin
origination_transaction field only exists on Application Fee objects: https://stripe.com/docs/api/application_fees/object#application_fee_object-originating_transaction
median lily
BINGO!!
You da man!!
Let me give it a shot
Thanks a ton
🙂
Hey @vast urchin One last thing please - Can I filter out multiple Balance Transaction types ? If yes, then how?
I need to filter out balance transactions where type = application_fee OR type= charge
How to use OR here?
vast urchin
Unfortunately not, type is just a single string
median lily
ah okay