Skip to content
background-image background-image

Monday items reader

[ | version 3.0]

Connector

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

Connector processing type: Row by row!

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.

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