Monday Parser icon

Monday Parser

Parse and structure Monday.com data with advanced column type handling

Transform Data

AI-generated

Overview

The Monday Parser node is designed to parse and transform data from Monday.com, a project management platform, into a structured and enriched JSON format. It handles various advanced column types specific to Monday.com, such as status, checkbox, date, people, and more, converting raw input data into a more usable and detailed structure. This node is beneficial for workflows that need to integrate Monday.com data with other systems or perform detailed data analysis and reporting.

Use Case Examples

  1. Transform raw Monday.com JSON data into structured objects with detailed column information for easier processing in automation workflows.
  2. Parse complex Monday.com column types like status, people, and timelines to extract meaningful attributes such as labels, dates, and user IDs.

Properties

Name Meaning
Input JSON The raw Monday.com data in JSON format that needs to be transformed and structured.

Output

JSON

  • id - The unique identifier of the Monday.com item.
  • name - The name of the Monday.com item.
  • created_at - The creation timestamp of the item.
  • state - The current state of the item.
  • email - Email associated with the item, if available.
  • updated_at - Timestamp when the item was last updated.
  • board
    • id - The ID of the board to which the item belongs.
  • group
    • id - The ID of the group containing the item.
    • title - The title of the group containing the item.
    • deleted - Indicates if the group is deleted (always false here).
    • archived - Indicates if the group is archived (always false here).
  • assets - An array for assets related to the item (empty by default).
  • parent_item - Reference to a parent item if applicable (null by default).
  • subitems - Array of subitems related to the item (empty by default).
  • creator_id - ID of the creator of the item, extracted from creation log column.
  • column_values - Array of column value objects with id, value, text, title, and additional info.
  • mappable_column_values - Object mapping column IDs to their parsed and simplified values for easy access.

Troubleshooting

  • Ensure the input JSON is valid and correctly formatted Monday.com data to avoid parsing errors.
  • If the node throws an 'Unsupported operation' error, verify that the operation parameter is set to 'Transform Data'.
  • Errors during parsing of specific column types may occur if the data structure is unexpected; check the input data for consistency.

Links

Discussion