Lookup multiple collections in Integromat


I’m just getting started in Adalo and like much of it so far, although starting to bump up against some roadblocks (like recurring IAP). Anyway…

I am building an RSVP app. I have three collections:

  • Events (has the details of each event)
  • Contacts (name, contact info, etc). There is a many to many relationship between Events and Contacts - i.e. each event can have multiple contacts. And each contact could be assigned to multiple Events.
  • Users - the owner of the event and contacts (one to many for events and contacts)

I want to be able to have Integromat pull all the contacts that are joined with an event for a user so Integromat can use the contact info (e.g. email address and name) to message (via another platform) each user.

How I would get the contacts (a collection) that are joined (referenced) with events (another collection) into Integromat so I can send info to the contacts for an event? I believe in Integromat I would need to the iterator function unless each contact came through individually…

Hope that makes sense. I’m a non coder so excuse any incorrect terms :blush:


Hi @paulh,

As a possible solution, how the scenario could look like:

  • Webhook listening to the custom action.You need to pass unique event name to this webhook (as Adalo doesn’t provide internal IDs, and we need that later)
  • Adalo List Events
  • filter - List Event Name IS EQUAL to event name from webhook. With this you will get only one event you’d like to work with later
    — in this event bundle, you will see Contacts as an array.
  • Iterator, which iterates array of Contacts
  • Adalo Get Record - from Contacts collection
  • Voila, you have the contact info and can pass it to the 3rd party messaging platform.

This will work if Contacts have email stored. If not - you will need to have another Adalo Get Record, to get info from Users collection based on User ID which is stored in the referenced field in Contacts record.

Please keep in mind - when you add Adalo collections to Integromat, be sure that you have the first record “fully completed”, otherwise Integromat may not recognize all the fields.

Best regards, Victor.

Thank you Victor, your method worked, I only changed some minor things. But Integromat makes it easy-ish!

1 Like

@Victor One more question - I tried using a Adalo “Make an API cal” from Integromat to try and select an individual record (I thought I could pass a query through the call), but it always returns all records. Is it possible to send a query in an API call to Adalo to get a single record without knowing Adalo’s ID (which is absolutely ridiculous that it isn’t visible)?

Hi @paulh,

In order to get the individual record, you need to know its ID - it works like that by design (in every API :slight_smile: ). But yes, Adalo doesn’t show it publicly which creates a lot of difficulties :frowning: There is GET ONE method which works, but as it’s difficult to get individual ID, its usage is very limited.

The only way to make this work is List Records + Filter by some unique property (for user that will be email, for instance). Then you’ll have the desired record.

Best regards, Victor.

Thanks @Victor yes that was what I had to do. I was trying not to get a full list every time there is a a trigger, but it does work (with the tiny sample data I have so far). That’s why I was hoping you could do a custom query (like a “?field=X” type call) via API on Adalo collections.

Be interesting to see how this scales.

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.