AnsweredAssumed Answered

How to iterate through Batch Result XML for NetSuite Connector?

Question asked by vfalk on Sep 28, 2017
Latest reply on Oct 18, 2017 by vfalk

Team,

 

I currently have a process throwing an error "Nested connector returned multiple documents" and noticed that my NetSuite Connector Call in my map is returning more than one record, which is the expected result. However, I need to be able to save both (always going to be 2) results and use them in my map.

 

The response XML I am getting is:

<Misc_CostList>
   <Misc_CostSearchRow>
      <basic>
         <recType internalId="190"></recType>
         <customFieldList>
            <Lane___Air_Rate internalId="1037" scriptId="custrecord_rate">
               <searchValue>4.77</searchValue>
            </Lane___Air_Rate>
         </customFieldList>
      </basic>
</Misc_CostSearchRow>
<Misc_CostList>
   <Misc_CostSearchRow>
      <basic>
         <recType internalId="190"></recType>
         <customFieldList>
            <Lane___Air_Rate internalId="1037" scriptId="custrecord_rate">
               <searchValue>4.77</searchValue>
            </Lane___Air_Rate>
         </customFieldList>
      </basic>
</Misc_CostSearchRow>

 

I need to save only the Lane___Air_Rate search value and use both these values in my map to properly map a saved search to a CSV file.

 

Any thoughts on how best to approach this? I realize a lot of my option are limited because this connector call is inside of a map.

 

Any/all help is much appreciated!

 

-Vince

Outcomes