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?