Retrieves a collection of assets based on provided asset IDs, such as files or media associated with items.

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.

• 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 unique identifier assigned to the file in the system for tracking and referencing purposes.
Name	String		The name of the file, as specified during upload or creation.
CreatedAt	Datetime		The date and time when the file was created or uploaded, stored in datetime format.
FileExtension	String		The file extension indicating the format or type of the file, such as '.jpg', '.png', or '.pdf'.
FileSize	Int		The size of the file in bytes, providing an indication of storage usage.
OriginalGeometry	String		The original dimensions or geometry of the asset, typically used for images or spatial files.
PublicUrl	String		A temporary public URL to access the asset directly. The URL is valid for 1 hour after being generated.
UploadedById	String	Users.Id	The unique identifier of the user who uploaded the file to the system.
Url	String		The URL to access and view the asset directly in its original form.
UrlThumbnail	String		The URL to access and view the asset as a thumbnail. This is only available for image files.