Get metadata for a collection of objects.

Table-Specific Information

SELECT

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.
• 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. 使用できる値は次のとおりです。PRIVATE, PUBLIC
State	String	False		The object's state. 使用できる値は次のとおりです。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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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. 使用できる値は次のとおりです。OWNER, SUBSCRIBER