If not exist create, if exists update nocodb

Describe the problem/error/question

Hello.
Is it possible to have incoming webhook data check if the a value is already present in a noco.db.
If not present than create a record an populate that with various data.
If a new webhook comes in, check if a value is present, if yes ( because already created ) update the record to with the values in the webhook.

So for example

webhook β†’ name : menu1 , calories : 2

menu1 does not exist, create menu1 , add calories : value : 2

second webhook comes in β†’ name : menu1 , calories 56.

menu2 β†’ exist, calories β†’ exist β†’ update calories with value 56.

Thanks,

Dipp

What is the error message (if any)?

none

Please share your workflow

none, just checking if this is possible.

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version: latest ( as of 280124 )
  • Database (default: SQLite): - latest ( as of 280124 )
  • n8n EXECUTIONS_PROCESS setting (default: own, main): , default,
  • Running n8n via (Docker, npm, n8n cloud, desktop app): , docker
  • Operating system: , ubuntu 22:04

Hi @mr.dipp :wave: This should be possible - there’s an example on how to merge data from @MutedJam in this topic, as well :slight_smile: Nocodb record exists how to? You’d just need to ensure that you switch this up to also be parsing the webhook data.

1 Like