Monday.com Node error - Custom Values must be a valid JSON

Nibir_Das · February 15, 2024, 1:02pm

Describe the problem/error/question

Unable to pass variable {{ $json.formattedDate }} a Monday.com item - I want to pass it to a Date column.

What is the error message (if any)?

ERROR: Custom Values must be a valid JSON

NodeOperationError: Custom Values must be a valid JSON
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MondayCom/MondayCom.node.js:446:35)
    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:696:42)
    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:656:68

Please share your workflow

Share the output returned by the last node

ERROR: Custom Values must be a valid JSON

NodeOperationError: Custom Values must be a valid JSON
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MondayCom/MondayCom.node.js:446:35)
    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:696:42)
    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:656:68

## Information on your n8n setup
- **n8n version: 1.22.6**
- **Database (default: SQLite): How can I check this?**
- **n8n EXECUTIONS_PROCESS setting (default: own, main): How can I check this?**
- **Running n8n via (Docker, npm, n8n cloud, desktop app): cloud**
- **Operating system: Does it matter in my case when I'm running on n8n cloud**

n8n · February 15, 2024, 1:02pm

It looks like your topic is missing some important information. Could you provide the following if applicable.

n8n version:
Database (default: SQLite):
n8n EXECUTIONS_PROCESS setting (default: own, main):
Running n8n via (Docker, npm, n8n cloud, desktop app):
Operating system:

Nejc_Lukacek · February 15, 2024, 1:55pm

Try

{"date":"{{ $json.formattedDate }}"}

If that won’t work switch operation to Change Multiple Column Values
And use under Column Values:

{ "date9": {"date":"{{ $json.formattedDate }}"} }

Nibir_Das · February 15, 2024, 2:21pm

For suggestion 1, ran into error:
ERROR: Cannot read properties of undefined (reading ‘change_column_value’)

TypeError: Cannot read properties of undefined (reading 'change_column_value')
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MondayCom/MondayCom.node.js:452:58)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:696:19)
    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:656:53

Testing method 2 and posting results soon.

Nibir_Das · February 15, 2024, 2:23pm

Ran into a similar error for method 2:
ERROR: Cannot read properties of undefined (reading ‘change_multiple_column_values’)

TypeError: Cannot read properties of undefined (reading 'change_multiple_column_values')
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MondayCom/MondayCom.node.js:479:58)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:696:19)
    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:656:53

Adding more context for how the Monday.com board looks like:

The “Lab Last Seen Date” column is what I want to append through this workflow.

Nejc_Lukacek · February 15, 2024, 2:35pm

In what format is your date value? Monday expects in YYYY-MM-DD (1973-10-15),

Nibir_Das · February 15, 2024, 2:37pm

The date-time formatter node just before the error node appends it to YYYY-MM-DD. Screenshot below:

Nejc_Lukacek · February 15, 2024, 2:38pm

Sorry, in my initial post I made mistake and added extra }. I edited it. Can you try again?

Nibir_Das · February 15, 2024, 2:42pm

No luck. Error code:

TypeError: Cannot read properties of undefined (reading 'change_multiple_column_values')
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MondayCom/MondayCom.node.js:479:58)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:696:19)
    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:656:53

Nejc_Lukacek · February 15, 2024, 2:54pm

This works for me (Change Multiple Column Values)

Nejc_Lukacek · February 15, 2024, 2:57pm

Or this (Change Column Value)

Nibir_Das · February 15, 2024, 3:01pm

I’ll run some tests using the configuration you sent over. My guess is that the format in which discourse sends the date time data still doesn’t get fixed with the formatter node and how it’s set up

Nibir_Das · February 15, 2024, 3:04pm

It might also have something to do with how my output reads 90+ items for 1 date modification. If that’s the case, switching the setup to make sure that only 1 input/output is processed might fix it

Nibir_Das · February 15, 2024, 6:46pm

@Nejc_Lukacek I tried the exact same setup you did for “Change column value” using a simpler setup but ran into this ERROR: Cannot read properties of undefined (reading ‘change_column_value’)

TypeError: Cannot read properties of undefined (reading 'change_column_value')
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MondayCom/MondayCom.node.js:452:58)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:696:19)
    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:656:53

Nibir_Das · February 15, 2024, 7:31pm

@Nejc_Lukacek I’m so sorry about wasting your time. It looks like I was passing a discourse variable into a field that required a monday.com ID/variable, which is why it had a hard time getting a proper output for that node. Just got it to work!

Nibir_Das · February 15, 2024, 7:33pm

Also, the formatting you suggested {“date”:“{{ $json.formattedDate }}”} was the one that finally worked. Thank you so much for your support <3 Really appreciate it

system · May 15, 2024, 7:33pm

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.