Assets
Get a collection of assets by ids.
View-Specific Information
SELECT
Note: The Id filter is required to retrieve data from this table.The 本製品 uses the Monday API to process some of the filters. The 本製品 processes other filters client-side within the 本製品. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data.
- Id supports the '=','IN' comparison operators.
SELECT * FROM Assets WHERE Id = '397532775'
SELECT * FROM Assets WHERE Id IN ('397532775', '397532776')
Columns
Name | Type | References | Description |
Id [KEY] | String | The file's unique identifier. | |
Name | String | The file's name. | |
CreatedAt | Datetime | The file's creation date. | |
FileExtension | String | The file's extension. | |
FileSize | Int | The file's size in bytes. | |
OriginalGeometry | String | The original geometry of the asset. | |
PublicUrl | String | The public url to the asset, valid for 1 hour. | |
UploadedById | String |
Users.Id | The user's unique identifier. |
Url | String | The url to view the asset. | |
UrlThumbnail | String | The url to view the asset in thumbnail mode. Only available for images. |