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 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
Pseudo column 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. |