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