Error while trying to read xml from URL in asp.net core 2.1

Abhijeet Pandey

8y1.4k.NET

I am trying to read a XML file from a URL and below is my code in .net core

var url = "https://some.com/feeds/newfile.xml";

var httpClient = new HttpClient();

var result = httpClient.GetAsync(url).Result;

var stream = result.Content.ReadAsStreamAsync().Result;

var itemXml = XElement.Load(stream);

when the deubgger hits at .load , it throws an error "error on line 22 at column 46: xmlParseEntityRef: no name"

Below is the snapshot of the XML where error occurs ie line 22

Win management’s support for your LOTO & machine guarding initiatives

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jeeva Subburaj8y ago
Accepted answer
The best approach is to read as string first and replace the & character with space or some other charcter before loading into xelement.
var stringContent= result.Content.ReadAsStringAsync().Result;
stringContent = stringContent.Replace("&"," ");
0
Abhijeet Pandey8y ago
Thank you, for your response.

Any way I can encode it before it loads?
0
Jeeva Subburaj8y ago
The ampersand & makes your XML invalid. you have to remove or replace with some other character before you parse the xml content to solve the issue.
0