ReportTypes
Returns the available report types in Stripe.
View-Specific Information
Note: This report type requires a live-mode API key, which can be set using the LiveAPIKey connection property. This view is not accessible without specifying the LiveAPIKey.
SELECT
The add-in uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the add-in.
| Column | Supported Operators |
| Id | =, IN |
You can select from ReportTypes with the following queries:
SELECT * FROM ReportTypes
SELECT * FROM ReportTypes WHERE Id = 'balance.summary.1'
SELECT * FROM ReportTypes WHERE Id IN ('balance.summary.1', 'balance_change_from_activity.itemized.1')
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of the Report Type, such as balance.summary.1. | |
| Object | String | String representing the object's type. Objects of the same type share the same value. | |
| DataAvailableEnd | Datetime | The most recent date and time for which this Report Type is available, measured in seconds since the Unix epoch. | |
| DataAvailableStart | Datetime | The earliest date and time for which this Report Type is available, measured in seconds since the Unix epoch. | |
| DefaultColumns | String | List of column names that are included by default when this Report Type is run. (If the Report Type does not support the columns parameter, this is null.) | |
| Livemode | Boolean | Indicates whether the object exists in live mode. The value is true in live mode and false in test mode. | |
| Name | String | Human-readable name of the Report Type. | |
| Updated | Datetime | The date and time at which this Report Type was last updated, measured in seconds since the Unix epoch. | |
| Version | Integer | Version of the Report Type. Different versions report with the same Id have the same purpose, but may take different run parameters or have different result schemas. |