Retrieve metadata about apps built with the apps framework.

Table-Specific Information

SELECT

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

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

• Id supports the '=','IN' comparison operators.

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

  SELECT * FROM Apps WHERE Id = '10483971'
  SELECT * FROM Apps WHERE Id IN ('10483971', '10483972')

INSERT

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

Name, Kind, Description, Permissions, Slug, WebhookURL, CollaboratorIds

UPDATE

The following columns can be updated:

Name, Kind, Description, Permissions, Slug, WebhookURL, CollaboratorIds

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The app's unique identifier.
AccountId	String	True		The app's account ID
ApiAppId	String	True		The app's unique API consumer identifier.
Name	String	False		The app's name.
Kind	String	False		The app's kind.
PhotoUrl	String	True		the app photo url
PhotoUrlSmall	String	True		the app photo url for small size
CreatedBy	String	True		The unique identifier of the user who created the app.
Description	String	False		The app's description.
Permissions	String	False		The app's permissions.
Slug	String	False		The app's slug.
Status	String	True		The app's status. The allowed values are DRAFT, LIVE.
WebhookURL	String	False		The app's webhook endpoint URL.
CreatedAt	Datetime	True		The app's creation date.
UpdatedAt	Datetime	True		The date the app was last updated.
CollaboratorIds	String	False		The app's collaborator ids.