SSIS Components for Monday

Build 24.0.9062

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062