Query the Balance Summary report in Stripe.
Table Specific Information
It is used to query the Balance Summary report in Stripe.
Note: It requires a live-mode API key which we can set using the LiveAPIKey connection property. The view is not visible without mentioning the LiveAPIKey.
Creating the Report
To create a report we need to pass some required parameters.
To create a report we can also pass some optional parameters.
// This first creates the new Report and displays it. Report Creation takes time once it is created will display the report.
SELECT * FROM BalanceSummaryReport WHERE ParametersIntervalStart = '2020-12-27' AND ParametersIntervalEnd = '2020-12-28'
To query the report we can try the below queries.
SELECT * FROM BalanceSummaryReport WHERE Id IN (SELECT Id FROM Reports WHERE report_type = 'balance.summary.1')
SELECT * FROM BalanceSummaryReport WHERE Id IN ('frr_1I54dkATXQzBWNrlnaavpHGe', 'frr_1I3I59ATXQzBWNrl9VcczrDY') // This will show multiple reports
SELECT * FROM BalanceSummaryReport WHERE Id = 'frr_1I480mATXQzBWNrlYQRaLQ9x' // This will show a respective report
|One of starting_balance, ending_balance, activity or payouts.
|One of Starting balance (YYYY-MM-DD) - the balance at the start of the period, Activity - the net amount of all transactions that affected your balance except for payouts, Less payouts - the amount of payouts to your bank account, or Ending balance (YYYY-MM-DD) - the balance left over at the end of the period after subtracting payouts from the Starting balance and Activity.
|Net amount for the transactions associated with category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).
|Three-letter ISO code for the currency in which net_amount is defined.
|Unique identifier for the reports run object.
|Ending timestamp of data to be included in the report run (exclusive).
|Starting timestamp of data to be included in the report run.
|The set of output columns requested for inclusion in the report run.
|Currency of objects to be included in the report run.
|Defaults to Etc/UTC. The output timezone for all timestamps in the report.