Getting Data From WebAPI

Question

Dear Team,

I have received 1 API (hyperlink).

I have to get data from that API into a datatable and display it on gridview.

API -

http://abcd.efg.com:8081/ManagerWebService/computer.computertype,model.brand.name,model.name,computer.tcpiphostname,asset.serialno,user.username,RIL_Inventoried_User.username,Asset.Field1%20where%20model.parent.name='Desk%20Comp'%20AND%20RIL_cUser_Acceptance=0%20AND%20user.username='efgh.ijkl'

Input Parameter is - 'efgh.ijkl' - That will vary for each user.

How do I do this task??

Please guide...

Jaimin Shethiya · Answer

Hello Riddhi, can you please try this code. string xml = @" Desktops Acer PR87654 DT5567899 rtgfdeyujj77 Salman.Khan CPU-Acer-PR87654-5 GD FVC DATA "; DataSet ds = new DataSet(); StringReader reader = new StringReader(xml); ds.ReadXml(reader); let me know if you have needed any help from myside. Thanks

Jaimin Shethiya · Answer

Hello Riddhi, can you please refer below link for XML to Datatable convert https://stackoverflow.com/questions/6228315/convert-xml-to-datatable https://dotnetfiddle.net/wfo4Fz https://www.codeproject.com/Questions/403941/How-to-convert-a-XMl-File-to-DataTable-using-Cshar Thanks

Riddhi Valecha · Answer

Dear Team, How do I format the above result?

Riddhi Valecha · Answer

Dear Team, I am attaching the datatable that I am getting from the xml string. Method used - public DataTable stam() { StringReader theReader = new StringReader(xmlData); DataSet theDataSet = new DataSet(); theDataSet.ReadXml(theReader); return theDataSet.Tables[3]; }

Riddhi Valecha · Answer

Dear All, I tried the following code - public DataTable stam() { StringReader theReader = new StringReader(xmlData); DataSet theDataSet = new DataSet(); theDataSet.ReadXml(theReader); return theDataSet.Tables[3]; } ------ But I need result as - ---------- Computer.ComputerType Model.Brand.Name Model.Name Computer.TcpIpHostName Asset.SerialNo User.UserName RIL_Inventoried_User.UserName Asset.Field1 Desktop Acer PR87654 LTYU88890 PQIUJHT67B Salman.Khan Salman.Khan The tag are the list of columns and - These are the values for the columns. There can be more than 1 row also. I am not able to f

Riddhi Valecha · Answer

Dear Team, I am getting the following output in xml format. PLease help me to put it in datatable and display it in gridview. Output - --------- Desktops Acer PR87654 DT5567899 rtgfdeyujj77 Salman.Khan CPU-Acer-PR87654-5 GD FVC DATA

Salman Beg · Answer

Follow this link, https://www.c-sharpcorner.com/blogs/convert-xml-to-dataset-in-c-sharp

Riddhi Valecha · Answer

Dear Team, I am getting output in xml format in postman and also when I run this API in chrome. Both are giving output in xml format. I have to get this output in a datatable and display in gridview. Here is where I am facing issue. How do I convert xml to datatable and display the results??

Ashutosh Gupta · Answer

first check what kind of output is provided by this url, JSON or xml? u can use c# api httpclient / webclient to get the data from this url and convert into your respective object.

Rajeesh Menoth · Answer

Hi, In post man just check what is the response are you getting from the API and based on that need to structure the api. If you don't know how to do that then just search "json to c#" online converter It will generate C# structure within seconds. Username you can append in the API based on the login. Reference : https://docs.microsoft.com/en-us/aspnet/web-api/overview/advanced/calling-a-web-api-from-a-net-client https://www.c-sharpcorner.com/article/calling-web-api-using-httpclient/

Salman Beg · Answer

Hi. Please follow these links which provide an example, https://www.c-sharpcorner.com/article/calling-web-api-using-httpclient/ https://www.tutorialsteacher.com/webapi/consuming-web-api-in-dotnet-using-httpclient Thanks.