Hi I have a problem to use Xpath.
This is the XML that I want to make JSON
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<GetSKITankStockResponse xmlns="http://tempuri.org/">
<GetSKITankStockResult>
<TIA010_Schema>
<CHANGE_DT>0001-01-01T00:00:00</CHANGE_DT>
<YMD>20180915</YMD>
<ITEM_CD>B023 </ITEM_CD>
<TANK_CD>705 </TANK_CD>
<TANK_NM>T-705 </TANK_NM>
<PBL_STOCK>0</PBL_STOCK>
<TBL_IN1>0</TBL_IN1>
<TBL_IN2>0</TBL_IN2>
<TBL_OUT1>0</TBL_OUT1>
</TIA010_Schema>
</GetSKITankStockResult>
</GetSKITankStockResponse>
</soap:Body>
</soap:Envelope>
First, I removed the soap: and I try to use Xpath. But I can't get any response.
This is my Example
Compose1:
replace(body('GetSKITankStock'),'soap:','')
Compose2:
xpath(xml(outputs('Compose')),'string(/Envelop/Body/GetSKITankStockResponse/GetSKITankStockResult/TIA010_Schema/ITEM_CD)')
Can U help me plz?
