Skip to content
background-image background-image

Monday Item Column Values Writer

[ | version 3.2]

Connector

The connector is permitted for use of the platform background agent.

Connector processing type: Row by row!

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:

  1. Create a new task in your company in integray

  2. 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" }
    ]
    }
    
  3. Create the second step using the Monday column values writer connector

    • Configure your monday.com connection

    • Map the input schema

  4. 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:

  1. Create a new task in your company in integray

  2. Create the first step using a connector capable of data manipulation e.g. JS Mapper

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

  4. 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" }
        ]
    }
    
  5. Create the second step using the Monday column values writer connector

  6. Configure your monday.com connection

  7. Map the input schema

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

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