Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Integrations
1402 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