Inserting table row from n8n webhook

This seems like a very basic ask, so please pardon the newby issue:

JSON data from a Drupal 9 webform >> n8n webhook >> create new row in Coda table

Here’s the error message:

{“message”:“400 - {“statusCode”:400,“statusMessage”:“Bad Request”,“message”:“Invalid \“value\” field in a cell - must be a boolean, number, string, or array thereof.”}”,“name”:“Error”,“stack”:“Error: Request failed with status code 400\n at createError (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/createError.js:16:15)\n at settle (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/settle.js:17:12)\n at IncomingMessage.handleStreamEnd (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/adapters/http.js:269:11)\n at IncomingMessage.emit (events.js:327:22)\n at IncomingMessage.EventEmitter.emit (domain.js:467:12)\n at endReadableNT (internal/streams/readable.js:1327:12)\n at processTicksAndRejections (internal/process/task_queues.js:80:21)”}

Question: do I need to change values of the column names on my Drupal site or am I missing a way to map the data?

Can you tell us what columns you have in the coda table, and what column types they are? Are any of them calculated via formulas?

And on the n8n side, does it have a way to show you the data it’s passing to coda, for troubleshooting?

Here are the Coda table columns, check marks indicate data that we need to import :

Task … Text (√√)
Tracking ID … Formula (no)
Description … Text (√√)
Assigned … People (no)
Deadline … Date (√√)
Event date … Date (√√)
Contact … Text (√√)
Email … Text (√√)
Phone … Text (√√)
Status … Select List (no)

And here’s the JSON data:
[
{
“headers”: {
“host”: “mbeck.app.n8n.cloud”,
“x-request-id”: “4125b4e39d6f134623679dde821b1f1b”,
“x-real-ip”: “10.40.16.2”,
“x-forwarded-for”: “10.40.16.2”,
“x-forwarded-host”: “mbeck.app.n8n.cloud”,
“x-forwarded-port”: “443”,
“x-forwarded-proto”: “https”,
“x-forwarded-scheme”: “https”,
“x-scheme”: “https”,
“content-length”: “363”,
“user-agent”: “Drupal/9.2.9 (+https://www.drupal.org/) GuzzleHttp/6.5.5 curl/7.61.1 PHP/7.4.27”,
“content-type”: “application/x-www-form-urlencoded”
},
“params”: {},
“query”: {},
“body”: {
“project_title”: “This is a test testing”,
“project_description”: “lorem ippy”,
“event_date”: “2022-02-02”,
“deadline”: “2022-02-02”,
“contact[name]”: “john doe”,
“contact[email]”: “m@aol.com”,
“contact[phone]”: “444-444-4444”,
“contact[company]”: “”,
“contact[address]”: “”,
“contact[address_2]”: “”,
“contact[city]”: “”,
“contact[state_province]”: “”,
“contact[postal_code]”: “”,
“contact[country]”: “”
}
}
]

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