Slack Webhook - data fields received as NULL [Mar 02]

:raising_hand_man: ghost asked

When I send {{json data}} to Slack via a webhook, some of the fields are null, but interestingly, not all of them! for example: {“Id”:23,“CreatedAt”:“2022-03-01T02:38:48.735Z”,“UpdatedAt”:“2022-03-01T02:38:48.735Z”,“type”:“BodyLanguage”,“source”:null,“content”:null,“session_id”:null}

:man_bald: dstala replied

ghost@discord Can you please help us with project information?

For project info

- Open project

- On right top, click on “User” icon

- Copy project info

:man_bald: dstala replied

Additional info, if you can provide -

(a.) What is your webhook trigger set to (on delete/ on insert/ on update)?

(b.) How are you inserting your records into table?

:raising_hand_man: ghost replied

The trigger is “after insert” and here’s project information:

:raising_hand_man: ghost replied

```Node: v12.22.6

Arch: x64

Platform: linux

Docker: true

Database: pg

ProjectOnRootDB: false

RootDB: pg

PackageVersion: 0.84.14```

:man_bald: dstala replied

ghost@discord

From UI, there are two ways to insert a record, as shown in attached image.

mode-1 (bottom of grid view): Updates db immediately after a cell is fed

mode-2 (top right + icon): Updates db on clicking SAVE after all fields are populated

I tried triggering Slack Webhook from NocoDB over Heroku, worked fine with mode-2.

Using mode-1, populating first cell will be considered insert record. And while we are updating subsequent cells, it is being treated as “update record” trigger.

:man_bald: dstala replied

Probably that explains why “type”:“BodyLanguage” was retrieved properly, and rest were still NULL

:raising_hand_man: ghost replied

That makes sense - however the expectation as a user is that both flows result in saving the full record like mode-2

:raising_hand_man: ghost replied

But I understand, and I will use mode-2 for now

:man_bald: dstala replied

Noted. We will check if we can provide an environment variable to configure/ control this behaviour.

:raising_hand_man: ghost replied

in mode-1, is this for collaborative updating of data by multiple people in parallel?

:raising_hand_man: ghost replied

Does nocodb do this kind of real-time communications between several clients?

:man_bald: dstala replied

Collaboration on same project from multiple users is possible, but currently is not real-time. RT collaboration is in pipeline.

:raising_hand_man: ghost replied

Cool, thank you

Autogenerated from discord


Join NocoDB’s community

DiscordTwitterRedditDocs