Hey there. Trying to connect nocodb with no luck. Created an instance on Heroku. Tried to reinstall it, but still getting the same issue. Please, assist
I’ll share my API info since the database is empty anyway:
{"context":{},"name":"NodeApiError","cause":{"message":"404 - \"<!DOCTYPE html>\\n<html lang=\\\"en\\\">\\n<head>\\n<meta charset=\\\"utf-8\\\">\\n<title>Error</title>\\n</head>\\n<body>\\n<pre>Cannot POST //nc/p_1v2w4s0w4karh4/api/v1/Unis/bulk</pre>\\n</body>\\n</html>\\n\"","name":"Error","stack":"Error: Request failed with status code 404\n at createError (/Applications/n8n.app/Contents/Resources/app/node_modules/axios/lib/core/createError.js:16:15)\n at settle (/Applications/n8n.app/Contents/Resources/app/node_modules/axios/lib/core/settle.js:17:12)\n at IncomingMessage.handleStreamEnd (/Applications/n8n.app/Contents/Resources/app/node_modules/axios/lib/adapters/http.js:269:11)\n at IncomingMessage.emit (node:events:406:35)\n at IncomingMessage.emit (node:domain:470:12)\n at endReadableNT (node:internal/streams/readable:1331:12)\n at processTicksAndRejections (node:internal/process/task_queues:83:21)"},"timestamp":1657591032916,"message":"The resource you are requesting could not be found","node":{"parameters":{"resource":"row","operation":"create","projectId":"p_1v2w4s0w4karh4","table":"Unis","dataToSend":"autoMapInputData","inputsToIgnore":""},"name":"NocoDB","type":"n8n-nodes-base.nocoDb","typeVersion":1,"position":[1540,180],"credentials":{"nocoDb":{"id":"4","name":"NocoDB account"}}},"httpCode":"404","description":"<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n<meta charset=\"utf-8\">\n<title>Error</title>\n</head>\n<body>\n<pre>Cannot POST //nc/p_1v2w4s0w4karh4/api/v1/Unis/bulk</pre>\n</body>\n</html>\n"}
Hi @alexpti4ka, from looking into this it seems NocoDB have changed their API quite a bit since the n8n node was last updated (causing not only the insert to fail but also the API token authentication) . I have added this to our internal bug tracker for a closer look.
In the meantime you might want to use the HTTP Request node to insert data into your NocoDB like so:
In this example, foo is my NocoDB project, bar is my table, and Title is the column name. The header authentication is set up like so:
Just to add to this one, We have had a PR contributed by a community member and got a bit held up with how to handle the versioning so that we don’t break or remove support for older installs of NocoDB. We have since put a solution in place that will help and have updated the PR to include these changes.
The changes are currently going through the last review change and will likely be merged soon and released. The n8n desktop app may be a couple of weeks after the self hosted release as it has a different release schedule.
The PR has had a couple more changes this week and it looks like it is in the ready to be merged list so in theory it should be included in one of the next couple of releases unless anything urgent pops up.
. I have added this to our internal bug tracker for a closer look.
I’ll try HTTP request instead.