#shawon3719
vapid spear
pallid gale
Hi! Let me help you with this.
pallid gale
There's no way to get this number via API. The best way is to use the Reports API: https://stripe.com/docs/reports/report-types#connect
Another way is to to sum up all the Balance Transactions: https://stripe.com/docs/api/balance_transactions/list
tulip pebble
it seems the sum of balance transaction is different than the lifetime balances shows here
can you please refer me to the reporting API?
tulip pebble
Another way is to to sum up all the Balance Transactions: <https://stripe.com/do...
As it shows the latest 10 data. didn't find any pagination parameter.
quiet torrent
Hi! I'm taking over this thread.
As it shows the latest 10 data. didn't find any pagination parameter.
You can use auto-pagination https://stripe.com/docs/api/pagination/auto
can you please refer me to the reporting API?
https://stripe.com/docs/reports/api
quiet torrent
Happy to help 🙂
tulip pebble
so can you please help me to find out the lifetime balance report of a connected account?
**while I run this code - **
public function getBalanceReport(){ return \Stripe\Reporting\ReportType::retrieve('connected_account_balance_change_from_activity.itemized.1',[ 'interval_start' => '1669890804', 'interval_end' => '1670493278', 'connected_account' => 'acct_xxxx', 'currency' => 'dkk', ]); }
**I'm getting nothing but this - **
"report_data": { "id": "connected_account_balance_change_from_activity.itemized.1", "object": "reporting.report_type", "data_available_end": 1670457600, "data_available_start": 1633478400, "default_columns": [ "balance_transaction_id", "created_utc", "available_on_utc", "currency", "gross", "fee", "net", "reporting_category", "source_id", "description", "customer_facing_amount", "customer_facing_currency", "automatic_payout_id", "automatic_payout_effective_at", "charge_id", "connected_account" ], "livemode": false, "name": "Connected account itemized balance change from activity", "updated": 1670481178, "version": 1 }
@quiet torrent
quiet torrent
Sorry for the delay, Stripe is busy. Have you done what is explained in the doc I shared:
When first created, the object appears with status="pending"
When the run completes, Stripe updates the object, and it has a status of succeeded.
It also has a nested result object, containing a URL that you can use to access the file with your API key.
tulip pebble
which report type should I use here ?
public function getBalanceReport(){ return \Stripe\Reporting\ReportType::retrieve('connected_account_balance_change_from_activity.itemized.1',[ 'interval_start' => '1669890804', 'interval_end' => '1670493278', 'connected_account' => 'acct_xxxx', 'currency' => 'dkk', ]); }
quiet torrent
What's the issue with the code you just shared?