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 本製品.
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 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. |