FileLinks
Returns publicly accessible links to files, including their expiration, target file, and download URL details.
View-Specific Information
SELECT
The driver 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 driver.
| Column | Supported Operators |
| Id | = |
| File | = |
| Expired | = |
| AccountId | = |
| 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
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of the file link. | |
| Created | Datetime | The time at which the object was created, measured in seconds since the Unix epoch. | |
| ExpiresAt | Datetime | The time at which the file link expires and is no longer available, in epoch seconds. | |
| Expired | Boolean | Indicates whether the file link has already expired. | |
| File | String | The Id of the file object that 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, which 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 from which to retrieve file links. |