FileLinks

Returns a list of file links.

Table Specific Information

Select

Server-Side Query Support

The connector 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 connector.

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 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。