I am working with orders coming in from Shopify. For each order, there are multiple products (Line Items), and each product has multiple additional fields (Properties). All of the field names have a prefix for name, and all the user input values have the prefix of value. Here’s a screenshot from a test order within Make:
As a test, I used a couple of iterators, I was able to loop through and stamp them into a Google Sheet. However, I am now trying to parse it out so that each field (anything after a “name:”) can be selected as its own element.
The iterator only allows a selection of either name: or value:, but I’d trying to grab First Name, Last Name, Email, etc.
I am able to iterate on the name and the value itself, by using 3 Iterators. One for Line Items, then Properties, then Name/Value. However, the “value” of the Name field is what I actually want to select.
On that step, you can see it says “Name: Personal Message”, “Value: epersonal”. If I looped through it, there would also be others like “Name: First Name”, “Name: City”, “Name: Zip Code”. I need to be able to turn Personal Message/First Name/City etc into its own field so that I can select it for mapping.
@alex.newpath Yes, the Name field from the iterator does contain the proper values. However, I want the actual “value” of the Name field so I can choose what to map specifically.
I may want to map First Name to one place, City to another place, Zip to another place, etc. If I only have a Name field to choose from, I can only put it in one spot.
I may be getting close with the Set Variable tool:
The problem I’m running into now is that I have to set and define each variable, instead of having it automatically loop through and define each variable depending on how many there are.