Unanswered

Parsing XML CData

(0) Share

Report

Posted on by joshlwulf

I have a flow where I make an HTTP request for xml data. I'm using xpath to parse it but it's not handling CDATA properly. It's showing me <![CDATA[California]]> as the output instead of just California.

This is my input: xpath(xml(item()),'string(/Dinger/StateName)')

Everything is right in my outputs for all elements except this. Is there something I can do differently in my xpath expressions for the elements with CDATA? If not, how do I handle transformation in Flow to remove the text and characters that I don't want?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

Re: Parsing XML CData

Hi @joshlwulf

Could you provide an example/sample output from the http request?

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (0)

Report
Re: Parsing XML CData

Hi @joshlwulf,

There is no direct function could process the CDATA part in the XML file.

The only way in my mind is using the replace() function to remove these characters:

replace(replace(outputs('Compose'),'<[CDATA[',''),']]>','')

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No