I have created a Boomi web service to integrate with Netsuite. When successful, it will create a Purchase Requisition in Netsuite. As part of the create process, I need to provide Netsuite with the "internal ID" of a given item number/name. When end user provides the item number/name, I need Boomi to convert it to the internal ID of that item. How do I do this?
The closest I've gotten is creating a map connector call that will filter item name = user input, but that returns the wrong response. I believe I need to query against the Item object vs the Purchase Requisition object.