Base and Table not appearing in NocoDB node

[headset907]

I’m using the cloud version of NocoDB so to create my n8n credential I plug the API key and choose https://app.nocodb.com as host and the connection is tested successfully

But in the node, I can’t fetch the project or table names.

• n8n version: 1.72.1
• Database (default: SQLite): Postgres
• n8n EXECUTIONS_PROCESS setting (default: own, main): ?
• Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
• Operating system: Linux

[ihortom]

Hey @headset907 , I suspect it has something to do with the role of the user you connect to NocoDB with. Perhaps the role in question has some limitations preventing viewing projects and tables.

[headset907]

Hi @ihortom, thanks for your help.

Double checking everything.
Please have a look and tell me if I’m missing something please.

In credentials I’m choosing API Token

(tried with User Token in case but doesn’t work neither)
Thanks a lot

[ihortom]

The (personal) token is created by you as a user. What is your user role, Roles & permissions overview | NocoDB?

[headset907]

hi @ihortom, sorry for the delay and happy 2025!
I’m using the hosted nocodb and i’m the owner…
I should be able to do anything right?
Thanks

[ihortom]

Hey @headset907 , created an account with NocoDB to test it out in n8n Cloud and on my local instance. I encountered no problem.

I don’t know what else I can suggest.

[headset907]

@ihortom that is so weird…
My connection is successful but it still seems to not work in the node.
Also the wording is different in mine maybe due to the latest update…

thanks anyway for sticking with me

[Pascoual]

Same problem here.

I can write it manually. With wrong database or table name, it throw an error, but with good database and table name it throw 401:```
{
“msg”: “Invalid token”
}

[Pascoual]

I solved this by creating a new NocoDB user with a new API token. The Owner seem not to be able to do API request.

[headset907]

Hey @Pascoual, great follow up!
How did you do it? Just clicking Add Members in the Members tab?
So you fill out a random email and which did you give it?
Thanks

[Pascoual]

Hello Headset,

Go to the bottom left on you account name, and go to settings. On the new page go to User Management.

Create a new user with an email, alias or another email you own.
When created click on the 3 dots, copy invit URL and open a private browser windows to create account login and pass. Connect you with the new user and create a token. Assign the new user to projects you want to use.

That’s set !

[headset907]

Hey Pascoual, thanks for the answer!
That’s so strange check out my account settings options:

Completely different from yours!
You’re self hosted right? I see the try nocodb cloud on your pic.
I’m using the cloud version that’s maybe why I can’t have it to work…
I added a second user and created a token.
What role did you assign to the new user? Owner, creator, editor?
Even with owner assigned I don’t see the project and table (still greyed out…)

I tried Grist and it work with it without having to create a second user…
Let me know if you have another idea!
Thanks!

[Pascoual]

Yes, self hosted on a CPanel node app option.
The new user role is creator.

The version of the API is 0.200.0 Onwards.
It show the “Workspace” field, set to “No Workspace” (this is the name of the unique workspace allowed in community edition). You don’t have that field, strange o0 !

Is Grist a great alternative to NocoDB ?

[headset907]

Pascoual! my savor!
it works now! It was just

The version of the API is 0.200.0 Onwards.

I had it on v0.90.0 Onwards
I don’t know what’s that setting but now it works…
and I can even add a workspace!

Thanks a lot for your persistence!
cheers

[Pascoual]

Great !

How do you compare NocoDB to Grist ?

[headset907]

I think it’s great if you want to visualize your data easily especially for people used to excel

Grist Product Comparison | Grist

[rodinvictor]

Thank you very much! It helped me! I registered a user (not the OWNER) and everything worked!