AnsweredAssumed Answered

Create multiple details from 1 column

Question asked by kristian on Mar 14, 2018
Latest reply on Mar 15, 2018 by leif_jacobsen

Hi, we got the following from NetSuite fulfillment record:

...

<tranSales:createPo>PO01000</tranSales:createPo>

<tranSales:serialNumbers>001 002 003 004 005 006</tranSales:serialNumbers>

...

 

The serialNumbers in this example are 6 SNs, space delimited.

We need to map it to the following XML profile:

 

...

<po>PO01000</po>

<serialnumberList>

   <sn>001</sn>

   <sn>002</sn>

   <sn>003</sn>

   <sn>004</sn>

   <sn>005</sn>

   <sn>006</sn>

</serialnumberList>

...

 

 

To make matter worse, there is no limit on how many serial numbers can be in the serialNumbers field.

Outcomes