Monday.com icon

Monday.com

Interact with Monday.com API
Join our community

Actions26

Overview

This node operation allows you to search for items on a specified board in Monday.com by matching a specific column's value. It is useful when you want to find all items that have a particular value in one of their columns, such as finding all tasks marked "Done" or all items assigned to a certain person.

Practical examples:

  • Retrieve all items where the status column equals "Completed".
  • Find all items with a priority column set to "High".
  • Search for items with a text column containing a specific keyword.

Properties

Name Meaning
Board The Monday.com board to search within.
Column The specific column on the board to filter items by.
Column Value The value to match in the selected column (e.g., "Done", "High Priority").
Limit Maximum number of matching items to return (default is 50).

Output

The output consists of an array of JSON objects, each representing an item from the board that matches the specified column value. Each item object includes all relevant item details and its column values.

Example structure of one output item:

{
  "id": "12345",
  "name": "Task name",
  "column_values": [
    {
      "id": "status",
      "text": "Done",
      "value": "{\"index\":1,\"post_id\":null}"
    },
    ...
  ],
  ...
}

No binary data is output by this operation.

Dependencies

  • Requires an API authentication token credential for Monday.com.
  • Uses Monday.com API version "2023-10" by default.
  • No additional external services are required.

Troubleshooting

  • Common issues:

    • Providing an invalid board ID or column ID will result in no results or errors.
    • If the column value does not exactly match any itemโ€™s column value, no items will be returned.
    • Exceeding the limit parameter may cause partial results; adjust the limit accordingly.

  • Error messages:

    • Errors related to authentication indicate missing or invalid API credentials.
    • Errors about invalid board or column IDs suggest checking if the selected board and column exist and are accessible.
    • JSON parsing errors might occur if advanced column input modes are used incorrectly (not applicable here but relevant in other operations).

Links and References

Discussion