FileLinks
Returns a list of file links.
Table Specific Information
Select
Server-Side Query Support
The 本製品 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 本製品.
- Id supports the following operator: =.
- File supports the following operator: =.
- Expired supports the following operator: =.
- Created supports the following operators: <, <=, =, >, >=.
You can select from FileLinks with the following queries:
SELECT * FROM FileLinks WHERE Id = 'filelink_1JY7zL2eZv' SELECT * FROM FileLinks WHERE File = 'file_1JY7zL2eZv' SELECT * FROM FileLinks WHERE Expired = false SELECT * FROM FileLinks WHERE Livemode = true
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. | |
Expired | Boolean | Returns true if the link is already expired. | |
File | String | The file object this link points to. | |
MetadataAggregate | String | The set of key/value pairs that you can attach to a an object. | |
Url | String | The URL from which the file can be downloaded using your live secret API key. | |
Livemode | Boolean | Has the value true if the object exists in live mode or the value false if the object exists in test mode. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description | |
AccountId | String | The Id of the connected account to get files for. |