Extracting Collection Data with Integromat

Hi all,

I am using Integromat to extract data from Adalo. Within my adalo database, some line items are data collections and they’re showing up as numerical values instead of their actual text value. Is there a way to translate it back to the actual value?

Thank you!

Screen Shot 2021-12-07 at 12.21.47 PM

Hi @Ycampbell,

To get the values for these records, you will have to:

  • add connection(s) to desired collection(s) in Integromat - e.g. Category, Sub-Category, User
  • add a “Get Record” operation after the current module
  • and use the 1st value of the array (e.g. Category[1]) as a RecordID.

To save credits and improve scenario speed, sometimes I add a text property to the original collection and copy the value from a related collection. But this depends on the exact app setup.

Best regards, Victor.