This version of the connector is outdated. Show recent version
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 None
or By Group 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
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.
Filtering type
Type of search filtering:
None
- No filter will be applied. None is set as the default value.
By Group ID
- The items will be filtered based on the provided group ID within the specified Board.
By Item ID
- Filter based on the item ID. The result will contain just one matching item.
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.
Column Values Filter
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.0.1
- Right processing API-Version header
3.0.0
- First release