Monday.com Useful Utilities

Description

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