monday.com Connection Details

Introduction

Connector Version

This documentation is based on version 25.0.9368 of the connector.

Get Started

Monday Version Support

The connector leverages the Monday API to enable bidirectional access to Monday.

Establish a Connection

Connect to Monday

Monday AuditLog API

The Monday AuditLog API only supports authentication via API Token.

To generate the audit log API token:

1. Log into your monday.com account.
2. Click on your avatar (picture icon) in the top right corner of your screen.
3. Select Administration from the resulting menu.
4. In the left-hand navigation, click Security.
5. Click the Audit tab.
6. Click Monitor by API > Copy to copy your AuditLog API token.

After you retrieve the API token, set the following connection properties:

• Schema: Set this to "AuditLog".
• AuthScheme: Token
• APIToken: The audit log API token you just obtained.
• URL: Your Monday account URL. You can copy the URL of your Monday homepage after logging in. For example: https://your-account-name.monday.com/.

Monday GraphQL API

The Monday GraphQL API supports authentication via either API Token or the OAuth standard.

API Token

To connect to connector via an API Token, set the AuthScheme to Token and obtain the APIToken as follows:

1. Log into your monday.com account.
2. Click on your avatar (picture icon) in the top right corner of your screen.
3. Select Administration from the resulting menu (this requires you to have admin permissions).
4. In the left-hand navigation, click Connections, then click the API tab in the resulting page.
5. Under Personal API Token, click Create token to create an personal API token. Set the APIToken connection property to this value.
   • If you've already made a token, under Personal API Token, click the Copy button to copy your API token. Set the APIToken connection property to this value.

OAuth

Monday supports OAuth authentication only. To enable this authentication from all OAuth flows, you must set AuthScheme to OAuth, and you must create a custom OAuth application.

The following subsections describe how to authenticate to Monday from three common authentication flows:

• Desktop: a connection to a server on the user's local machine, frequently used for testing and prototyping.
• Web: access to data via a shared website.
• Headless Server: a dedicated computer that provides services to other computers and their users, which is configured to operate without a monitor and keyboard.

For information about how to create a custom OAuth application, see Creating a Custom OAuth Application.

For a complete list of connection string properties available in Monday, see Connection.

Desktop Applications

To authenticate with the credentials for a custom OAuth application, you must get and refresh the OAuth access token. After you do that, you are ready to connect.

Get and refresh the OAuth access token:

• InitiateOAuth = GETANDREFRESH. Used to automatically get and refresh the OAuthAccessToken.
• OAuthClientId = the client ID assigned when you registered your application.
• OAuthClientSecret = the client secret that was assigned when you registered your application.
• CallbackURL = the redirect URI that was defined when you registered your application.

When you connect, the connector opens Monday's OAuth endpoint in your default browser. Log in and grant permissions to the application.

After you grant permissions to the application, the connector then completes the OAuth process:

1. The connector obtains an access token from Monday and uses it to request data.
2. The OAuth values are saved in the path specified in OAuthSettingsLocation. These values persist across connections.

When the access token expires, the connector refreshes it automatically.

Automatic refresh of the OAuth access token:

To have the connector automatically refresh the OAuth access token, do the following:

1. The first time you connect to data, set the following connection parameters:
   • InitiateOAuth = REFRESH.
   • OAuthClientId = the client ID in your application settings.
   • OAuthClientSecret = the client secret in your application settings.
   • OAuthAccessToken = the access token.
   • OAuthSettingsLocation = the path where you want the connector to save the OAuth values, which persist across connections.
2. On subsequent data connections, set the following:
   • InitiateOAuth
   • OAuthSettingsLocation

Create a Custom OAuth Application

To create a custom OAuth application for use in Monday:

1. Log in to your Monday account dashboard.
2. Click the avatar icon and select Developers.
3. In MyApps, click Create App.
4. In the new application's Basic Information section, record the application's OAuthClientId and OAuthClientSecret.
5. In the new application's OAuth section, enable the following scopes:
   • boards:read
   • boards:write
   • workspaces:read
   • workspaces:write
   • docs:read
   • docs:write
   • webhooks:read
   • webhooks:write
   • users:read
   • account:read
   • updates:read
   • updates:write
   • assets:read
   • tags:read
   • teams:read
   • notifications:write
6. If this OAuth app is intended for use in a Desktop app setup, specify this redirect URL: http://localhost:3333.

GraphQL Limitations

Every GraphQL API has its own limitations. We cannot query an arbitrarily large number of nodes because the API returns an error if the connector exceeds the maximum cost. The query cost function is directly dependent on the page sizes. The connector uses its own algorithms for finding the page sizes but also gives you the freedom to tweak them based on your needs. There are two ways you can configure this behavior:

• Specify custom page size weights by including the "other:pageSizeWeights" attribute. For example, suppose we have a "Customers" table which has two nested GraphQl connections, "businesses" and "customers". If you want a specific ratio between these two entities per query, such as 200 customers per 1 business, specify "other:pageSizeWeights=1:200" in the respective script. The advantage of this attribute is that you do not bypass our logic for finding the optimal page size based on the query cost.
• Specify custom page sizes by including the "other:pageSizes" attribute. By specifying this attribute, you bypass any check we do for query cost. Specify this attribute with caution, as you will encounter API errors if you exceed the maximum cost per query. Example: "other:pageSizeWeights=10,30", retrieves at most 10 businesses and at most 30 customers per business in one query.

Important Notes

Configuration Files and Their Paths

• All references to adding configuration files and their paths refer to files and locations on the Jitterbit agent where the connector is installed. These paths are to be adjusted as appropriate depending on the agent and the operating system. If multiple agents are used in an agent group, identical files will be required on each agent.

Advanced Features

This section details a selection of advanced features of the Monday connector.

User Defined Views

The connector supports the use of user defined views, virtual tables whose contents are decided by a pre-configured user defined query. These views are useful when you cannot directly control queries being issued to the drivers. For an overview of creating and configuring custom views, see User Defined Views.

SSL Configuration

Use SSL Configuration to adjust how connector handles TLS/SSL certificate negotiations. You can choose from various certificate formats. For further information, see the SSLServerCert property under "Connection String Options".

Proxy

To configure the connector using private agent proxy settings, select the Use Proxy Settings checkbox on the connection configuration screen.

Query Processing

The connector offloads as much of the SELECT statement processing as possible to Monday and then processes the rest of the query in memory (client-side).

For further information, see Query Processing.

Log

For an overview of configuration settings that can be used to refine logging, see Logging. Only two connection properties are required for basic logging, but there are numerous features that support more refined logging, which enables you to use the LogModules connection property to specify subsets of information to be logged.

User Defined Views

The Jitterbit Connector for Monday supports the use of user defined views: user-defined virtual tables whose contents are decided by a preconfigured query. User defined views are useful in situations where you cannot directly control the query being issued to the driver; for example, when using the driver from Jitterbit.

Use a user defined view to define predicates that are always applied. If you specify additional predicates in the query to the view, they are combined with the query already defined as part of the view.

There are two ways to create user defined views:

• Create a JSON-formatted configuration file defining the views you want.
• DDL statements.

Define Views Using a Configuration File

