From google sheet to webhook outgoing

Questions
21

Ohh I didn’t realize that you mean when there is an error. Well we cannot know that since its a random scenario. Sometimes success and sometimes not at all.

23

So, you have seen the error though. Any chance you can provide a dataset when next running into the error so the problem can be reproduced? My best guess is the problem is caused by the data you’re trying to insert, but without knowing what the data looks like it’s hard to say for sure.

24

Ohh this is the error

Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[object Object](DateCreated,PlanName,Status,Username,CustomerID,Title1,Desc1,...' at line 1
    at PromiseConnection.query (/usr/app/node_modules/mysql2/promise.js:93:22)
    at Object.execute (/usr/app/packages/nodes-base/nodes/MySql/MySql.node.ts:336:42)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
    at Workflow.runNode (/usr/app/packages/workflow/src/Workflow.ts:1339:19)
    at /usr/app/packages/core/src/WorkflowExecute.ts:950:29
25

image
image528×446 23.1 KB

26

I cannot give you all the json data since these were all confidential data of our company

29

I understand that you can’t hand over confidential data, but I would still need to have a dataset using which this problem can be reproduced. You can of course redact any confidential values, it’s just the structure of the data leading to this problem I’d like to understand.