Skip to main content
Question

How to manipulate the data from Shopify Order Created trigger


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].

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @jbourgoin 

Try using a Formatter > Utilities > Line Itemizer step in the Zap: https://zapier.com/help/doc/how-use-formatter-functions

 

Check out this article:

 


  • Author
  • New
  • 1 reply
  • May 13, 2021

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.


GetUWired
Forum|alt.badge.img+12
  • Zapier Expert
  • 1030 replies
  • May 13, 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. 


AndrewJDavison_Luhhu
Forum|alt.badge.img+10

@jbourgoin 
Just checking in to see if you still need help with this?