NocoDB integration

Open Source Airtable Alternative

NocoDB is an Airtable alternative that’s Open Source, free, and self-hostable. It generates instant REST APIs.

Airtable has been a very popular backend for no-code SaaS projects, mainly due to its generous free tier, ease of use, and powerful features. But Airtable’s recent changes gutted the free tier. No-code entrepreneurs need another option. NocoDB is a great alternative—especially because it’s a popular open source project.

It would be great to see a NocoDB piece for Activepieces that has parity with the actions and triggers available for the Airtable piece.

I self-host NocoDB on Railway (Deploy NocoDB on Railway | Railway) but other options include Docker (GitHub - nocodb/nocodb: 🔥 🔥 🔥 Open Source Airtable Alternative), PikaPods (PikaPods - Apps) and similar platforms. Also, the private beta of NocoDB Cloud (free) is coming soon (signup is here).

Links
Website: https://www.nocodb.com/
Github: GitHub - nocodb/nocodb: 🔥 🔥 🔥 Open Source Airtable Alternative
YouTube: https://www.youtube.com/@nocodb/videos
Data API docs: https://apis.nocodb.com/
Meta API docs: https://all-apis.nocodb.com/

Please help to upvote this integration!

Hello @Bryan @anrikaz ,

We have published a piece on NocoDB featuring table record actions.

Please let us know if you encounter any issues with the piece.

Thanks,
Kishan

1 Like

I cannot manage to get it to work. I have NocoDB and Active pieces both installed and working properly on my synology DSM as docker. my url for both is appname(nocodb).my-domain.synology.me and it is wokring and acceisble without issues. I create an API key and I connected Noco DB with base url credentials : “nodcodb.my-domain.synology.me " . I dont get any error but when I try to use the integregration I always message " throws error, reconnect or refresh page” . I cant put workspace ID or any other idea as it gives me this error and no option to fill in anytying

like this:

any suggestion what I am doing wrong?

1 Like

I’m facing the same issue. Perhaps they developed the piece using the NocoDB cloud version instead of the self-hosted version. I hope they release a new version with more features and a self-hosting option.

This is also what I thought!
HOWEVER , I figured out that if I press on “x” twice. It cancels the automatic search option and let’s you fill in what you want. Need to do the same to all fields. It doesn’t fetch it automatically as I suppose is intended.
After doing that and filling it in automatically, it works I managed to integrate and make it work.
It is however very annoying as I need to do this every time I add or change the action related to nocoDB. It is many clicks everytime. But it works. I got some automation going.

Hope this post will help you and others to figure it out also.

Hello @igalg2024 ,

Could you please add an HTTP step to fetch the workspace from your NocoDB account, as shown in the image? Replace https://app.nocodb.com with the base URL of your NocoDB instance. Additionally, you can send me the response via personal message, which would be helpful for troubleshooting this issue.

I reply in private to this

the integration doesnt work for me as well

i get the following error when i try that call

{
“response”: {
“status”: 404,
“body”: {
“msg”: “Cannot GET /api/v1/workspaces”
}
},
“request”: {}
}

also as per nocodb doc there is no api v1 anymore

Are you using a self-hosted NocoDB or the cloud version?

I am selfhosting, and also the v1 of the api is deprecated.

I will revisit this endpoint alternative in the v2 spec and update it accordingly in the piece.

Thanks.

I wonder if could be possible to start flows from updated rows on NocoDB?

I suppose I can do it manually with webhooks? Insights? :slight_smile:

[EDIT] Well, it did’t work on self-hosted noncodb instance.