Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Problems with entering array / collections data into an Airtable linked field using Integromat

Topic Labels: Integrations
1277 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Adrian_Wasiak1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all,

I’m struggling to get the correct data into Airtable.

As a start a module gets data from an external website that goes through an Iterator. In the example below an Array has 6 Collections with each another Collection. I’m trying to get the 6 different values from “ns9:href” into 1 “Linked To” Column in 1 Record, but I’m not succeeding. I tried different solutions like using the “ns17:ZakelijkRechtRef” array and applying FLATTEN, JOIN, etc. formulas to it, using the same formulas on _attributes, but all give different errors like:

"DataError

Failed to map ‘0’: Function ‘flatten’ finished with error! ‘[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],1’ is not a valid array. "

Or only 1 collection’s output is entered into Airtable, see example below. Can someone help me to solve the problem?

Example 1 Example 2 Example 3

0 Replies 0