Query the Itemized balance change from Activity report in Stripe.

Table Specific Information

Used to query the itemized balance change from the Activity 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:

• ParametersColumns
• ParametersCurrency
• ParametersTimezone
• ParametersReportingCategory

//  This first creates the new Report and displays it. Report Creation takes time once it is created will display the report.
SELECT * FROM ItemizedBalanceChangeFromActivityReport WHERE ParametersIntervalStart = '2020-12-27' AND ParametersIntervalEnd = '2020-12-28' 

Select

You can run the following queries to retrieve report data:

SELECT * FROM ItemizedBalanceChangeFromActivityReport WHERE Id IN (SELECT Id FROM Reports WHERE report_type = 'balance_change_from_activity.itemized.3')
SELECT * FROM ItemizedBalanceChangeFromActivityReport WHERE Id IN ('frr_1I54dkATXQzBWNrlnaavpHGe', 'frr_1I3I59ATXQzBWNrl9VcczrDY') // This will show multiple reports
SELECT * FROM ItemizedBalanceChangeFromActivityReport WHERE Id = 'frr_1I480mATXQzBWNrlYQRaLQ9x' // This will show a respective report

Columns