XPATH: transform XML document to JSON object for Post Request

Legacy Contributor

Hello everyone

I have a REST API with a POST Request.

From Infor LN i recive a XML, which i'd like to transform to a JSON object. i selected the "Map input document to API request" and set selected my XML file as input document.

Input document:

<?xml version="1.0" encoding="UTF-8"?>
<Syncabc_shipment xmlns="">schema.infor.com/.../2" xmlns:xs="">www.w3.org/.../XMLSchema" releaseID="9.2" versionID="2.14.x">

      <SHIPMENT>
            <CURID>123<CURID/>
     </SHIPMENT>
</Syncabc_shipment>

in my Request Body i try to transform the XML to my JSON:

{
   "CURID": {"IonApiRef":"CURID"}
}

When i test my request, i recive the message: parameter CURID with path CURID can not be added as child of Syncabc_shipment /

In my opinion, this message has nothing to do with the XPATH ELEMENT. Why is the error message refering to my input xml? How can i transform my xml to a simple JSON object?

Legacy Contributor

Hi,

Your xPath is not correct, try this instead:

{
   "CURID": { "IonApiRef" : "Syncabc_shipment/SHIPMENT/CURID/text()"}
}