Using shopify > Order Created as a trigger, the return object looks something like this:
{
...
Line_Items_Name: product1, product2, product3
Line_Items_Price: 4.99, 5.99. 2.99
Line_Items_Tax_Rate: [0.025, 0.01, 0.04], null, [0.012, 0.015, 0.01]
}
When trying to work with the Line_Items_Tax_Rate lines, zapier is flattening this array and removing the null values. The above example looks like [0.025, 0.01, 0.04, 0.012, 0.015, 0.01]. When mapping Line_Items_Tax_Rate to a search, for example, Zapier thinks there are 6 tax lines, not 3.
How can I get Zapier to not flatten out the array, and when i reference bundle.InputData.tax_rate, it returns the array of rates per line (and null for line 2) for the 3 lines and NOT the value of the flattened array[i].
How to manipulate the data from Shopify Order Created trigger
+14
- Certified Zapier Expert
- 23934 replies
-
13 May 2021
Hi
Try using a Formatter > Utilities > Line Itemizer step in the Zap: https://zapier.com/help/doc/how-use-formatter-functions
Check out this article:
My issue with this is that I need it to happen from the search step itself by coding it using cli instead of requiring our users to add scripts & formatter functions to get their shopify order to create a successful invoice.
+12
- Certified Zapier Expert
- 1015 replies
-
13 May 2021
One thing you could try is to pass all the data from the trigger step through to a webhook (use data pass through) into another zap (triggered by a catch raw hook). Then you should get back more of the raw response which can be used.
Edit.. Just saw that you were building an integration, so the above won’t be helpful for your specific use case.
+10
- Certified Zapier Expert
- 2437 replies
-
5 July 2021
Just checking in to see if you still need help with this?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.