Lets say we have two (or more) lists, which we need to be in one array before we make the final request. For each list we need several actions e.q. lookups, each list required it's own logic. So we end up with two 2 list where append new items to. In the end we need to merge both lists to another third list to make sure we end up with only 1 list which we could use for the final request. In this case we have used the Workato 'list' function 3 times, while actually it's much easier to append an already existing list within the recipes.
You understand.. In case of Netsuite item lists we sometimes have to make a different request for another item type to Netsuite. In Netsuite we have for example:
- Inventory items
- Non-inventory items
- Shipping items
- Payment items
- Discount items
- and more..
If we have a source which has item list for payment and inventory we require different request logic for each type.. This end up having various 'list' action in 1 recipe, then merge all lists into 1 list. If Workato would be able to add an extra feature 'append to existing list' then this would be much much easier.
Thank you for feedback. For List app - appending objects to existing List is on the roadmap.
From your above query, I understand you maintaining a list for each type of Inventory item. instead, I would suggest you keep one list Inventory List with a one the field is Item Type, in Item Type field You can store as Inventory Items, Non-Inventory Items, Shipping Items etc.
If you want to fetch Items for a particular type of Item Type, use where('Item_type': 'Shipping Items') formula, this gives you the list of all Shipping items from the complete set. now you will have all the Items in One single list i.e. Inventory List instead of merging lists. I understand you have to use one more step with a formula to separate out.
Hope this helps.
Great to hear that this is on the roadmap.
Yes makes sense however it's not really easy to find out which item type it is, we could a lookup list but currently bit in doubt how to get this list in sync.
Any update on the ability to append items to an existing list? Is this possible now?
I am interested in this also. Any update?
Sincere apologies for the delay in response on this. While the List app is still unable to append to the same list, you can achieve the same result with our Collections app. You can learn more about that here: https://www.workato.com/integrations/workato_smart_list
Using the Query lists in Collection action, you can use a SQL command to add items to the Collection or list.
I hope this helps!
Send us a ticket, we will try our best to assist you with your problem