User defined views are defined in a JSON-formatted configuration file called UserDefinedViews.json. The connector automatically detects the views specified in this file.

You can also have multiple view definitions and control them using the UserDefinedViews connection property. When you use this property, only the specified views are seen by the connector.

This user defined view configuration file is formatted so that each root element defines the name of a view, and includes a child element, called query, which contains the custom SQL query for the view.

For example:

{
    "MyView": {
        "query": "SELECT * FROM Invoices WHERE MyColumn = 'value'"
    },
    "MyView2": {
        "query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
    }
}

Use the UserDefinedViews connection property to specify the location of your JSON configuration file. For example:

"UserDefinedViews", "C:\Users\yourusername\Desktop\tmp\UserDefinedViews.json"

Define Views Using DDL Statements

The connector is also capable of creating and altering the schema via DDL Statements such as CREATE LOCAL VIEW, ALTER LOCAL VIEW, and DROP LOCAL VIEW.

Create a View

To create a new view using DDL statements, provide the view name and query as follows:

CREATE LOCAL VIEW [MyViewName] AS SELECT * FROM Customers LIMIT 20;

If no JSON file exists, the above code creates one. The view is then created in the JSON configuration file and is now discoverable. The JSON file location is specified by the UserDefinedViews connection property.

Alter a View

To alter an existing view, provide the name of an existing view alongside the new query you would like to use instead:

ALTER LOCAL VIEW [MyViewName] AS SELECT * FROM Customers WHERE TimeModified > '3/1/2020';

The view is then updated in the JSON configuration file.

Drop a View

To drop an existing view, provide the name of an existing schema alongside the new query you would like to use instead.

DROP LOCAL VIEW [MyViewName]

This removes the view from the JSON configuration file. It can no longer be queried.

Schema for User Defined Views

In order to avoid a view's name clashing with an actual entity in the data model, user defined views are exposed in the UserViews schema by default. To change the name of the schema used for UserViews, reset the UserViewsSchemaName property.

Work with User Defined Views

For example, a SQL statement with a user defined view called UserViews.RCustomers only lists customers in Raleigh:

SELECT * FROM Customers WHERE City = 'Raleigh';

An example of a query to the driver:

SELECT * FROM UserViews.RCustomers WHERE Status = 'Active';

Resulting in the effective query to the source:

SELECT * FROM Customers WHERE City = 'Raleigh' AND Status = 'Active';

That is a very simple example of a query to a user defined view that is effectively a combination of the view query and the view definition. It is possible to compose these queries in much more complex patterns. All SQL operations are allowed in both queries and are combined when appropriate.

SSL Configuration

Customize the SSL Configuration

By default, the connector attempts to negotiate TLS with the server. The server certificate is validated against the default system trusted certificate store. You can override how the certificate gets validated using the SSLServerCert connection property.

To specify another certificate, see the SSLServerCert connection property.

Data Model

The Jitterbit Connector for Monday models Monday data as an easy-to-use SQL database with tables, views, and stored procedures.

The provider exposes three kinds of schemas:

• The Information Data Model contains tables that structure and organize data related to work management on the Monday.com platform. It defines how boards, items, columns, and updates interact with each other.
• The AuditLog Data Model contains a table that provides a structured way to track and log system events and user actions.
• The Workspace Data Model contains tables that define the structure and organization of workspaces within a Monday.com account.

Information Data Model

In the Information Data Model schema, the provider models the data entities and relationships with the Monday.com platform as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your Monday.com account are immediately reflected in the provider.

Tables

The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you may have access to in your Monday account.

Common tables include:

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including duplicating items in a board, adding a file to a column value in a board, and sending a new notification to users.

Tables

The connector models the data in Monday as a list of tables in a relational database that can be queried using standard SQL statements.

Jitterbit Connector for Monday Tables

BoardDocBlocks

Retrieves content blocks from documents associated with boards. Requires a DocId or DocObjectId filter to narrow results.

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.

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

For example, the following queries are processed server side:

SELECT * FROM BoardDocBlocks WHERE DocId = '9014425'
SELECT * FROM BoardDocBlocks WHERE DocId IN ('9014425','9014490')
SELECT * FROM BoardDocBlocks WHERE DocId IN (SELECT ColumnDocId FROM Board)

INSERT

The following inputs can be used in INSERT statements:

ParentBlockId, DocId, Content, Type, AfterBlockId

INSERT INTO BoardDocBlocks (DocId,Type,Content,AfterBlockId) VALUES ('9180448','code','{"alignment":"left","direction":"ltr","deltaFormat":[{"insert":"Test"}]}','53ab947f-226f-49f5-8d43-1021f9f36431')

UPDATE

The following inputs can be used in UPDATE statements:

Content

UPDATE BoardDocBlocks SET Content='{"alignment":"left","direction":"ltr","deltaFormat":[{"insert":"NewValue"}]}' WHERE ID = '9b24043b-6ea9-46b0-9f0a-1ec226f12d21'

DELETE

You can delete entries by specifying the Id.

DELETE FROM BoardDocBlocks WHERE ID = '9b24043b-6ea9-46b0-9f0a-1ec226f12d21'

Columns

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.

BoardDocs

Fetches a collection of documents associated with boards. Requires specifying an ID or ObjectId filter to identify the desired documents.

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.
• ObjectId supports the '=','IN' comparison operators.

For example, the following queries are processed server side:

SELECT * FROM BoardDocs WHERE Id = '9014425'
SELECT * FROM BoardDocs WHERE Id IN ('9014425','9014490')
SELECT * FROM BoardDocs WHERE Id IN (SELECT ColumnDocId FROM Board)
SELECT * FROM BoardDocs WHERE ObjectId = '5499548740'
SELECT * FROM BoardDocs WHERE ObjectId IN ('5499548740','5499563743')
SELECT * FROM BoardDocs WHERE ObjectId IN (SELECT ColumnObjectId FROM Board)

INSERT

The following inputs can be used in INSERT statements:

ItemId, ColumnId

INSERT INTO BoardDocs (ItemId, ColumnId) VALUES ('1647941525','monday_doc__1')

Columns

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.

Boards

Retrieves a collection of boards, including their details and associated data.

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.
• BoardKind 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 Boards WHERE Id = '2182296646'
SELECT * FROM Boards WHERE Id IN ('2307103055', '2182296646', '2181960030')
SELECT * FROM Boards WHERE Id IN ('2307103055', '2182296646', '2181960030') AND BoardKind = 'public'
SELECT * FROM Boards WHERE BoardKind = 'public'

INSERT

The following inputs can be used in INSERT statements:

Name, Description, BoardKind, BoardFolderId, WorkspaceId, TemplateId, BoardOwnerIds, BoardOwnerTeamIds, BoardSubscriberIds, BoardSubscriberTeamIds, Empty

INSERT INTO Boards (WorkspaceId,BoardKind,Name,Description,BoardFolderId,BoardOwnerIds,BoardSubscriberTeamIds,Empty) VALUES ('3820334','public','NewBoard','A newly created board.','12689416','51688059,51085546','960990',true)

UPDATE

