I have two databases, lets say A & B. When an action is taken on items within database A, I need to be able to make changes to items within database B. I can’t do relationships because the items are sent to Adalo via API, and I don’t think you can define relationships via the API. I tried setting up a custom action that uses PUT to change an item in database B, but it requires an “Element ID” which I don’t know how to pull. Any help would be greatly appreciated!

So due to the inability of setting relationships within external collections - Ive spent the last week trying to figure out a work around. I tried taking my database completely off Adalo into Airtable, but setting relationships via API to Airtable tables had it’s own challenges. But in the end I used the Adalo API to post external records into Adalo, then pull the posted items from Adalo so I can get the Element id and then merge it into the table and post it again with the additional id column so I can use it within custom actions to make specific updates to certain records. I used Parabola mostly to pull and post to the api. Phew :sweat_smile:

Defining database relationships via API

Get Help

AXIOM October 30, 2020, 8:10am 2

Hey @marius you are correct with both assumptions. Also, regarding the element ID have a look here:

Working with Adalo API - {ElementId} - #3 by AXIOM

Topic		Replies	Views
Relationship with External DB Database	2	492	September 19, 2022
Pulling Data from Adalo Database Array Field in Custom Action External Collections, Custom Actions & Collections	4	603	August 25, 2021
Why my external collection is not being considered as a current internal collection? External Collections, Custom Actions & Collections	3	599	March 28, 2022
Relationships with Adalo API Get Help	5	828	November 2, 2020
Adalo API and Collection Relationships Database	9	1951	August 31, 2021

Defining database relationships via API

Related topics