The Monady Items Reader connector enables reading of items information recorded in the monday.com boards. The connector returns information about item and all existing columns and their values in the specified board. You can narrow down the set of returned values by using built-in filter options.
Data returned on item:
ID - Item ID of the returned pulse (item).
Name - Name / description of the returned pulse (item).
GroupID- Group ID of the group in the specified board, where the pulse (item) is located.
GroupName - Group name / description of the group in the specified board, where the pulse (item) is located.
Data returned on columns:
ID - Column ID.
Name - Column name defined by the user.
PlainValue - The value visible to monday user in respective column. Example: column type: Date, plain vlaue: "2023-05-04".
Value - System recorded value in JSON format. Example: column type: Date, value:
{"date":"2023-05-04","icon":null,"changed_at":"2023-05-06T15:00:43.567Z"}
The configuration of the connector allows filtering to limit the returned result. In case the filtering type is set to By Group ID or By Board ID, the connector offers additional option to narrow down the results by using Filter by column values using the column plain values.
Warning
The connector doesn't use the processed data pointer (feature indicating already processed data) and returns always entire set of items matching the filter conditions.
Example of one item related data:
The board containing one group and one item with following columns configured: Person, Status, Date, Text, Dropdown, Numbers, Priority, Label, Checkbox, Files, Timeline, monday Doc
[
{
"ID": "4428654417",
"Name": "Item 1",
"Group": [
{
"ID": "topics",
"Name": "Group Title"
}
],
"ColumnValues": [
{
"ID": "person",
"Name": "Person",
"PlainValue": "User Name",
"Value": "{\"changed_at\":\"2023-05-06T15:01:00.623Z\",\"personsAndTeams\":[{\"id\":12037235,\"kind\":\"person\"}]}"
},
{
"ID": "status",
"Name": "Status",
"PlainValue": "Working on it",
"Value": "{\"index\":0,\"post_id\":2150780368,\"changed_at\":\"2023-05-11T10:12:33.855Z\"}"
},
{
"ID": "date4",
"Name": "Date",
"PlainValue": "2023-05-04",
"Value": "{\"date\":\"2023-05-04\",\"icon\":null,\"changed_at\":\"2023-05-06T15:00:43.567Z\"}"
},
{
"ID": "text",
"Name": "Text",
"PlainValue": "Test text",
"Value": "\"Test text\""
},
{
"ID": "dropdown",
"Name": "Dropdown",
"PlainValue": "Value 1, Value 2, Value 3",
"Value": "{\"ids\":[1,2,3]}"
},
{
"ID": "numbers",
"Name": "Numbers",
"PlainValue": "7500",
"Value": "\"7500\""
},
{
"ID": "priority",
"Name": "Priority",
"PlainValue": "Critical ⚠️️",
"Value": "{\"index\":10,\"post_id\":null,\"changed_at\":\"2023-05-06T15:02:24.564Z\"}"
},
{
"ID": "label",
"Name": "Label",
"PlainValue": "Label 1",
"Value": "{\"index\":105,\"post_id\":null,\"changed_at\":\"2023-05-06T15:02:32.880Z\"}"
},
{
"ID": "checkbox",
"Name": "Checkbox",
"PlainValue": "v",
"Value": "{\"checked\":\"true\",\"changed_at\":\"2023-05-06T15:02:43.133Z\"}"
},
{
"ID": "files",
"Name": "Files",
"PlainValue": "https://.......monday.com/protected_static/3588718/resources/871824822/integray%20test%20board.png",
"Value": "{\"files\":[{\"name\":\"integray test board.png\",\"assetId\":871824822,\"isImage\":\"true\",\"fileType\":\"ASSET\",\"createdAt\":1683799990662,\"createdBy\":\"12037235\"}]}"
},
{
"ID": "timeline",
"Name": "Timeline",
"PlainValue": "2023-05-01 - 2023-05-05",
"Value": "{\"to\":\"2023-05-05\",\"from\":\"2023-05-01\",\"changed_at\":\"2023-05-06T15:05:25.425Z\"}"
},
{
"ID": "monday_doc",
"Name": "monday Doc",
"PlainValue": "https://.......monday.com/docs/4455425886",
"Value": "{\"files\":[{\"name\":\"Item 1 on the integray test board\",\"fileId\":\"d19b04ac-1ed0-549c-11e2-95bdabb01149\",\"isImage\":\"false\",\"fileType\":\"MONDAY_DOC\",\"objectId\":4455425886,\"createdAt\":1683800000845,\"createdBy\":\"12037235\",\"linkToFile\":\"https://.......monday.com/docs/4455425886\"}]}"
}
]
}
]
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.
Monday items reader configuration version 1.1
Filtering type
Type of search filtering:
-
By Board ID: The items will be filtered based on the provided Board ID. It is required to fill in the
Board IDfield. -
By Group ID: The items will be filtered based on the provided group ID within the specified Board. It is required to fill in the
Board IDandGroup IDfields. -
By Item ID: Filter based on the item ID. The result will contain just one matching item. It is required to fill in the
Item IDfield.
Board ID
The ID of the monday.com board from where the connector will retrieve data on items and columns.
You can use relevant placeholders as input data, e.g. ${input.ID} will be replaced by the value in found ID value.
Group ID
The ID of the group in the specified board from where the connector will retrieve data on items and columns. You can use relevant placeholders as input data, e.g. ${input.ID} will be replaced by the value in found ID value.
Warning
You can only use one Group ID value for filtering. The connector configuration doesn't support multiple values.
Item ID
The ID of the item needs to match the existing item id of an item in the board to return the single pulse (item) result. You can use relevant placeholders as input data, e.g. ${input.ID} will be replaced by the value found in ID value.
Filter by column values
Use the filter by column values to narrow down the result set of items. Fill in the column id of the column you want to use for filtering and fill in the column value the results have to match.
In case you will use more than one column, note that the logical operator used with the conditions is AND i.e. all conditions have to be met to return the result.
Column ID - The column ID of the column the result will be filtered by.
Column Value - The column value that must be matched to be included in the filtered result set.
Input & Output Schema
Input
Optional
Output
Monday items reader output (ver. 1.0.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | string | No | Item id |
| Name | string | No | Item name |
| Group | Monday items reader group 1.0.0 |
No | Group |
| ColumnValues | Monday items reader column value 1.0.0 |
No | Column value |
Monday items reader group (ver. 1.0.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | string | No | Group ID |
| Name | string | No | Group name |
Monday items reader 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 value as plain text (used by filtering) |
| Value | string | Yes | Column value as text or json formatu (according to column type) |
Release notes
3.1.0
- Migration to API-Version 2023-10
3.0.2
- Updated package binaries because of changes in another included connector
3.0.1
- Right processing API-Version header
3.0.0
- First release