The following inputs can be used in UPDATE statements (note that due to API limitations only one column's value can be updated per statement):

Name, Description, Communication, State, BoardAttributes

UPDATE Boards SET Name = 'AnotherName' WHERE Id = '5549166043'
UPDATE Boards SET State = 'archived' WHERE ID = '5549166043'

DELETE

You can delete entries by specifying the Id.

DELETE FROM Boards WHERE ID = '5549166043'

Columns

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.

BoardTeams

Fetches a list of team subscribers associated with a specific board.

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.

• BoardId supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM BoardTeams WHERE BoardId='5557271485'

INSERT

The following inputs can be used in INSERT statements:

Id, BoardId, Kind

INSERT INTO BoardTeams (Id,BoardId,Kind) VALUES ('51688059','5546871560','subscriber')

DELETE

You can delete entries by specifying the ID and BoardId.

DELETE FROM BoardTeams WHERE Id='51688059' AND BoardId='5546871560'

Columns

BoardUsers

Retrieves a list of user subscribers for a specific board.

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.

• BoardId supports the '=','IN' comparison operators.
• Kind supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM BoardUsers WHERE BoardId = '5525287714'
SELECT * FROM BoardUsers WHERE Kind = 'owner'

INSERT

The following inputs can be used in INSERT statements:

Id, BoardId, Kind

INSERT INTO BoardUsers (Id,BoardId,Kind) VALUES ('51688059','5546871560','subscriber')

DELETE

You can delete entries by specifying the ID and BoardId.

DELETE FROM BoardUsers WHERE ID = '51688059' AND BoardId = '5546871560'

Columns

Columns

Retrieves the visible columns for a specific board, providing structural information.

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.
• BoardId supports the '=','IN' comparison operator.
• Type supports the '=','IN' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM Columns WHERE Id = 'name'
SELECT * FROM Columns WHERE ID IN ('name', 'status')

INSERT

The following inputs can be used in INSERT statements:

Id, BoardId, Settings, Title, Description, Type, AfterColumnId

INSERT INTO Columns (BoardId,Id,Type) VALUES ('3820334','custom_column_id_123','status')

UPDATE

The following inputs can be used in UPDATE statements (note that due to API limitations only one column's value can be updated per statement):

Title, Description

UPDATE Columns SET Title='AnotherName' WHERE Id='name' AND BoardId='3820334'

DELETE

You can delete entries by specifying the ID and BoardId.

DELETE FROM Boards WHERE Id='test' AND BoardId='3820334'

Columns

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.

CustomActivities

Retrieves metadata about custom activities in the Email and Activities timeline for enhanced activity tracking.

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.
• Name supports the '=' comparison operator.
• IconId supports the '=' comparison operator.
• Color supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM CustomActivities WHERE Id ='a91e9318-798a-44a6-80a4-49a14e23c015'
SELECT * FROM CustomActivities WHERE Color ='MEDIUM_TURQUOISE'

INSERT

The following inputs can be used in INSERT statements:

Name, IconId, Color

INSERT INTO CustomActivities (Name, IconId, Color) values ('CActivity', 'CAMERA', 'MEDIUM_TURQUOISE')

DELETE

You can delete entries by specifying the Id.

DELETE FROM CustomActivities WHERE Id='a91e9318-798a-44a6-80a4-49a14e23c015'

Columns

DocBlocks

Fetches content blocks within documents associated with workspaces.

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.

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

For example, the following queries are processed server side:

SELECT * FROM DocBlocks WHERE DocId = '9014425'
SELECT * FROM DocBlocks WHERE DocId IN ('9014425','9014490')

INSERT

The following inputs can be used in INSERT statements:

ParentBlockId, DocId, Content, Type, AfterBlockId

INSERT INTO DocBlocks (DocId,Type,Content,AfterBlockId) VALUES ('9180448','code','{"alignment":"left","direction":"ltr","deltaFormat":[{"insert":"Test"}]}','53ab947f-226f-49f5-8d43-1021f9f36431')

UPDATE

The following inputs can be used in UPDATE statements:

Content

UPDATE DocBlocks SET Content = '{"alignment":"left","direction":"ltr","deltaFormat":[{"insert":"NewValue"}]}' WHERE ID = '9b24043b-6ea9-46b0-9f0a-1ec226f12d21'

DELETE

You can delete entries by specifying the Id.

DELETE FROM DocBlocks WHERE ID = '9b24043b-6ea9-46b0-9f0a-1ec226f12d21'

Columns

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.

Docs

Retrieves a collection of documents from workspaces, including their metadata.

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.
• ObjectId supports the '=','IN' comparison operators.
• WorkspaceId supports the '=','IN' comparison operators.

For example, the following queries are processed server side:

SELECT * FROM Docs WHERE Id = '9014425'
SELECT * FROM Docs WHERE Id IN ('9014425','9014490')
SELECT * FROM Docs WHERE ObjectId = '5499548740'
SELECT * FROM Docs WHERE ObjectId IN ('5499548740','5499563743')
SELECT * FROM Docs WHERE WorkspaceId = '3578971'

INSERT

The following inputs can be used in INSERT statements:

WorkspaceId, DocKind, Name

INSERT INTO Docs (WorkspaceId,DocKind,Name) VALUES ('3820334','public','CreatedDoc')

Columns

Folders

Retrieves a collection of folders within workspaces. Excludes folders in closed workspaces unless you are subscribed to them.

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.
• WorkspaceId supports the '=','IN' comparison operators.

For example, the following queries are processed server side:

SELECT * FROM Folders WHERE Id = '12622355'
SELECT * FROM Folders WHERE WorkspaceId = '3578971'

INSERT

The following inputs can be used in INSERT statements:

ParentId, WorkspaceId, Color, Name

INSERT INTO Folders (WorkspaceId,Name,Color) VALUES ('3578971','TestFolder','BRIGHT_BLUE')

UPDATE

The following inputs can be used in UPDATE statements:

ParentId, Color, Name

UPDATE Folders SET Color = 'SUNSET', Name = 'UpdatedName' WHERE ID = '12678064'

DELETE

You can delete entries by specifying the Id.

DELETE FROM Folders WHERE Id='12678064'

Columns

Groups

Retrieves the visible groups for a specified board, providing a structured view of grouped items.

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.
• BoardId supports the '=','IN' comparison operators.

For example, the following queries are processed server side:

SELECT * FROM Groups WHERE Id = 'topics'
SELECT * FROM Groups WHERE Id IN ('topics', 'group_title')
SELECT * FROM Groups WHERE BoardId IN ('2182296646', '21822966')
SELECT * FROM Groups WHERE BoardId = '2182296646' AND ID = 'topics'

INSERT

The following inputs can be used in INSERT statements:

BoardId, Title, RelativeTo, PositionRelativeMethod

INSERT INTO Groups (BoardId,Title,Color,RelativeTo,PositionRelativeMethod) VALUES ('5525287714','NewGroup','#9CD326','testgroup','after_at')

UPDATE

The following inputs can be used in UPDATE statements (note that due to API limitations only one column's value can be updated per statement):

Archived, Color, Title, RelativePositionAfter, RelativePositionBefore

UPDATE Groups SET Color = '#9CD326' WHERE BoardId = '5525287714' AND Id = 'newgroup'
UPDATE Groups SET Archived = 'true' WHERE BoardId='5525287714' AND ID = 'newgroup'

DELETE

You can delete entries by specifying the ID and BoardId.

DELETE FROM Groups WHERE BoardId = '5525287714' AND ID = 'testgroup'

Columns

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.

Tags

Retrieves a collection of tags used to categorize and filter items across boards.

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.
• IsPrivate supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM Tags WHERE IsPrivate = true
SELECT * FROM Tags WHERE Id = '13327214'
SELECT * FROM Tags WHERE ID IN ('13327214', '13327217')

INSERT

The following inputs can be used in INSERT statements:

Name, BoardId

INSERT INTO Tags (Name) VALUES ('TestTagName')

Columns

TeamUsers

Retrieves the list of users assigned to a specific team.

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.

• TeamId supports the '=','IN' comparison operators.
• Kind supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM TeamUsers WHERE TeamId = '3578971'
SELECT * FROM TeamUsers WHERE Kind = 'owner'

INSERT

The following inputs can be used in INSERT statements:

Id, TeamId

INSERT INTO TeamUsers (Id, TeamId) VALUES ('57410919', '1127299')

DELETE

You can delete entries by specifying the ID and TeamId.

DELETE FROM TeamUsers WHERE ID = '51688059' AND TeamId = '3820334'

Columns

TimelineItems

Provides metadata about items displayed in the Email and Activities timeline.

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.

For example, the following query is processed server side:

SELECT * FROM TimelineItems WHERE ID ='2b748808-9311-4f76-80de-49baac5609e1'

INSERT

The following inputs can be used in INSERT statements:

Title, CustomActivityId, ItemId, Summary, Content, Location, Phone, Url, Timestamp, TimeRangeStartTimestamp, TimeRangeEndTimestamp

INSERT INTO TimelineItems(ItemId, CustomActivityId, Location, Title, Summary, Content, Timestamp, TimeRangeStartTimestamp, TimeRangeEndTimestamp, phone, URL) VALUES ( '7832826517', '8baadd0b-5b64-4ecb-a035-1f5824507f98', 'X', 'Migrated Timeline', 'Works summary', 'Test', '2024-06-06T18:00:30Z', '2024-04-06T15:00:30Z', '2024-05-06T19:00:30Z', '1234-5678', 'https://www.test.com');

DELETE

You can delete entries by specifying the Id.

DELETE FROM TimelineItems WHERE Id='2b748808-9311-4f76-80de-49baac5609e1'

Columns

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.

Updates

Fetches a collection of updates, including user comments, status changes, and other activity logs.

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.
• BoardId supports the '=' comparison operator.
• ItemId supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM Updates WHERE Id = '173981152'
SELECT * FROM Updates WHERE Id IN ('173981152','173981153')
SELECT * FROM Updates WHERE ItemId = '1388002886'
SELECT * FROM Updates WHERE BoardId = '1388002765'

INSERT

The following inputs can be used in INSERT statements:

Body, ItemId, ParentId

INSERT INTO Updates (ItemId,Body,ParentId) VALUES ('5525287847','This is a new reply.','2553498004')

DELETE

You can delete entries by specifying the Id.

DELETE FROM Updates WHERE ID = '2553512994'

Columns

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.

Webhooks

Fetches a collection of webhooks, including their configuration and associated events.

Table-Specific Information

Select

The connector uses the Monday API to process WHERE clause conditions built with the following column and operator. The connector processes other filters client-side within the connector.

• BoardId supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM Webhooks WHERE BoardId = '5574930939'

INSERT

The following inputs can be used in INSERT statements:

BoardId, Config, Event, Url

INSERT INTO Webhooks (BoardId,Config,Event,Url) VALUES ('5574930939','{\"columnId\":\"status\", \"columnValue\":{\"$any$\":true}}','change_status_column_value','https://test.com/')

DELETE

You can delete entries by specifying the Id.

DELETE FROM Webhooks WHERE ID = '242031214'

Columns

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.

Workspaces

Retrieves a collection of workspaces, including their names and details.

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.
• Kind supports the '=' comparison operator.
• State supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM Workspaces WHERE Id = '3578971'
SELECT * FROM Workspaces WHERE Id IN ('3578971','3578972')
SELECT * FROM Workspaces WHERE Kind = 'open'
SELECT * FROM Workspaces WHERE State = 'active'

INSERT

The following inputs can be used in INSERT statements:

Description, Kind, Name

INSERT INTO Workspaces (Name,Kind,Description) VALUES ('New Workspace','open','This is my new workspace.')

UPDATE

The following inputs can be used in INSERT statements:

Id, Description, Name, Kind

UPDATE Workspaces SET Description = 'testDescription', Name = 'testName', Kind = 'open' WHERE ID = '3819431'

DELETE

You can delete entries by specifying the Id.

DELETE FROM Workspaces WHERE ID = '3819431'

Columns

WorkspaceTeams

Retrieves the list of teams subscribed to a specific workspace.

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.

• WorkspaceId supports the '=' comparison operator.
• Kind supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM WorkspaceTeams WHERE Kind = 'owner'
SELECT * FROM WorkspaceTeams WorkspaceId = '3820334'

INSERT

The following inputs can be used in INSERT statements:

Id, WorkspaceId, Kind

INSERT INTO WorkspaceTeams (Id,WorkspaceId,Kind) VALUES ('961021','3820334','subscriber')
INSERT INTO WorkspaceTeams (Id,WorkspaceId,Kind) VALUES ('961021','3820334','owner')

DELETE

You can delete entries by specifying the ID and WorkspaceId.

DELETE FROM WorkspaceTeams WHERE ID = '961021' AND WorkspaceId = '3820334'

Columns

WorkspaceUsers

Fetches the list of users subscribed to a specific workspace.

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.

• WorkspaceId supports the '=' comparison operator.
• Kind supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM WorkspaceUsers WHERE WorkspaceId = '3578971'
SELECT * FROM WorkspaceUsers WHERE Kind = 'owner'

INSERT

The following inputs can be used in INSERT statements:

Id, WorkspaceId, Kind

INSERT INTO WorkspaceUsers (Id,WorkspaceId,Kind) VALUES ('51688059','3820334','subscriber')

DELETE

You can delete entries by specifying the ID and WorkspaceId.

DELETE FROM WorkspaceUsers WHERE ID = '51688059' AND WorkspaceId = '3820334'

Columns

Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

Jitterbit Connector for Monday Views

ActivityLogs

Fetches the activity log events associated with a specific board, detailing recent updates and actions.

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

• BoardId supports the '=','IN' comparison operators.
• UserId supports the '=','IN' comparison operators.
• CreatedAt supports the '<','<=','>','>=' comparison operators.
• ColumnId supports the '=','IN' comparison operators.
• GroupId supports the '=','IN' comparison operators.
• ItemId supports the '=','IN' comparison operators.

For example, the following queries are processed server side:

SELECT * FROM ActivityLogs WHERE BoardId IN ('2307103055', '2182296646')
SELECT * FROM ActivityLogs WHERE UserId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE ColumnId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE GroupId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE ItemId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE CreatedAt > '2022-02-17 05:12:04.419' AND CreatedAt < '2022-02-17 05:12:04.861'
SELECT * FROM ActivityLogs WHERE CreatedAt >= '2022-02-17 05:12:04.419' AND CreatedAt <= '2022-02-17 05:12:04.861'

Columns

Assets

Retrieves a collection of assets based on provided asset IDs, such as files or media associated with items.

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

For example, the following queries are processed server side:

SELECT * FROM Assets WHERE Id = '397532775'
SELECT * FROM Assets WHERE ID IN ('397532775', '397532776')

Columns

BoardViews

Fetches a list of views configured for a specific board.

View-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.
• BoardId supports the '=','IN' comparison operators.
• Type supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM BoardViews WHERE BoardId = '2182296646'
SELECT * FROM BoardViews WHERE Type = 'Chart'
SELECT * FROM BoardViews WHERE BoardId IN ('2182296646', '2181960030')

Columns

Teams

Fetches a collection of teams, including their details and associated users.

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

For example, the following queries are processed server side:

SELECT * FROM Teams WHERE Id = '565332'
SELECT * FROM Teams WHERE ID IN ('565332, 565333')

Columns

UpdateViewers

Retrieves the viewers associated with updates.

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

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

For example, the following queries are processed server side:

SELECT * FROM UpdateViewers WHERE UpdateId = '3578971'

Columns

Users

Retrieves a collection of users, including their details and roles.

View-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.
• Email supports the '=','IN' comparison operators.
• IsGuest supports the '=' comparison operator.
• IsPending supports the '=' comparison operator.
• NonActive supports the '=' comparison operator.
• TeamsIds supports the '=','IN' comparison operators when filtering for users that belong to a single team.

For example, the following queries are processed server side:

SELECT * FROM Users ORDER BY CreatedAt DESC
SELECT * FROM Users WHERE IsPending = true
SELECT * FROM Users WHERE IsGuest = true
SELECT * FROM Users WHERE Id = '27278379'
SELECT * FROM Users WHERE Id IN ('27278379', '27278377')
SELECT * FROM Users WHERE Email = 'test@cdata.com'
SELECT * FROM Users WHERE Email IN ('test@cdata.com', 'test@gmail.com')
SELECT * FROM Users WHERE TeamsIds = '915408'

Columns

Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT/INSERT/UPDATE/DELETE operations with Monday.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Monday, along with an indication of whether the procedure succeeded or failed.

Jitterbit Connector for Monday Stored Procedures

AddFileToColumn

Attaches a file to a specific column value in a board, enhancing item detail management.

Input

Result Set Columns

AddFileToUpdate

Uploads and associates a file with a specific update in Monday.

Input

Result Set Columns

BatchExtendTrialPeriod

Extends the trial period of an application for multiple selected accounts simultaneously.

Input

Result Set Columns

ClearItemUpdates

Clears updates associated with a specific item on a board.

Input

Result Set Columns

CreateDocBlock

Creates a new content block within a document in Monday.

Input

Result Set Columns

CreateDocBoard

Creates a new document within a board.

Input

Result Set Columns

CreateNotification

Sends a new notification to users, detailing specific events or updates.

Input

Result Set Columns

DownloadAsset

Downloads a file uploaded to Monday.com by specifying the corresponding asset ID.

Input

Result Set Columns

DuplicateBoard

Creates a duplicate of an existing board, including its items, columns, and structure.

Input

Result Set Columns

DuplicateGroup

Duplicates an existing group within a board.

Input

Result Set Columns

DuplicateItem

Duplicates an item within a board, including its associated data.

Input

Result Set Columns

GetOAuthAccessToken

Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Monday.

Input

Result Set Columns

GetOAuthAuthorizationURL

Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process.

Input

Result Set Columns

LikeUpdate

Adds a 'like' to a specific update, indicating approval or acknowledgment.

Input

Result Set Columns

MoveItemToBoard

Moves an item from its current board to a different board, transferring all associated data.

Input

Result Set Columns

PinUpdate

Pins a specific update, keeping it at the top of the update list for better visibility.

Input

Result Set Columns

RemoveMockAppSubscription

Removes a mock app subscription for the current account, typically used for testing purposes.

Input

Result Set Columns

SetMockAppSubscription

Sets a mock app subscription for the current account, enabling testing scenarios.

Input

Result Set Columns

UnpinUpdate

Unpins a previously pinned update, allowing it to return to its chronological position.

Input

Result Set Columns

AuditLog Data Model

In the AuditLog Data Model schema, the provider models activity logs that capture key user interactions, security events, and system changes within the Monday.com account as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your Monday.com account are immediately reflected in the provider.

Views

The Views section, which lists read-only SQL tables, model data that is read-only and cannot be updated.

Views include:

Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

Jitterbit Connector for Monday Views

AuditLogs

Retrieves the audit log events for a specific board, providing a detailed history of actions performed.

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

For example, the following queries are processed server side.

• Timestamp supports the '=, >, >=, <, <=' operators.
• UserId supports the = operator.
• IpAddress supports the = operator.
• Event supports the '=, IN' operators.

All available values for the event filter are listed and explained below:

• export-board-activity-log: Logs board Activity Log export by users.
• export-account-data: Logs account data export by admins.
• download-attachment: Logs file downloads by users.
• export-board: Logs board exports by users.
• export-dashboard: Logs dashboard exports by users.
• export-content-directory: Logs content directory exports by admins.
• login: Logs users' logins to the system.
• forgot-password: Logs users' "Forgot password?" clicks from the login page.
• logout: Logs users' logouts from the system.
• failed-login: Logs users' failed login attempts.
• user-reactivated: Logs users' reactivation by admins.
• user-deactivated: Logs users' deactivation by admins.
• user-details-deleted: Logs users' deletion by admins.
• user-invite: Logs users' invite from within the system.
• cancel-user-invite: Logs cancelled users' invite from within the system.
• user-role-change: Logs users' type change by admins.
• delete-board: Logs board deletion by users.
• delete-workspace: Logs workspace deletion by users.
• create-team: Logs team creation by users.
• delete-team: Logs team deletion by users.
• security-settings-change: Logs security settings changes by admins.
• board-broadcast-enabled: Logs board broadcast enablement by users.
• add-user-to-team: Logs users' addition to teams by users.
• remove-user-from-team: Logs users' removal from teams by users.
• add-user-to-product: Logs users' addition to Work OS Products.
• remove-user-from-product: Logs users' removal from Work OS Products.
• add-team-to-product: Logs teams' addition to Work OS Products.
• remove-team-from-product: Logs teams' removal from Work OS Products.
• api-complexity-breach-over-time: Logs API calls reaching the account limit.

The following queries are executed server-side:

SELECT * FROM AuditLogs WHERE Timestamp >= '2022-01-01T07:30:00Z' AND Timestamp <= '2022-01-02T07:30:00Z'
SELECT * FROM AuditLogs WHERE Event IN ('export-board-activity-log', 'delete-board')
SELECT * FROM AuditLogs WHERE Timestamp >= '2022-01-01T07:30:00Z' AND Timestamp <= '2022-01-02T07:30:00Z' AND Event = 'delete-board' AND UserId = 27 AND IpAddress = '123.123'

Columns

Workspace Data Model

In the Workspace Data Model schema, the provider models the workspace-related data for managing projects as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your Monday.com account are immediately reflected in the provider.

Tables

The Tables section, which details standard SQL tables, contain the tables that you may have access to in your Monday account. These tables can be modified.

Tables include:

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including uploading files, creating columns in a board, and duplicating an item in a board.

Tables

The connector models the data in Monday as a list of tables in a relational database that can be queried using standard SQL statements.

Jitterbit Connector for Monday Tables

Board

Represents a workspace board containing items, columns, and other related data used for task management.

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.

Note that multiple filters are supported server-side (when they are all connected solely by AND logical operators or solely by OR logical operators).

• ItemId supports the '=', 'IN', operators.
• Item supports the '=', 'IN', '!=', 'NOT IN', 'CONTAINS' operators.
• Text supports the '=', 'IN', '!=', 'NOT IN', 'CONTAINS' operators.
• Check supports the '=', '!=', 'IS TRUE', 'IS FALSE', 'IS NOT TRUE', 'IS NOT FALSE' operators.
• BoardRelationDisplayValue supports the '=', '!=' operators when comparing with an empty string.
• BoardRelationLinkedItemIds supports the '=', '!=' operators when comparing with an empty string.
• TagsText supports the '=', '!=' operators when comparing with an empty string.
• TagsIds supports the '=', '!=' operators when comparing with an empty string.
• CountryCode supports the '=', 'IN', '!=', 'NOT IN', 'IS NULL', 'IS NOT NULL' operators.
• CountryName supports the '=', 'CONTAINS', 'IS NULL', 'IS NOT NULL' operators.
• DependentOnDisplayValue supports the '=', '!=' operators when comparing with a string containing only one pair of square brackets '[]'.
• DependentOnLinkedItemsIds supports the '=', '!=' operators when comparing with an empty string.
• EmailLabel supports the '=', 'IN', '!=', 'NOT IN', 'CONTAINS', 'IS NULL', 'IS NOT NULL' operators.
• Hour supports the '=', 'IN', '!=', 'NOT IN' operators for time values between 04:00 inclusive and 23:59 inclusive, and the 'IS NULL', 'IS NOT NULL' operators.
• Date supports the '=', 'IN', '!=', 'NOT IN', '>', '>=', '<', '<=', 'IS NULL', 'IS NOT NULL' operators.
• Datetime supports the 'IS NULL', 'IS NOT NULL' operators.
• TimelineFrom supports the 'IS NULL', 'IS NOT NULL' operators.
• TimelineTo supports the 'IS NULL', 'IS NOT NULL' operators.
• WeekStartDate supports the 'IS NULL', 'IS NOT NULL' operators.
• WeekEndDate supports the 'IS NULL', 'IS NOT NULL' operators.
• LinkUrlText supports the '=', 'IN', '!=', 'NOT IN', 'CONTAINS', 'IS NULL', 'IS NOT NULL' operators.
• Numbers supports the '=', '!=', 'IN', 'NOT IN', '>', '>=', '<', '<=', 'IS NULL', 'IS NOT NULL' operators.
• PeopleText supports the '=', '!=' operators when comparing with an empty string.
• PeopleValue supports the 'IS NULL', 'IS NOT NULL' operators.
• DropdownText supports the '=', '!=' operators when comparing with an empty string.
• DropdownValue supports the 'IS NULL', 'IS NOT NULL' operators.
• PhoneCountryShortName supports the '=', 'IN', '!=', 'NOT IN', 'IS NULL', 'IS NOT NULL' operators.
• Phone supports the '=', 'CONTAINS', 'IS NULL', 'IS NOT NULL' operators.
• Rating supports the '=', 'IN', '!=', 'NOT IN', 'IS NULL', 'IS NOT NULL' operators.
• StatusIndex supports the '=', 'IN', '!=', 'NOT IN', 'IS NULL', 'IS NOT NULL' operators.
• StatusLabel supports the '=', 'IN', '!=', 'NOT IN', 'IS NULL', 'IS NOT NULL' operators.
• LastUpdated supports the '=', 'IN', '!=', 'NOT IN' operators.
• TimeTrackingRunning supports the '=', '!=', 'IS TRUE', 'IS FALSE', 'IS NOT TRUE', 'IS NOT FALSE' operators.
• VoteVoterIds supports the '=', '!=' operators when comparing with an empty string.

The following columns are sorted server-side when including an ORDER BY clause:

• CreatedAt supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
• UpdatedAt supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
• Item supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
• BoardRelationDisplayValue supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
• Check supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
• ColorPickerColor supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
• CountryName supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
• DependentOnDisplayValue supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
• EmailLabel supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
• Numbers supports 'ASC NULLS LAST', 'DESC NULLS FIRST'.
• LinkUrlText supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
• Phone supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
• Rating supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
• TimeTrackingDuration supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.

The following queries are processed server side:

SELECT * FROM Board
SELECT * FROM Board WHERE ItemId = '5465844671'
SELECT * FROM Board WHERE ItemId IN ('5465844671','5465844679')
SELECT * FROM Board WHERE Item = 'Item 2'
SELECT * FROM Board WHERE Item != 'Item 2'
SELECT * FROM Board WHERE Item NOT IN ('Item 1','Item 2')
SELECT * FROM Board WHERE Item Contains 'Item'
SELECT * FROM Board WHERE CONTAINS (Item,'Item')
SELECT * FROM Board WHERE NOT CONTAINS (Item,'Item')
SELECT * FROM Board WHERE Check = True
SELECT * FROM Board WHERE Check != True
SELECT * FROM Board WHERE Check IS TRUE
SELECT * FROM Board WHERE Check IS NOT TRUE
SELECT * FROM Board WHERE Check = False
SELECT * FROM Board WHERE Check != False
SELECT * FROM Board WHERE Check IS FALSE
SELECT * FROM Board WHERE Check IS NOT FALSE
SELECT * FROM Board WHERE BoardRelationLinkedItemIds = ''
SELECT * FROM Board WHERE BoardRelationLinkedItemIds != ''
SELECT * FROM Board WHERE BoardRelationDisplayValue = ''
SELECT * FROM Board WHERE BoardRelationDisplayValue != ''
SELECT * FROM Board WHERE CountryCode = 'US'
SELECT * FROM Board WHERE CountryCode != 'US'
SELECT * FROM Board WHERE CountryCode IN ('US','UK')
SELECT * FROM Board WHERE CountryCode NOT IN ('US','UK')
SELECT * FROM Board WHERE CountryCode IS NULL
SELECT * FROM Board WHERE CountryCode IS NOT NULL
SELECT * FROM Board WHERE DependentOnDisplayValue = '[]'
SELECT * FROM Board WHERE DependentOnDisplayValue != '[]'
SELECT * FROM Board WHERE Hour='07:32:00'
SELECT * FROM Board WHERE Numbers IN (12, 55)
SELECT * FROM Board WHERE Numbers = 10
SELECT * FROM Board WHERE Numbers != 10
SELECT * FROM Board WHERE Numbers > 10
SELECT * FROM Board WHERE Numbers >= 10
SELECT * FROM Board WHERE Numbers < 10
SELECT * FROM Board WHERE Numbers <= 10
SELECT * FROM Board WHERE Text = 'test' AND Numbers = 10
SELECT * FROM Board WHERE Text = 'test' OR Numbers = 10
SELECT * FROM Board ORDER BY Item
SELECT * FROM Board ORDER BY CreatedAt
SELECT * FROM Board ORDER BY UpdatedAt
SELECT * FROM Board ORDER BY Numbers ASC NULLS LAST

INSERT

The following inputs can be used in INSERT statements:

GroupId, ItemName, CreateLabelsIfMissing, BoardId, BoardRelationLinkedItemIds, Checkbox, CountryCode, CountryName, DateDate, DateDatetime, DependencyLinkedItemsIds, DropdownText, DropdownValue, Email, EmailLabel, Hour, LinkUrl, LinkUrlText, LocationLat, LocationLng, LocationAddress, LongText, Numbers, PeopleValue, PhoneCountryShortName, Phone, Rating, StatusIndex, StatusLabel, TagsIds, Text, TimelineFrom, TimelineTo, WeekStartDate, WeekEndDate, WorldClock

INSERT INTO Board (Item,GroupId,Check) VALUES ('Test','topics',true)
INSERT INTO Board (Item,GroupId,CountryCode,CountryName) VALUES ('Test','topics','US','United States')
INSERT INTO Board (Item,GroupId,Date) VALUES ('Test','topics','2023-11-16')
INSERT INTO Board (Item,GroupId,Datetime) VALUES ('Test','topics','2023-11-16 09:00:00.0-05:00')
INSERT INTO Board (Item,GroupId,DependentLinkedItemsIds) VALUES ('Test','topics','[5561036960, 5561037791]')
INSERT INTO Board (Item,GroupId,DropdownText) VALUES ('Test','topics','label1,label2')
INSERT INTO Board (Item,GroupId,DropdownText,CreateLabelsIfMissing) VALUES ('Test','topics','label3,label4','true')
INSERT INTO Board (Item,GroupId,DropdownValue) VALUES ('Test','topics','{"ids":[1,2]}')
INSERT INTO Board (Item,GroupId,Email,EmailLabel) VALUES ('Test','topics','test@mail.com','Mail')
INSERT INTO Board (Item,GroupId,Hour) VALUES ('Test','topics','09:00:00')
INSERT INTO Board (Item,GroupId,LinkUrl,LinkUrlText) VALUES ('Test','topics','https://www.test.com/', 'TestLink')
INSERT INTO Board (Item,GroupId,LocationLat,LocationLng,LocationAddress) VALUES ('Test','topics',29.9772962,31.1324955,'Giza Pyramid Complex')
INSERT INTO Board (Item,GroupId,LongText) VALUES ('Test','topics','TestText')
INSERT INTO Board (Item,GroupId,Numbers) VALUES ('Test','topics','-10')
INSERT INTO Board (Item,GroupId,PeopleValue) VALUES ('Test','topics','{"personsAndTeams":[{"id":51688059,"kind":"person"},{"id":51085546,"kind":"person"}]}')
INSERT INTO Board (Item,GroupId,PhoneCountryShortName,Phone) VALUES ('Test','topics','US','12345678900')
INSERT INTO Board (Item,GroupId,Rating) VALUES ('Test','topics','5')
INSERT INTO Board (Item,GroupId,StatusIndex) VALUES ('Test','topics','2')
INSERT INTO Board (Item,GroupId,StatusIndex,StatusLabel,CreateLabelsIfMissing) VALUES ('Test','topics','15','NewLabel','true')
INSERT INTO Board (Item,GroupId,StatusLabel) VALUES ('Test','topics','Working on it')
INSERT INTO Board (Item,GroupId,TagsIds) VALUES ('Test','topics','[20826704,20826705]')
INSERT INTO Board (Item,GroupId,BoardLinkedItemIds) VALUES ('Test','topics','[5561037791,5561036960]')
INSERT INTO Board (Item,GroupId,Text) VALUES ('Test','topics','TestText')
INSERT INTO Board (Item,GroupId,TimelineFrom,TimelineTo) VALUES ('Test','topics','2023-11-01','2023-12-04')
INSERT INTO Board (Item,GroupId,WeekStartDate,WeekEndDate) VALUES ('Test','topics','2023-11-05','2023-11-11')
INSERT INTO Board (Item,GroupId,World_Clock) VALUES ('Test','topics','Africa/Algiers')
INSERT INTO Board (Item, RelativeTo, PositionRelativeMethod) VALUES ('new', '7161109809', 'before_at')

UPDATE

The following inputs can be used in UPDATE statements:

CreateLabelsIfMissing, BoardId, BoardRelationLinkedItemIds, ItemName, Checkbox, CountryCode, CountryName, DateDate, DateDatetime, DependencyLinkedItemsIds, DropdownText, DropdownValue, Email, EmailLabel, Hour, LinkUrl, LinkUrlText, LocationLat, LocationLng, LocationAddress, LongText, Numbers, PeopleValue, PhoneCountryShortName, Phone, Rating, StatusIndex, StatusLabel, TagsIds, Text, TimelineFrom, TimelineTo, WeekStartDate, WeekEndDate, WorldClock, GroupId, State

Note that GroupId, State and column values cannot be updated in the same statement.

Also note that certain types require specifying all related columns to update the object's value (this includes Email, Link, Location, Phone, Timeline, and Week).

UPDATE Board SET GroupId = 'new_group' WHERE ItemId = '5562458608'
UPDATE Board SET State = 'archived' WHERE ItemId = '5562458608'
UPDATE Board SET ItemName = 'Test' WHERE ItemId = '5561890829'
UPDATE Board SET Check = false WHERE ItemId = '5561890829'
UPDATE Board SET CountryCode = 'US', CountryName = 'United States' WHERE ItemId = '5561890829'
UPDATE Board SET CountryCode = NULL, CountryName = NULL WHERE ItemId = '5561890829'
UPDATE Board SET Date = '2023-11-25' WHERE ItemId = '5561890829'
UPDATE Board SET Date = NULL WHERE ItemId = '5561890829'
UPDATE Board SET Datetime = '2023-11-23 04:00:00.0' WHERE ItemId = '5561890829'
UPDATE Board SET DependentLinkedItemsIds = '[5562459384, 5562458774]' WHERE ItemId = '5561890829'
UPDATE Board SET DependentLinkedItemsIds = NULL WHERE ItemId = '5561890829'
UPDATE Board SET DropdownText = 'Label1,Label2' WHERE ItemId = '5561890829'
UPDATE Board SET DropdownText = 'Label6,Label7',CreateLabelsIfMissing = 'true' WHERE ItemId = '5561890829'
UPDATE Board SET DropdownValue = '{"ids":[2,3]}' WHERE ItemId = '5561890829'
UPDATE Board SET DropdownValue = NULL WHERE ItemId = '5561890829'
UPDATE Board SET Email = 'another@email.com',EmailLabel = 'NewMail' WHERE ItemId = '5561890829'
UPDATE Board SET Email = NULL, EmailLabel = NULL WHERE ItemId = '5561890829'
UPDATE Board SET Hour = '21:00:00' WHERE ItemId = '5561890829'
UPDATE Board SET Hour = NULL WHERE ItemId = '5561890829'
UPDATE Board SET LinkUrl = 'https://www.test.com', LinkUrlText = 'TestText' WHERE ItemId = '5561890829'
UPDATE Board SET LinkUrl = NULL, LinkUrlText = NULL WHERE ItemId = '5561890829'
UPDATE Board SET LocationAddress = NULL, LocationLat = NULL, LocationLng = NULL WHERE ItemId = '5561890829'
UPDATE Board SET LocationLat = '82', LocationLng = '135', LocationAddress = 'TestLocation' WHERE ItemId = '5561890829'
UPDATE Board SET LongText = 'changed text' WHERE ItemId = '5561890829'
UPDATE Board SET LongText = NULL WHERE ItemId = '5561890829'
UPDATE Board SET Numbers = 10 WHERE ItemId = '5561890829'
UPDATE Board SET Numbers = NULL WHERE ItemId = '5561890829'
UPDATE Board SET PeopleValue = '{"personsAndTeams":[{"id":51085546,"kind":"person"},{"id":961021,"kind":"team"}]}' WHERE ItemId = '5561890829'
UPDATE Board SET PeopleValue = NULL WHERE ItemId = '5561890829'
UPDATE Board SET Phone = NULL, PhoneCountryShortName = NULL WHERE ItemId = '5561890829'
UPDATE Board SET PhoneCountryShortName = 'US', Phone = '16102347959' WHERE ItemId = '5561890829'
UPDATE Board SET Rating = '1' WHERE ItemId = '5561890829'
UPDATE Board SET Rating = NULL WHERE ItemId = '5561890829'
UPDATE Board SET StatusIndex = '2' WHERE ItemId = '5561890829'
UPDATE Board SET StatusIndex = NULL WHERE ItemId = '5561890829'
UPDATE Board SET StatusLabel = 'NewLabel', StatusIndex = '159', CreateLabelsIfMissing = 'true' WHERE ItemId = '5561890829'
UPDATE Board SET StatusLabel = 'Working on it' WHERE ItemId = '5561890829'
UPDATE Board SET TagsIds = '[20826705,20833783]' WHERE ItemId = '5561890829'
UPDATE Board SET TagsIds = NULL WHERE ItemId = '5561890829'
UPDATE Board SET BoardLinkedItemIds = NULL WHERE ItemId = '5561890829'
UPDATE Board SET BoardLinkedItemIds = '[5562459384, 5561890829, 5562458774]' WHERE ItemId = '5561890829'
UPDATE Board SET Text = 'changedText' WHERE ItemId = '5561890829'
UPDATE Board SET Text = NULL WHERE ItemId = '5561890829'
UPDATE Board SET TimelineFrom = '2023-01-01', TimelineTo = '2023-10-10' WHERE ItemId = '5561890829'
UPDATE Board SET TimelineFrom = NULL, TimelineTo = NULL WHERE ItemId = '5561890829'
UPDATE Board SET WeekStartDate = '2023-11-13', WeekEndDate = '2023-11-19' WHERE ItemId = '5561890829'
UPDATE Board SET WeekStartDate = NULL, WeekEndDate = NULL WHERE ItemId = '5561890829'
UPDATE Board SET WorldClock = 'America/New York' WHERE ItemId = '5561890829'
UPDATE Board SET WorldClock = NULL WHERE ItemId = '5561890829'

DELETE

You can delete items by specifying the ItemId.

DELETE FROM Board WHERE ItemId = '5561890829'

Columns

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.

BoardSubitems

Represents a subitems board, storing nested items related to a primary board's items for more detailed task tracking.

Table-Specific Information

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

SELECT

SELECT C.ItemId AS ChildId, C.Subitem AS ChildName, P.ItemId AS ParentId, P.Item AS ParentName FROM BoardSubitems C INNER JOIN Board P ON C.ParentItemId = P.ItemId

INSERT

The following inputs can be used in INSERT statements:

ParentItemId, GroupId, ItemName, CreateLabelsIfMissing, BoardId, BoardRelationLinkedItemIds, Checkbox, CountryCode, CountryName, DateDate, DateDatetime, DependencyLinkedItemsIds, DropdownText, DropdownValue, Email, EmailLabel, Hour, LinkUrl, LinkUrlText, LocationLat, LocationLng, LocationAddress, LongText, Numbers, PeopleValue, PhoneCountryShortName, Phone, Rating, StatusIndex, StatusLabel, TagsIds, Text, TimelineFrom, TimelineTo, WeekStartDate, WeekEndDate, WorldClock

INSERT INTO BoardSubitems (ParentItemId, Subitem) VALUES ('5562458608','NewSubItem')

UPDATE

The following inputs can be used in UPDATE statements:

CreateLabelsIfMissing, BoardId, BoardRelationLinkedItemIds, ItemName, Checkbox, CountryCode, CountryName, DateDate, DateDatetime, DependencyLinkedItemsIds, DropdownText, DropdownValue, Email, EmailLabel, Hour, LinkUrl, LinkUrlText, LocationLat, LocationLng, LocationAddress, LongText, Numbers, PeopleValue, PhoneCountryShortName, Phone, Rating, StatusIndex, StatusLabel, TagsIds, Text, TimelineFrom, TimelineTo, WeekStartDate, WeekEndDate, WorldClock

UPDATE BoardSubitems SET WorldClock = 'Europe/Amsterdam' WHERE ItemId = '5573109452'

DELETE

You can delete entries by specifying the ItemId.

DELETE FROM BoardSubItems WHERE ItemId = '5561890829'

Columns

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.

Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT/INSERT/UPDATE/DELETE operations with Monday.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Monday, along with an indication of whether the procedure succeeded or failed.

Jitterbit Connector for Monday Stored Procedures

AddFileToColumn

Attaches a file to a specific column value within a board, enhancing item management.

Input

Result Set Columns

AddFileToUpdate

Uploads and associates a file with a specific update, providing additional context.

Input

Result Set Columns

BatchExtendTrialPeriod

Extends the trial period for an application across multiple selected accounts, allowing for continued testing or evaluation.

Input

Result Set Columns

ChangeColumnMetadata

Updates the metadata or properties of a specific column in a board, such as its type or settings.

Input

Result Set Columns

ClearItemUpdates

Removes all updates associated with a specific item on a board, clearing its update history.

Input

Result Set Columns

CreateColumn

Creates a new column in a board, allowing for customized data fields.

Input

Result Set Columns

CreateDocBlock

Adds a new content block to a document associated with a workspace.

Input

Result Set Columns

CreateDocBoard

Creates a new document within a workspace board.

Input

Result Set Columns

CreateNotification

Generates a new notification for users about specific events or updates.

Input

Result Set Columns

DeleteColumn

Deletes an existing column from a board, removing its associated data.

Input

Result Set Columns

DownloadAsset

Downloads a file that was uploaded to Monday.com by specifying the asset ID.

Input

Result Set Columns

DuplicateBoard

Creates an exact copy of an existing board, including all items, columns, and structures.

Input

Result Set Columns

DuplicateGroup

Duplicates an existing group of items within a board.

Input