Hi everyone,
I’m stuck with a transformation issue between Shopify → Make → Airtable and I could use your help.
I receive a field from Shopify as an array (e.g. [“S”,“M”,“L”]), but in Airtable I need a single text value.
Even when I use map() and join(), Airtable still detects the output as an array and returns the error:
“Expected a string, but got array.”
Here is my actual flow :
Here is what I tried in the tools :
- join(map(1.variants; “title”); “,”)
In the Make output preview, the result looks like a text, but Airtable still refuses it as if it was an array.
My question:
How can I force Make to convert a single array element into pure text so Airtable accepts it?
Is there a best practice to flatten or stringify Shopify arrays before sending them to Airtable?
I just want to send the information variants - title in airtable.
Here are screenshots of the output vs. the Airtable input mapping (showing that Make still thinks it’s an array).
Output set up multiple variables - tools :
input create a record - airtable :
Thanks a lot in advance!
I’m sure I’m missing something small, but I can’t figure it out.