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?
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)