JDBC Driver for Stripe

Build 24.0.9062

BalanceSummaryReport

Query the Balance Summary report in Stripe.

Table Specific Information

Used to query the Balance Summary report in Stripe.

Note: This report requires a live-mode API key, which can be set using the LiveAPIKey connection property. This view is not accessible without specifying the LiveAPIKey.

Creating the Report

To create a report, the following parameters are required:

  • ParametersIntervalStart
  • ParametersIntervalEnd

You can also include the following 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

You can run the following queries to retrieve report data:

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 24.0.9062