Monday.comInstall

Overview

This node operation reads formula columns from items on a specified board in Monday.com. Formula columns contain calculated values based on other column data, and this operation allows you to retrieve those computed results programmatically.

Common scenarios where this node is useful include:

• Extracting calculated metrics or summaries from project management boards.
• Automating reporting workflows that depend on formula results.
• Integrating Monday.com formula outputs with other systems for further processing.

For example, you might use this node to fetch the total cost calculated by a formula column across multiple items or to get formatted date results from a formula column for scheduling purposes.

Properties

Output

The output is an array of JSON objects, each representing an item with its formula column data. Each object includes:

• item_id: The ID of the item.
• item_name: The name of the item.
• For each requested formula column, a property named after the column title (spaces replaced by underscores and lowercased) or the column ID, containing either:
  • The raw calculated value (number, date, boolean, etc.) if "Calculated Value" is selected.
  • The formatted text as shown in Monday.com if "Formatted Text" is selected.
  • An object with both value and text fields if "Both" is selected.

Example output snippet when requesting both value and text for a formula column named "Total Cost":

{
  "item_id": 123456,
  "item_name": "Item A",
  "total_cost": {
    "value": 1500,
    "text": "$1,500"
  }
}

Dependencies

• Requires an API key credential for Monday.com with appropriate permissions to read board and item data.
• The node uses Monday.com's GraphQL API version "2023-10" by default.
• No additional external services are required.

Troubleshooting

• Empty or missing formula columns: Ensure the selected board contains formula columns. If none are selected, the node attempts to read all formula columns.
• Invalid item IDs: If specifying item IDs, ensure they exist on the board; otherwise, no data will be returned for those IDs.
• API permission errors: Verify that the provided API token has read access to the target board and its items.
• JSON parsing errors: The node internally parses some JSON values; malformed data in Monday.com could cause issues.
• Rate limits: Monday.com API rate limits may affect large requests; consider limiting the number of items or columns per execution.

Links and References

• Monday.com Formula Column Documentation
• Monday.com API Documentation
• Monday.com GraphQL API Reference