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