Loading

How to read xml payload as raw file along with encoding using XmlModule:: xpath query

Date de publication: Mar 2, 2024
Tâche

GOAL

There are cases in which the input XML document contains special characters. This article describe how to read those xml payload along with encoding using XmlModule:: xpath query.
Étapes
Input XML Payload : 
<?xml version="1.0"?>
<bookstore>
  <book category="cooking">
    <title lang="en">Everyday Italian</title>
    <author>Giada De &amp; Laurentiis</author>
    <year>2005</year>
    <price>30.00</price>
    <notes><![CDATA[
Please assign book review to Barnes & Nobel - 114-223-234
1. Please upload the sketch and photos as soon as possible after the initial visit. 
2. Please upload the initial report with 24 hours of initial on-site

Thank you]]></notes>
  </book>
</bookstore>
Use transformation message with following  syntax to read desired data using XPath expression

Method 1:  Payload as raw String with encoding 
%dw 2.0
output application/java
---
XmlModule::xpath('bookstore/book/author/text()', payload.^raw as String {encoding: "ISO-8859-1"}, {})[0]
Method 2: Payload as raw String 
%dw 2.0
output application/java
---
XmlModule::xpath('bookstore/book/author/text()', payload.^raw as String , {})[0]
Numéro d’article de la base de connaissances

001116607

 
Chargement
Salesforce Help | Article