I'm wondering if there is an easier way to do this other than running the saved search 3 times and combining the results?
I have a Saved Search in Netsuite which returns various types of Item records (Inventory Items, Assembly/BOM Items, and Kitted Items) that have a certain flag set. So three types of Items show up in the Saved Search.
I connect to Netsuite using the QUERY operator and it successfully retrieves the regular Inventory Items, because my Query Connector Operation was initiated with the "Item" object.
Do I have to build 3 QUERY operations (one where object type = Item, one where object type = Assembly Item, and one where object type = Kit Item) and then merge the results together?
We will have a lot of processes that retrieve Items, so I just want to make sure that there is not an easier approach to retrieve everything in my Netsuite Saved search using 1 Connector Operation.
Thanks for any insight folks may have on this topic.