Updating a field from n8n

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

SaaS

What are the exact steps to reproduce this issue?

! send prompt to ai agent "update Jon Smith in the team contacts with the role of Manager. Phone number: +447961987987. Email: solid@hotmail.com. role: sales
2 it structures the data through ai
3 it grabs row id from id look up
3 sentd data to baserow update note
the i get the error and it wont update

Attach screenshots, videos, or logs that demonstrate the issue.



@Jonjon welcome to the Baserow community :raised_hands:

@joffcom could you please help with this issue, thanks!

1 Like

Hey @Jonjon,

Solid name you have there :raised_hands:

In the Update Team Contact node the Row ID doens’t look to be an expression, Can you try changing it and let me know if that helps.

here is the error output in full if that helps

{
“errorMessage”: “Bad request - please check your parameters”,
“errorDetails”: {},
“n8nDetails”: {
“time”: “1/21/2025, 10:22:13 PM”,
“n8nVersion”: “1.74.3 (Cloud)”,
“binaryDataMode”: “filesystem”,
“cause”: {
“message”: “Bad request - please check your parameters”,
“timestamp”: 1737498133136,
“name”: “NodeApiError”,
“description”: “ERROR_REQUEST_BODY_VALIDATION”,
“context”: {},
“cause”: {
“message”: “400 - {"error":"ERROR_REQUEST_BODY_VALIDATION","detail":{"field_3102874":[{"error":"Enter a valid value.","code":"invalid"}],"field_3102875":[{"error":"Enter a valid value.","code":"invalid"}]}}”,
“name”: “AxiosError”,
“stack”: “AxiosError: Request failed with status code 400\n at settle (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/settle.js:19:12)\n at IncomingMessage.handleStreamEnd (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/adapters/http.js:599:11)\n at IncomingMessage.emit (node:events:530:35)\n at endReadableNT (node:internal/streams/readable:1698:12)\n at processTicksAndRejections (node:internal/process/task_queues:82:21)\n at Axios.request (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/Axios.js:45:41)\n at processTicksAndRejections (node:internal/process/task_queues:95:5)\n at invokeAxios (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:583:16)\n at proxyRequestToAxios (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:612:26)\n at Object.request (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:1478:50)\n at SupplyDataContext.baserowApiRequest (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Baserow/GenericFunctions.js:28:16)\n at SupplyDataContext.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Baserow/Baserow.node.js:210:40)\n at Object.handleToolInvocation (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/node-execution-context/utils/getInputConnectionData.js:41:44)\n at DynamicStructuredTool.func (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/CreateNodeAsTool.js:260:39)\n at DynamicStructuredTool.call (/usr/local/lib/node_modules/n8n/node_modules/@langchain/core/dist/tools/index.cjs:111:22)\n at /usr/local/lib/node_modules/n8n/node_modules/langchain/dist/agents/executor.cjs:486:27\n at async Promise.all (index 0)\n at AgentExecutor._call (/usr/local/lib/node_modules/n8n/node_modules/langchain/dist/agents/executor.cjs:478:30)\n at AgentExecutor.invoke (/usr/local/lib/node_modules/n8n/node_modules/langchain/dist/chains/base.cjs:58:28)\n at ExecuteContext.toolsAgentExecute (/usr/local/lib/node_modules/n8n/node_modules/@n8n/n8n-nodes-langchain/dist/nodes/agents/Agent/agents/ToolsAgent/execute.js:185:30)\n at ExecuteContext.execute (/usr/local/lib/node_modules/n8n/node_modules/@n8n/n8n-nodes-langchain/dist/nodes/agents/Agent/Agent.node.js:379:20)\n at WorkflowExecute.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:632:19)\n at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:872:51\n at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:1206:20”,
“code”: “ERR_BAD_REQUEST”,
“status”: 400
}
}
}
}

Hi @joffcom thanks for the reply ive tryed that and did make a difference

Hey @Jonjon,

It looks like 2 of your fields might be getting incorrect data, Can you share the rest of the node so we can see the fields you are sending to? The 2 fields that are unhappy are field_3102875 and field_3102874 which could be anything.

thank you very much @joffcom i have rechecked everything and fixed the issues it was the expression still not correct on those 2 fields

im very greatfull for the swift support. i look forward to sharing knowledge back once im more exprienced

everything is working now and ive learnt for future

Hey @Jonjon

Perfect thanks for the update. I look forward to maybe finding out more on what you are building in the future.