Monday.com - returning items but no data

Joey_D_Anna · October 20, 2023, 12:14am

Hi all - I just setup a locally hosted n8n server, and I’m trying to automate some tasks in monday.com
I’m running into an issue where I can’t seem to pull any data FROM monday. If i call a “create” command - i can create fields, columns, etc - so my authentication seems to be working. I can also see all my boards/etc in the node options.

But when I try to get any data - it returns the correct number of items, but zero data for anything. It behaves the same way weather i use a monday API key, or i setup an OATH application in monday developer. Both connect fine - just never return any data.

EmeraldHerald · October 20, 2023, 10:05am

Hi @Joey_D_Anna Welcome to the community

Is this happening with any other service, or only with Monday? If you try to make the request outside of n8n by using something like Postman or Insomnia, does the request return data?

It would be helpful if you have server logs or n8n logs that you could share - setting your log level to debug would give us the most information from the n8n side of things, but we might need to see what’s happening server-side, too Logging | n8n Docs

Can you also let us know the following:

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

Joey_D_Anna · October 20, 2023, 5:35pm

Hey! Yup here is more info:

-All other services I’ve tried can pull in data just fine
-Using the same API tokens from other software - I CAN return data from monday
-n8n v 1.12.0 (but i tried on the latest stable as well)
-SQLite database
-Linux, running in Docker

Here is a debug log of starting up and running that workflow:

