JDBC Driver for Monday

Build 22.0.8462

Assets

Get a collection of assets by ids.

Table Specific Information

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

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462