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 connector 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 connector.
| 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. |