Loading

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

公開日: Mar 2, 2024
タスク

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.
ステップ
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]
ナレッジ記事番号

001116607

 
読み込み中
Salesforce Help | Article