Files
Retrieves a file hosted on Stripe's servers.
Table Specific Information
Select
The 本製品 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 本製品.
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description | |
AccountId | String | The Id of the connected account to get files for. |