Skip to content
background-image background-image

Monday items reader

[ | version 3.1]

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

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

  • 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 ID and Group ID fields.

  • 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 ID field.

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

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

Was this page helpful?

Privacy Policy

©Integray 2024

Privacy Policy