Trouble while parsing xml in logic apps. Flow reads xml from blob and writes to DB

(0) Share

Report

Posted on by Suhasuser

Hi All,

Following is the xml that I facing trouble with :

<?xml version="1.0" encoding="utf-16"?>

I have tried the following xpath for parsing:

xpath(xml(string(body('Get_blob_content_using_path'))),'string(/ItemNotification/ItemList/Item/PartNumber/text()')

xpath(xml(string(body('Get_blob_content_using_path'))),'string(//PartNumber/text()')

I need the Text in PartNumber node. Also tried de-batching this in a For Each loop (not required but tried it).

Following is my flow:

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

abm abm 32,858 Most Valuable Professional on at

Like (0)

Report

Re: Trouble while parsing xml in logic apps. Flow reads xml from blob and writes to DB

Hi @Suhasuser

XPath expression failed to parse XML for UTF-16 so I did changed the first line of your XML to

<?xml version="1.0" encoding="utf-8"?>

or

<?xml version="1.0"?>

Try the following steps:

Below is the expression I used.

xpath(xml(outputs('Compose_2')),'//ItemList/Item/PartNumber/text()')

Was this reply helpful? Yes No
Suhasuser 11 on at

Like (0)

Report

Re: Trouble while parsing xml in logic apps. Flow reads xml from blob and writes to DB

Yes, that was the kink giving me the error. Problem solved. Thanks to you.

Was this reply helpful? Yes No
Suhasuser 11 on at

Like (0)

Report

Re: Trouble while parsing xml in logic apps. Flow reads xml from blob and writes to DB

How to deal with this problem. I keep getting this xml from upstream how do read this using xpath in logic app if all xmls are utf-16 encoded ? Can you please give some suggestions ?

Was this reply helpful? Yes No
abm abm 32,858 Most Valuable Professional on at

Like (0)

Report

Re: Trouble while parsing xml in logic apps. Flow reads xml from blob and writes to DB

Hi @Suhasuser

Thanks for the update.

You could use a replace expression to change the XML UTF value.

Thanks

Was this reply helpful? Yes No
Suhasuser 11 on at

Like (0)

Report

Re: Trouble while parsing xml in logic apps. Flow reads xml from blob and writes to DB

Hi ,

I have used the following expression to replace the string from utf-16 to utf-8 :
replace(string(triggerBody()?['Path']),'utf-16','utf-8')

But it has not replaced as i can see in the output

Was this reply helpful? Yes No
Verified answer

abm abm 32,858 Most Valuable Professional on at

Like (1)

Report

Re: Trouble while parsing xml in logic apps. Flow reads xml from blob and writes to DB

Hi @Suhasuser

Create a compose and map the XML.

Next add another compose to use the replace.

Thanks

Was this reply helpful? Yes No