Monday.com Useful Utilities

This template is a set of building blocks to access Monday.com in ways not supported by the official Monday node.

Prerequisites

• Monday account and Monday credentials.

Included are setups to:

• Find a column value by the column's name (instead of a numerical index which can change when board structure is changed)
• Find a column value by the column's ID (again, instead of using a numerical index)
• Pull a board relation column, and get all the related pulses
• Pull an items subitems and split them out
• Upload a file to an item's files field

Setup

• Create a Monday.com credential
• Update the nodes in the template to use your credential
• Copy/Paste the nodes you need from this template into any other workflow
• To retreive a column by name:
  • Route a Monday.com node that gets an item to the COLUMN BY NAME node
  • Edit the COLUMN BY NAME node, and enter the name in the first line of code.
• To retreive a column by its ID:
  • Follow Monday.com's instructions to locate the column's ID
  • Route a Monday.com node that gets an item to the COLUMN BY ID node -Edit the COLUMN BY ID node, and enter the ID in the first line of code.
• To retreive all linked pulses from a Board Relation column:
  • Route a Monday.com node that gets an item to the GET BOARD RELATION node
  • Edit the GET BOARD RELATION node to specify the column name.
  • All linked pulses will be retrieved by the subsequent PULL LINKEDPULSE node
• To pull all subitems from an item:
  • Route a Monday.com node that gets an item to the PULL SUBITEMS node
  • All subitems will be retrieved by the subsequent GET EACH SUBITEM node
• To upload a File:
  • Repalce the Convert to File node with whatever node you are using to output your binary file data
  • Enable the MONDAY UPLOAD node
  • If the destination column is named anything other then the default of "file" - edit the MONDAY UPLOAD node and change column_id:"file" in the first Value field to match the name of your file column