{"level":"info","message":"Initializing n8n process","metadata":{"file":"start.js","function":"init","timestamp":"2023-10-20T17:32:12.967Z"}}
{"level":"debug","message":"Lazy Loading credentials and nodes from n8n-nodes-base","metadata":{"credentials":347,"file":"DirectoryLoader.js","function":"loadAll","nodes":446,"timestamp":"2023-10-20T17:32:13.045Z"}}
{"level":"debug","message":"Can't enable lazy-loading","metadata":{"file":"DirectoryLoader.js","function":"loadAll","timestamp":"2023-10-20T17:32:13.049Z"}}
{"level":"debug","message":"Loaded all credentials and nodes from n8n-nodes-qrcode","metadata":{"credentials":0,"file":"DirectoryLoader.js","function":"loadAll","nodes":1,"timestamp":"2023-10-20T17:32:13.060Z"}}
{"level":"debug","message":"Setting soft-deletion interval (pruning) for executions every 60 min","metadata":{"file":"execution.repository.js","function":"setSoftDeletionInterval","timestamp":"2023-10-20T17:32:13.115Z"}}
{"level":"debug","message":"Setting hard-deletion interval for executions every 15 min","metadata":{"file":"execution.repository.js","function":"setHardDeletionInterval","timestamp":"2023-10-20T17:32:13.116Z"}}
{"level":"debug","message":"[license] initializing for deviceFingerprint da824ad45fda1b156c8390a3c35cdfbb10059e671c074c19429dac59c5ae98f6","metadata":{"file":"LicenseManager.js","function":"log","timestamp":"2023-10-20T17:32:13.190Z"}}
{"level":"debug","message":"[license] attempting license renewal","metadata":{"file":"LicenseManager.js","function":"log","timestamp":"2023-10-20T17:32:13.201Z"}}
{"level":"debug","message":"License init complete","metadata":{"file":"start.js","function":"init","timestamp":"2023-10-20T17:32:13.202Z"}}
{"level":"debug","message":"Orchestration init complete","metadata":{"file":"start.js","function":"init","timestamp":"2023-10-20T17:32:13.202Z"}}
{"level":"debug","message":"Binary data service init complete","metadata":{"file":"start.js","function":"init","timestamp":"2023-10-20T17:32:13.204Z"}}
{"level":"debug","message":"External hooks init complete","metadata":{"file":"start.js","function":"init","timestamp":"2023-10-20T17:32:13.204Z"}}
{"level":"debug","message":"External secrets init complete","metadata":{"file":"start.js","function":"init","timestamp":"2023-10-20T17:32:13.206Z"}}
{"level":"debug","message":"Workflow history init complete","metadata":{"file":"start.js","function":"init","timestamp":"2023-10-20T17:32:13.206Z"}}
{"level":"debug","message":"Wait tracker querying database for waiting executions","metadata":{"file":"WaitTracker.js","function":"getWaitingExecutions","timestamp":"2023-10-20T17:32:13.424Z"}}
{"level":"debug","message":"Initializing event bus...","metadata":{"file":"MessageEventBus.js","function":"initialize","timestamp":"2023-10-20T17:32:14.021Z"}}
{"level":"debug","message":"Initializing event writer","metadata":{"file":"MessageEventBus.js","function":"initialize","timestamp":"2023-10-20T17:32:14.022Z"}}
{"level":"debug","message":"Checking for unsent event messages","metadata":{"file":"MessageEventBus.js","function":"initialize","timestamp":"2023-10-20T17:32:14.024Z"}}
{"level":"debug","message":"Start logging into /home/node/.n8n/n8nEventLog.log ","metadata":{"file":"MessageEventBus.js","function":"initialize","timestamp":"2023-10-20T17:32:14.040Z"}}
{"level":"debug","message":"MessageEventBus initialized","metadata":{"file":"MessageEventBus.js","function":"initialize","timestamp":"2023-10-20T17:32:14.041Z"}}
{"level":"debug","message":"Server ID: main-9f5ieZjEpZrba129","metadata":{"file":"Server.js","function":"start","timestamp":"2023-10-20T17:32:14.042Z"}}
{"level":"info","message":" ================================","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.083Z"}}
{"level":"info","message":"   Start Active Workflows:","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.083Z"}}
{"level":"info","message":" ================================","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.083Z"}}
{"level":"info","message":"   - PURGE SYNCTHING (ID: NjxolgHCxqMTddKi)","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.083Z"}}
{"level":"debug","message":"Initializing active workflow \"PURGE SYNCTHING\" (startup)","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.083Z","workflowId":"NjxolgHCxqMTddKi","workflowName":"PURGE SYNCTHING"}}
{"level":"verbose","message":"Successfully started workflow \"PURGE SYNCTHING\"","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.196Z","workflowId":"NjxolgHCxqMTddKi","workflowName":"PURGE SYNCTHING"}}
{"level":"info","message":"     => Started","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.196Z"}}
{"level":"info","message":"   - PAUSE SYNCTHING (ID: y43FcaDwnEpolnCO)","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.196Z"}}
{"level":"debug","message":"Initializing active workflow \"PAUSE SYNCTHING\" (startup)","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.196Z","workflowId":"y43FcaDwnEpolnCO","workflowName":"PAUSE SYNCTHING"}}
{"level":"verbose","message":"Successfully started workflow \"PAUSE SYNCTHING\"","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.206Z","workflowId":"y43FcaDwnEpolnCO","workflowName":"PAUSE SYNCTHING"}}
{"level":"info","message":"     => Started","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.206Z"}}
{"level":"info","message":"   - RESUME SYNCTHING (ID: VygTYXy3FDDORcc7)","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.206Z"}}
{"level":"debug","message":"Initializing active workflow \"RESUME SYNCTHING\" (startup)","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.206Z","workflowId":"VygTYXy3FDDORcc7","workflowName":"RESUME SYNCTHING"}}
{"level":"verbose","message":"Successfully started workflow \"RESUME SYNCTHING\"","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.215Z","workflowId":"VygTYXy3FDDORcc7","workflowName":"RESUME SYNCTHING"}}
{"level":"info","message":"     => Started","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.215Z"}}
{"level":"verbose","message":"Finished initializing active workflows (startup)","metadata":{"file":"ActiveWorkflowRunner.js","function":"init","timestamp":"2023-10-20T17:32:14.215Z"}}
{"level":"debug","message":"Add editor-UI session","metadata":{"file":"abstract.push.js","function":"add","sessionId":"nsb5fbxi7h","timestamp":"2023-10-20T17:32:14.402Z"}}
{"level":"debug","message":"Add editor-UI session","metadata":{"file":"abstract.push.js","function":"add","sessionId":"ip4qnblo9u8","timestamp":"2023-10-20T17:32:18.290Z"}}
{"level":"debug","message":"Proxying request to axios","metadata":{"file":"NodeExecuteFunctions.js","function":"proxyRequestToAxios","timestamp":"2023-10-20T17:32:20.392Z"}}
{"level":"debug","message":"Proxying request to axios","metadata":{"file":"NodeExecuteFunctions.js","function":"proxyRequestToAxios","timestamp":"2023-10-20T17:32:20.507Z"}}
{"level":"verbose","message":"Execution for workflow My workflow was assigned id 163","metadata":{"executionId":"163","file":"WorkflowRunner.js","function":"runMainProcess","timestamp":"2023-10-20T17:32:21.329Z"}}
{"level":"verbose","message":"Execution for workflow My workflow was assigned id 163","metadata":{"executionId":"163","file":"WorkflowRunner.js","function":"runMainProcess","timestamp":"2023-10-20T17:32:21.329Z"}}
{"level":"debug","message":"Execution ID 163 will run executing all nodes.","metadata":{"executionId":"163","file":"WorkflowRunner.js","function":"runMainProcess","timestamp":"2023-10-20T17:32:21.330Z"}}
{"level":"verbose","message":"Workflow execution started","metadata":{"file":"WorkflowExecute.js","function":"processRunExecutionData","timestamp":"2023-10-20T17:32:21.331Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Executing hook (hookFunctionsPush)","metadata":{"executionId":"163","file":"WorkflowExecuteAdditionalData.js","function":"workflowExecuteBefore","sessionId":"ip4qnblo9u8","timestamp":"2023-10-20T17:32:21.333Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Send data of type \"executionStarted\" to editor-UI","metadata":{"dataType":"executionStarted","file":"abstract.push.js","function":"send","sessionId":"ip4qnblo9u8","timestamp":"2023-10-20T17:32:21.333Z"}}
{"level":"debug","message":"Start processing node \"When clicking \"Execute Workflow\"\"","metadata":{"file":"WorkflowExecute.js","node":"When clicking \"Execute Workflow\"","timestamp":"2023-10-20T17:32:21.335Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Executing hook on node \"When clicking \"Execute Workflow\"\" (hookFunctionsPush)","metadata":{"executionId":"163","file":"WorkflowExecuteAdditionalData.js","function":"nodeExecuteBefore","sessionId":"ip4qnblo9u8","timestamp":"2023-10-20T17:32:21.336Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Send data of type \"nodeExecuteBefore\" to editor-UI","metadata":{"dataType":"nodeExecuteBefore","file":"abstract.push.js","function":"send","sessionId":"ip4qnblo9u8","timestamp":"2023-10-20T17:32:21.336Z"}}
{"level":"debug","message":"Running node \"When clicking \"Execute Workflow\"\" started","metadata":{"file":"WorkflowExecute.js","node":"When clicking \"Execute Workflow\"","timestamp":"2023-10-20T17:32:21.336Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Running node \"When clicking \"Execute Workflow\"\" finished successfully","metadata":{"file":"WorkflowExecute.js","node":"When clicking \"Execute Workflow\"","timestamp":"2023-10-20T17:32:21.336Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Executing hook on node \"When clicking \"Execute Workflow\"\" (hookFunctionsPush)","metadata":{"executionId":"163","file":"WorkflowExecuteAdditionalData.js","function":"nodeExecuteAfter","sessionId":"ip4qnblo9u8","timestamp":"2023-10-20T17:32:21.337Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Send data of type \"nodeExecuteAfter\" to editor-UI","metadata":{"dataType":"nodeExecuteAfter","file":"abstract.push.js","function":"send","sessionId":"ip4qnblo9u8","timestamp":"2023-10-20T17:32:21.337Z"}}
{"level":"debug","message":"Start processing node \"Monday.com\"","metadata":{"file":"WorkflowExecute.js","node":"Monday.com","timestamp":"2023-10-20T17:32:21.337Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Executing hook on node \"Monday.com\" (hookFunctionsPush)","metadata":{"executionId":"163","file":"WorkflowExecuteAdditionalData.js","function":"nodeExecuteBefore","sessionId":"ip4qnblo9u8","timestamp":"2023-10-20T17:32:21.337Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Send data of type \"nodeExecuteBefore\" to editor-UI","metadata":{"dataType":"nodeExecuteBefore","file":"abstract.push.js","function":"send","sessionId":"ip4qnblo9u8","timestamp":"2023-10-20T17:32:21.338Z"}}
{"level":"debug","message":"Running node \"Monday.com\" started","metadata":{"file":"WorkflowExecute.js","node":"Monday.com","timestamp":"2023-10-20T17:32:21.338Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Proxying request to axios","metadata":{"file":"NodeExecuteFunctions.js","function":"proxyRequestToAxios","timestamp":"2023-10-20T17:32:21.347Z"}}
{"level":"debug","message":"Running node \"Monday.com\" finished successfully","metadata":{"file":"WorkflowExecute.js","node":"Monday.com","timestamp":"2023-10-20T17:32:21.426Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Executing hook on node \"Monday.com\" (hookFunctionsPush)","metadata":{"executionId":"163","file":"WorkflowExecuteAdditionalData.js","function":"nodeExecuteAfter","sessionId":"ip4qnblo9u8","timestamp":"2023-10-20T17:32:21.426Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Send data of type \"nodeExecuteAfter\" to editor-UI","metadata":{"dataType":"nodeExecuteAfter","file":"abstract.push.js","function":"send","sessionId":"ip4qnblo9u8","timestamp":"2023-10-20T17:32:21.427Z"}}
{"level":"verbose","message":"Workflow execution finished successfully","metadata":{"file":"WorkflowExecute.js","function":"processSuccessExecution","timestamp":"2023-10-20T17:32:21.427Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Executing hook (hookFunctionsSave)","metadata":{"executionId":"163","file":"WorkflowExecuteAdditionalData.js","function":"workflowExecuteAfter","timestamp":"2023-10-20T17:32:21.428Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Save execution data to database for execution ID 163","metadata":{"executionId":"163","file":"sharedHookFunctions.js","finished":true,"function":"updateExistingExecution","stoppedAt":"2023-10-20T17:32:21.427Z","timestamp":"2023-10-20T17:32:21.429Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Executing hook (hookFunctionsPush)","metadata":{"executionId":"163","file":"WorkflowExecuteAdditionalData.js","function":"workflowExecuteAfter","sessionId":"ip4qnblo9u8","timestamp":"2023-10-20T17:32:21.446Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Save execution progress to database for execution ID 163 ","metadata":{"executionId":"163","file":"WorkflowExecuteAdditionalData.js","function":"workflowExecuteAfter","timestamp":"2023-10-20T17:32:21.446Z","workflowId":"VJBvrfRrySOzdFw7"}}
{"level":"debug","message":"Send data of type \"executionFinished\" to editor-UI","metadata":{"dataType":"executionFinished","file":"abstract.push.js","function":"send","sessionId":"ip4qnblo9u8","timestamp":"2023-10-20T17:32:21.446Z"}}
{"level":"info","message":"\nStopping n8n...","metadata":{"file":"start.js","function":"stopProcess","timestamp":"2023-10-20T17:32:51.201Z"}}
{"level":"debug","message":"Clearing soft-deletion and hard-deletion intervals for executions","metadata":{"file":"execution.repository.js","function":"clearTimers","timestamp":"2023-10-20T17:32:51.202Z"}}
{"level":"verbose","message":"Call to remove all active workflows received (removeAll)","metadata":{"file":"ActiveWorkflowRunner.js","function":"removeAll","timestamp":"2023-10-20T17:32:51.256Z"}}
{"level":"debug","message":"Shutting down event writer...","metadata":{"file":"MessageEventBus.js","function":"close","timestamp":"2023-10-20T17:32:51.278Z"}}
{"level":"debug","message":"EventBus shut down.","metadata":{"file":"MessageEventBus.js","function":"close","timestamp":"2023-10-20T17:32:51.280Z"}}

Jon · October 23, 2023, 10:43am

Hey @Joey_D_Anna,

Can you change the name of the node and remove the . that should get it working, We do have a dev ticekt opened to resolve this under ADO-1244 but I have no timeframe for a fix yet.

Joey_D_Anna · October 23, 2023, 11:34am

That was it! thanks so much

system · October 30, 2023, 11:34am

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

jan · December 13, 2023, 4:04pm

New version [email protected] got released which includes the GitHub PR 8013.