Examples of JSON Path or Xpath in body mapping
JSON target with JSON source - JSONPath
{
"book": {
"author": {"IonApiRef": "$.store.book[0].author"},
"price": {"IonApiRef": "$.store.book[0].price"}
}
"bookCount": {"IonApiRef": "$.store.book.length()"}
}
JSON target with XML source -
XPath
"customer": {
"name": {"IonApiRef": "SalesOrder/SalesOrderHeader/CustomerParty/Name"},
"city": {"IonApiRef": "SalesOrder/SalesOrderHeader/CustomerParty/Location[@type=”Office”]/Address/CityName"}
}
XML target with XML source -
XPath
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<customer>
<name>
<IonApiRef>SalesOrder/SalesOrderHeader/CustomerParty/Name</IonApiRef>
</name>
<city>
<IonApiRef>SalesOrder/SalesOrderHeader/CustomerParty/Location[@type=”Office”]/Address/CityName</IonApiRef>
</city>
</customer>
XML target with JSON source -
JSONPath
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<extract>
<book>
<author>
<IonApiRef><![CDATA[$.store.book[0].author]></IonApiRef>
</author>
<price>
<IonApiRef><![CDATA[$.store.book[0].price]></IonApiRef>
</price>
</book>
<bookcount>
<IonApiRef><![CDATA[$.store.book.length()]></IonApiRef>
</bookcount>
<extract>