Read xml data coming from Web Api URL

Question

Hi friends, API ex : https://Test.com/forums/post?datefrom=2017-15-20&dateto=2017-05-06&username=rajesh&password=abcd when I test my api in postman it is giving response in xml format. Now I want to read xml format and need to insert few columns data in xml into database table.

Madan Shekar · Answer

very simple u need to convert xml to json example is :- xml data is :- var xml = @" Invoice > Timestamp > 1/1/2017 00:01 Timestamp > CustNumber > 12345 CustNumber > AcctNumber > 54321 AcctNumber > /Invoice > "; Notice that I’ve got this XML as a hardcoded string in C#. In a real-life situation, you would likely be pulling XML from a database, a REST API, XML files, etc. Once you have the raw XML, you can create an XmlDocument object (XmlDocument lives in the System.Xml namespace). XmlDocument doc = new XmlDocument(); doc.LoadXml(xml); Conversion with Json.NET Once you have an XmlDocument object, you can use Json.NET to convert that object into a Json representation. var json = JsonConvert.SerializeXmlNode(doc, Formatting.None, true ); output will be like this {"Invoice":{"Timestamp":"1/1/2017 00:01","CustNumber":"12345","AcctNumber":"54321"}} If it helps mark as answer...

Abhishek Mishra · Answer

Hello , Please refer to the blog given below https://www.c-sharpcorner.com/UploadFile/2b481f/read-xml-file-by-using-web-api/ Hope it helps Thanks

Mageshwaran R · Answer

Hi, Please refer the below link, it might helps you https://www.codeproject.com/Questions/649972/how-to-read-the-xml-String-in-Csharp