Get a collection of assets by ids.

Table Specific Information

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

The adapter uses the API to process some of the filters. The adapter processes other filters client-side within the adapter. 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. For example, the following queries are processed server side.

• Id supports the '=, IN' operators.

SELECT

SELECT * FROM Assets WHERE Id = '397532775'
SELECT * FROM Assets WHERE Id IN ('397532775','397532776')

Columns

Name	Type	References	Description
Id [KEY]	Int		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	Int	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.