Get metadata for a collection of objects.

Table-Specific Information

SELECT

The provider uses the Monday API to process some of the filters. The provider processes other filters client-side within the provider.

• Id supports the '=','IN' comparison operators.
• PrivacyKind supports the '=' comparison operator.
• State supports the '=' comparison operator.
• WorkspaceId supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM Objects WHERE Id = '121246772'
  SELECT * FROM Objects WHERE PrivacyKind = 'PRIVATE'
  SELECT * FROM Objects WHERE State = 'ACTIVE'
  SELECT * FROM Objects WHERE WorkspaceId = '12885370'

INSERT

The following columns can be used to create a new record:

Description, FolderId, Name, OwnerIds, PrivacyKind, SubscriberIds, WorkspaceId

The following pseudo-columns can be used to create a new record:

ObjectTypeUniqueKey, OwnerTeamIds, SubscriberTeamIds, Payload

UPDATE

The following columns can be updated:

Description, Name, OwnerIds, PrivacyKind, State, SubscriberIds

The following pseudo-column can be used to update a record:

Kind

DELETE

You can delete entries by specifying the following column:

Id

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The object's unique identifier.
Creator	String	True		The object's creator.
Description	String	False		The object's description.
FolderId	String	True		The unique identifier of the folder that contains the object.
Name	String	False		The object's name.
OwnerIds	String	False		The object's owner ids.
PrivacyKind	String	False		The object's visibility settings. The allowed values are PRIVATE, PUBLIC.
State	String	False		The object's state. The allowed values are ACTIVE, ARCHIVED, DELETED.
SubscriberIds	String	False		The object's subscriber ids.
UpdatedAt	Datetime	True		The object's last updated date.
WorkspaceId	String	True		The unique identifier of the workspace that contains the object.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
CreatedAt	String	The order in which to return objects, in this case by created date.
UsedAt	String	The order in which to return objects, in this case by used date.
ObjectTypeUniqueKey	String	The object type's unique identifier.
OwnerTeamIds	String	The unique identifiers of the new object's team owners.
SubscriberTeamIds	String	The unique identifiers of the new object's team subscribers.
Payload	String	The new object's JSON payload.
Kind	String	The role to assign the subscribers. The allowed values are OWNER, SUBSCRIBER.