The Monday Item Column Values Writer connector enables the creation and update of the item column values in boards in monday.com work management platform. The connector allows the creation and update of the specified columns' values based on the column ID and provided value.
The column values must match the expected value formatting of the column type the user attempts to change. Dependending on the column type, some columns will accept only JSON
values, and some will accept both Strings
and JSON
values.
Some of the columns in monday.com are auto-calculated based on other properties. These columns cannot be updated via this connector. Our write connector is restricted by monday.com API functionality and therefore select columns cannot be updated.
-
Auto-calculated columns based on other properties:
Auto number column
,Formula column
,Item ID column
,Progress tracking column
. -
Select columns:
Button column
,Color picker column
,Creation log column
,Files column
,Last updated column
,Mirror column
,Time tracking column
,Vote column
.
As from version 3.1., the connector allows the creation of a new item, if you provide the ItemName
and the GroupID
as input. The columns values are working t
For more information about the monday.com columns, values, and types, visit developer.monday.com site and check the sections: Columns, Column values, Column Types Reference
Example of the input data combining input data types: String
and JSON
flowing into the connector:
Example
Use case:
On the existing monday.com board with existing items with a simple column structure (item, status, text, date) update the values for the following columns:
-
Status: "Stuck"
-
Text: "This is an integration test"
-
Date: 05.05.2023
Steps:
-
Create a new task in your company in integray
-
Create the first step using a connector capable of data manipulation e.g.
JS Mapper
-
Define output schema, by selecting the Monday Item Column Values Writer Input, which will ensure that the data will flow out of the JS mapper in the format matching the expectation of the input data in monday column values writer.
-
Write the JS mapping statement manipulating the data to fit the output schema.
{ "BoardID": "9999999999", "ItemID": "123456", "ColumnValues": [ { "ColumnID": "status", "Value": "{ \"label\": \"Stuck\" }" }, { "ColumnID": "text", "Value": "This is an integration test" }, { "ColumnID": "date", "Value": "2023-05-05" } ] }
-
-
Create the second step using the Monday column values writer connector
-
Configure your monday.com connection
-
Map the input schema
-
-
Publish and test the configuration
Expected result - your selected item on your defined board in monday.com will be updated by values defined in JS mapping statement.
Use case:
On the existing monday.com board with existing items with a simple column structure (item, status, text, date) create a new item with the values for the following columns:
-
Item: Test item
-
Status: "Done"
-
Text: "This is a test of new item creation"
-
Date: 28.09.2023
Steps:
-
Create a new task in your company in integray
-
Create the first step using a connector capable of data manipulation e.g.
JS Mapper
-
Define output schema, by selecting the Monday Item Column Values Writer Input, which will ensure that the data will flow out of the JS mapper in the format matching the expectation of the input data in monday column values writer.
-
Write the JS mapping statement manipulating the data to fit the output schema.
{ "BoardID": 9999999999, //"ItemID": "123456", -skip this element "Group": "group_id", "ItemName": "Test item" "ColumnValues": [ { "ColumnID": "status", "Value": "{ \"label\": \"Done\" }" }, { "ColumnID": "text", "Value": "This is a test of new item creation" }, { "ColumnID": "date", "Value": "2023-09-28" } ] }
-
Create the second step using the Monday column values writer connector
-
Configure your monday.com connection
-
Map the input schema
-
Publish and test the configuration
Expected result - your selected item on your defined board in monday.com will be updated by values defined in JS mapping statement.
Configuration
Monday Connection configuration
API token
The API token for the connection configuration can be found in monday.com > User avatar > Developers > Developer > My Access Tokens.
Timeout
The timeout (in seconds) for the request to monday.com work management platform. The default value is 60 seconds.
Input & Output Schema
Input
Monday item column values writer input (ver. 1.1.0)
Column | Data type | Allow null | Description |
---|---|---|---|
BoardID | string | No | Board ID |
GroupID | string | Yes | Group ID |
ItemID | string | Yes | Item ID |
ItemName | string | Yes | Item name |
ColumnValues | Monday item column value 1.0.0 |
Yes | Definition for the column update |
Monday item column value (ver. 1.0.0)
Column | Data type | Allow null | Description |
---|---|---|---|
ColumnID | string | No | Column ID |
Value | JSON | No | Column value (simple text or JSON - based on column type) |
Output
This connector does not require a schema.
Release notes
3.2.0
- Migration to API-Version 2023-10
3.1.2
- Updated package binaries because of changes in another included connector
3.0.4
- Updated package binaries because of changes in another included connector
3.1.1
- Extension of input schema. Enablement of new item creation if no ItemID provided
3.0.1
- Right processing API-Version header
3.0.0
- First release