How can I update a relation property in a database item using a webhook in Make?

What are you trying to achieve?

Hello!!

I’m using Notion and have 3 databases: Equipment, Reports, and Clients.
The Equipment database is linked to the Clients database, and the Reports database is linked to both Equipment and Clients.
Through Make automation, we want to do the following:

Currently, we have Equipment A linked to Client A.
When a new report is submitted via a form with Equipment A and Client B, we want to update the Equipment database so that Equipment A is now linked to Client B instead of Client A.

How can we make this change using a webhook?

Steps taken so far

I have an equipment database with the item 1111111111111, and its associated location is prueba4.
I have a report form where I selected equipment 1111111111111 and location: prueba3.

The form data is sent via webhook. Using the ID, I can select equipment 1111111111111, but I’m unable to change the location from prueba4 to prueba3.

How can I do this?

Screenshots: scenario setup, module configuration, errors




Hello Hernan! Try refreshing the module that outputs the error:

  1. Click on the three dots > Refresh
  2. Ensure the Establecimiento relation property is filled out like in your screenshot
  3. Save
  4. Try again and see how it goes

Hi, I tried refreshing the module, but I got the same result. I think maybe I’m not selecting it correctly.

Here I have the new database item ID

But I don’t know how to select this existing option in the “Establishments” database — from prueba4 to prueba3.

Mh I am not sure I can understand exactly all the steps involved yet. In general, to update a relation property, we map the database item ID, which looks like what you originally did as far as I can tell