Get a collection of assets by ids.

View-Specific Information

SELECT

Note: The Id filter is required to retrieve data from this table.

The connector uses the Monday API to process some of the filters. The connector processes other filters client-side within the connector. 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.

For example, the following queries are processed server side:

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.