Files
Returns files hosted on Stripe's servers, including their purpose, type, size, and download URL details.
View-Specific Information
SELECT
The add-in uses the Stripe API to filter the results by the following columns and operators:
| Column | Supported Operators |
| Id | = |
| Purpose | = |
| Created | >, >=, <, <=, = |
| AccountId | = |
The rest of the filter is executed client-side within the add-in.
You can select from Files with the following queries:
SELECT * FROM Files WHERE Id = '123321'
SELECT * FROM Files WHERE Purpose = 'dispute_evidence'
SELECT * FROM Files WHERE Created >= '2023-07-14T05:36:46.000-04:00'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of the file. | |
| Created | Datetime | The time at which the object was created, measured in seconds since the Unix epoch. | |
| ExpiresAt | Datetime | The time at which the file expires and is no longer available, in epoch seconds. | |
| Filename | String | The file name for the file, suitable for saving to a file system. | |
| Links | String | The list of file links that point to this file. | |
| Purpose | String | The purpose of the uploaded file. | |
| Size | Integer | The size of the file object, in bytes. | |
| Title | String | A user-friendly title for the document. | |
| Type | String | The type of the file returned, such as csv, pdf, jpg, or png. | |
| Url | String | The URL from which the file can be downloaded using your live secret API key. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account from which to retrieve files. |