Query the Itemized payout reconciliation report in Stripe.

Table Specific Information

It is used to query the Itemized payout reconciliation report in Stripe.

Note: It requires a live-mode API key which we can set using the LiveAPIKey connection property. The view will not be 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.

• ParametersColumns
• ParametersCurrency
• ParametersTimezone
• ParametersReportingCategory

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

Select

To query the report we can try the below queries.

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

Columns