CData Python Connector for Stripe

Build 23.0.8839

BalanceSummaryReport

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.

  • ParametersIntervalStart
  • ParametersIntervalEnd

To create a report we can also pass some optional parameters.

  • Id
  • ParametersColumns
  • ParametersCurrency
  • ParametersTimezone

//  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' 

Select

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

Columns

Name Type References Description
Category String One of starting_balance, ending_balance, activity or payouts.
Description String 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 Decimal Net amount for the transactions associated with category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).
Currency String Three-letter ISO code for the currency in which net_amount is defined.
Id [KEY] String

Reports.Id

Unique identifier for the reports run object.
ParametersIntervalEnd Datetime Ending timestamp of data to be included in the report run (exclusive).
ParametersIntervalStart Datetime Starting timestamp of data to be included in the report run.
ParametersColumns String The set of output columns requested for inclusion in the report run.
ParametersCurrency String Currency of objects to be included in the report run.
ParametersTimezone String Defaults to Etc/UTC. The output timezone for all timestamps in the report.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839