FileLinks
Returns a list of file links.
View-Specific Information
SELECT
The provider 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 provider.
| Column | Supported Operators |
| Id | = |
| File | = |
| Expired | = |
| Created | <, <=, =, >, >= |
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 the file link. | |
| Created | Datetime | The date and 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 | Indicates whether 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 an object. | |
| Url | String | The URL from which the file can be downloaded using your live secret API key. | |
| Livemode | Boolean | Indicates whether the object exists in live mode. The value is true in live mode and false in test mode. |
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 to get files for. |