Power Platform Community Forum Thread Details

Difficult to use Xpath(XML)

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?

Quick Links

Leaderboard