Skip to content
background-image background-image

monday

Monday Item Parser

  • Version

    3.0

  • Agent restriction

    None

  • Processing type

    Row by row

  • Multi-input step

    Not Supported

A connector parsing the Monday item column values data received read from specified board.

Currently, the Monday Item Reader - the connector ensures the connection to Monday and reads the items column values data, and returns it in Monday specific format. To parse the outcome into a simple and more user-friendly format for further use, you need to use rather complex Java script mapping including function find to be used in embedded complex schemas containing Group and ColumnValues data. This may not be a simple way of working with the data for less Java script experienced users.

The Monday Item Parser connector offers you a conversion of the existing outcome from the Monday Item Reader connector into 'easier to read', and 'work with' output format. The output data schema will parse the output in a way, where the Group and ColumnValues will not be embedded complex schemas as it is in the case of the Monday item reader, but for the Group, the data will be displayed as flat schema and the variable content of the ColumnValue will be represented by JSON.

Comparison of the output schemas of the two connectors: Monday item reader and the simplified Monday Item Parser.

HELP connector academy Monday Item Parser comparison of output schemas

Monday Item Parser output converted to JSON:

{
    "ID":"abc",
    "Name":"abc",
    "GroupID":"abc",
    "GroupName":"abc",
    "ColumnValues":{
        "text_1":{
            "Name":"abc",
            "PlainValue":"abc",
            "Value":"JSON"
        },
        "text_2":{
            "Name":"abc",
            "PlainValue":"abc",
            "Value":"JSON"
        },
        "status":{
            "Name":"abc",
            "PlainValue":"abc",
            "Value":"JSON"
        },
        "dev__module":{
            "Name":"abc",
            "PlainValue":"abc",
            "Value":"JSON"
        }

    }
}

Configuration

This connector does not include any configuration.

Input & Output Schema

Input

Monday item parser input (ver. 1.0.0.)

Column Data type Allow null Description
ID string No Item ID (pulseID)
Name string No Item name
Group Monday item parser group v1.0.0 No Group data
ColumnValues Monday item parser column value v1.0.0 No Column value data

Monday item parser group (ver. 1.0.0)

Column Data type Allow null Description
ID string No Group ID
Name string No Group name

Monday item parser column value (ver. 1.0.0)

Column Data type Allow null Description
ID string No Column ID
Name string No Column name
PlainValue string Yes Column simple text value
Value string Yes Column value including all column attributes

Output

Monday item parser output (ver. 1.0.0.)

Column Data type Allow null Description
ID string No Item ID (pulseID)
Name string No Item name
GroupID string No Group ID
GroupName string No Group name
ColumnValues JSON No Column value including all column attributes

Release notes

3.0.1

  • Right processing API-Version header

3.0.0

  • First release