nocodb / nocodb

🔥 🔥 🔥 Open Source Airtable Alternative
https://nocodb.com
GNU Affero General Public License v3.0
49.65k stars 3.39k forks source link

🐛 Bug: webhook is not working with External Source DB #9787

Open mishlaev-personal opened 2 days ago

mishlaev-personal commented 2 days ago

Please confirm that the bug report does not already exist

Steps to reproduce

Created a new table that is connected with our production Postgres:

Screenshot 2024-11-10 at 4 32 37 PM

Everything is updated as needed. DB sync works perfectly.

I've set up an n8n webhook. The test event works wonderfully.

Screenshot 2024-11-10 at 4 33 08 PM

But as new records are added to our looker table, I can see it onside NoCoDB, but no new webhooks are created.

Desired Behavior

As we have new records from synced external Postgress DB, I want to have webhooks for those new records.

Project Details

Node: v20.15.1 Arch: x64 Platform: linux Docker: true RootDB: pg PackageVersion: 0.257.2

Attachments

No response

dosubot[bot] commented 2 days ago

@mishlaev-personal Привет! I'm here to help you with any bugs, questions, or contributions. Feel free to ask for assistance while waiting for a human maintainer.

There is a similar discussion regarding webhooks not being triggered after changes in an external database. The issue is that external changes won't trigger the webhooks [1]. This might be the reason why your webhooks are not being created when new records are added to your external Postgres database.

To continue talking to Dosu, mention @dosu.

mishlaev-personal commented 2 days ago

@dosu Yes, it's the answer to my problem, but it's very frustrating

dosubot[bot] commented 2 days ago

This issue seems to need your expertise, @o1lab, could you please take a look?

To continue talking to Dosu, mention @dosu.