ReportTypes
Returns the available report types, including data availability ranges, default columns, and version details.
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 | The string representing the object's type. Objects of the same type share the same value. | |
| DataAvailableEnd | Datetime | The most recent time for which this report type is available, measured in seconds since the Unix epoch. | |
| DataAvailableStart | Datetime | The earliest time for which this report type is available, measured in seconds since the Unix epoch. | |
| DefaultColumns | String | The 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 value is null. | |
| Livemode | Boolean | Indicates whether the object exists in live mode. Has the value true if the object exists in live mode, or the value false if the object exists in test mode. | |
| Name | String | The human-readable name of the report type. | |
| Updated | Datetime | The time at which this report type was last updated, measured in seconds since the Unix epoch. | |
| Version | Integer | The version of the report type. Different versions of a report type with the same Id share the same purpose, but may take different run parameters or have different result schemas. |