kettle从入门到精通 第117课 ETL之kettle，kettle调用his接口，入参和响应数据均为xml结构

场景：有小伙伴私聊我咨询，使用kettle调用his相关接口时，入参和响应数据均为xml结构报文，无法掉通接口。今天咱们一起来梳理下如何解决这种问题。

1、添加jar文件

1）将staxon-1.3.jar、hutool-all-5.6.0.jar、xiaojingang-https-0.0.1-SNAPSHOT.jar三个jar文件放到kettle的lib目录下。

2）重启spoon。

 

2、设计转换

1）生成记录，分别设置reqJson和respXml两个字段数据。

2）JavaScript代码，调用jar中的方法进行转换。

3）写日志，打印转换结果。

 3、生成记录

 reqJson值为json

{"Request": {"MessageHeader": {"Sender": "PIS","Receiver": "OAI","SendTime": "20240816011001","EventType": "MDM_USERS","Msgld": "TEST20241107000001"},"MessageBody": {"WorkDept": "1001231"}}
}

　respXml

<Response><MessageHeader><Sender>OAI</Sender><Receiver>PIS</Receiver><SendTime>20240816011001</SendTime><EventType>ACK_MDM_USERS</EventType><Msgld>TEST20241107000001</Msgld></MessageHeader><MessageBody><UserList><User><UserId>986306638453809870</UserId><WorkNo>0153</WorkNo><FullName>哈利</FullName><Category>1</Category><CategoryDesc>医院职工</CategoryDesc><WorkDept>1001231</WorkDept><WorkDeptName>病理科</WorkDeptName><JobStatus>1</JobStatus><JobStatusName>在职</JobStatusName><WorkPost>1</WorkPost><WorkPostName>医师</WorkPostName><WorkProfessional>306</WorkProfessional><WorkProfessionalName>副主任医师</WorkProfessionalName><Duty>0</Duty><DutyName>无</DutyName><MplFlag>Y</MplFlag><Mobile>136xxxx1868</Mobile><IdCard>420682xxxxxxxx0024</IdCard><OfficePhone/><Email/><PinyinCode>HH</PinyinCode><WubiCode>AN</WubiCode><ActiveStatus>1</ActiveStatus><ActiveStatusDesc>启用</ActiveStatusDesc><LockStatus>1</LockStatus><LockStatusDesc>正常</LockStatusDesc><HospitalCode>H0000</HospitalCode><NpCode>D420682002681</NpCode></User><User><UserId>271770908087827448</UserId><WorkNo>0467</WorkNo><FullName>波特</FullName><Category>1</Category><CategoryDesc>医院职工</CategoryDesc><WorkDept>1001231</WorkDept><WorkDeptName>病理科</WorkDeptName><JobStatus>1</JobStatus><JobStatusName>在职</JobStatusName><WorkPost>4</WorkPost><WorkPostName>医技</WorkPostName><WorkProfessional/><WorkProfessionalName/><Duty>0</Duty><DutyName>无</DutyName><MplFlag>Y</MplFlag><Mobile>138xxxx8821</Mobile><IdCard>420620xxxxxxxx0017</IdCard><OfficePhone/><Email/><PinyinCode>ZKF</PinyinCode><WubiCode>UDN</WubiCode><ActiveStatus>1</ActiveStatus><ActiveStatusDesc>启用</ActiveStatusDesc><LockStatus>1</LockStatus><LockStatusDesc>正常</LockStatusDesc><HospitalCode>H0000</HospitalCode><NpCode>HJ420682001896</NpCode></User></UserList><Result><Code>CA</Code><Desc>成功</Desc></Result></MessageBody>
</Response>

3、JavaScript代码转换

在javascript代码中调用jar文件中的方法进行转换。

 

//Script herevar staxonUtils=new Packages.com.xiaojingang.xiaojingang_https.StaxonUtils();//将json转换为xml
//var xmlStr = staxonUtils.json2xml(reqJson);
var xmlStr = staxonUtils.json2PrettyXml(reqJson);xmlStr=xmlStr.replace("<?xml version='1.0'?>",'');
//将xml转换为json
var jsonStr =staxonUtils.xml2json(respXml);

4、运行

 5、完善

解决了xml和json互转难题之后，在加上rest client接口请求步骤即可解决开头说到的问题。