Choose only a few items inside an iterator

[Akiladevi]

Hi Pabbly support team,

The Pabbly account I handle is [email protected]. The workflow is called the WooCommerce to Master Revenue sheet. In this workflow, I fetched the data from the webhook. This workflow fetches Woocommerce order data and stores it in a Google sheet. The workflow should be able to handle even if there are multiple items in a single order. For that, I used an iterator for Line item[ ]. Inside Line item[ ] there is another array called Meta data[ ]. I used another iterator for Meta data, but the problem is that the Meta data[ ] has many items like id:55812, id:55813, id:55814, id:55827, id:55828, id:55829, and so on. Out of these I need only [{"key":"Translation","value":"Russian","id":"1725237117","raw_value":"Russian","raw_price":38,"price_type":"flat_fee"},{"key":"Transcription","value":"Russian","id":"1725237118","raw_value":"Russian","raw_price":99,"price_type":"flat_fee"}]}

How to pick only a few items from the iterator?
Link to the workflow:https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTZjMDYzMzA0Mzc1MjY0NTUzZDUxMzci_pc

Thanks in advance,
Regards,
Akila.

 

[ArshilAhmad]

Hi @Akiladevi,

You can add a Filter step after the Iterator and set the filter conditions as per your need. This will ensure that the following steps are executed only if the filter conditions are met.

 

[Akiladevi]

Hi @ArshilAhmad ! inside the filter we need to compare to parameters, am I right? Actually i have to compare the outputs of an iterator. In my case the meta deta[] array is given to an iterator to pick out each and every item in that array. The array has 6 items out of wish 3 are duplicates. I have to filter meta data[0] which I enter as output A from filter. Now the filter has to compare output A and meta data[1], if these both are equal then it does not output anything. If the output A is not equal to meta data[1] then it can output meta data[1] as output B. Then it has to compare output B and meta data[2]. Then the process goes on. How to implement this?

 

[Preeti Paryani]

Hello @Akiladevi

The use case you're describing may not be feasible with an iterator, as it returns one list item at a time. This makes it challenging to compare metadata[0] with metadata[1].

Could you provide a more detailed explanation of your use case? A short screen recording would be especially helpful for us to understand and assist you better.