Files
Retrieves a file hosted on Stripe's servers.
Table Specific Information
Select
The connector uses the Stripe API to filter the results by the following columns and operators:
- Id supports the following operator: =.
- Purpose supports the following operator: =.
- Created supports the following operators: >,>=,<,<=,=.
- AccountId supports the following operator: =.
The rest of the filter is executed client-side within the connector.
The provider supports the use of all columns as criteria in the WHERE clause of SELECT statements, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve:
SELECT * FROM Files 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 files. | |
| Created | Datetime | 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 | A filename for the file, suitable for saving to a filesystem. | |
| Links | String | A list of file links that point at this file. | |
| Purpose | String | The purpose of the uploaded file. | |
| Size | Integer | The size in bytes of the file object. | |
| Title | String | A user friendly title for the document. | |
| Type | String | The type of the file returned (e.g., csv, pdf, jpg, or png). | |
| Url | String | The URL from which the file can be downloaded using your live secret API key. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account to get files for. |