Query the Payouts summary report in Stripe.
Table Specific Information
It is used to query the Payouts summary 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.
To create a report we can also pass some optional parameters.
// 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 PayoutsSummaryReport where ParametersIntervalStart = '2020-12-27' and ParametersIntervalEnd = '2020-12-28'
To query the report we can try the below queries.
SELECT * FROM PayoutsSummaryReport where Id IN (Select Id from Reports where report_type='payouts.summary.1') SELECT * FROM PayoutsSummaryReport where Id IN ('frr_1I54dkATXQzBWNrlnaavpHGe', 'frr_1I3I59ATXQzBWNrl9VcczrDY') // This will show multiple reports SELECT * FROM PayoutsSummaryReport where Id='frr_1I480mATXQzBWNrlYQRaLQ9x' // This will show a respective report
|Reporting_Category||String||Reporting Category is a new categorization of balance transactions, meant to improve on the current type field.|
|Currency||String||Three-letter ISO code for the currency in which gross, fee and net are defined.|
|Count||Int||The number of transactions associated with the reporting_category.|
|Gross||Decimal||Sum of the gross amounts of the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).|
|Fee||Decimal||Sum of the fees paid for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).|
|Net||Decimal||Sum of the net amounts for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).|
|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.|