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...

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

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

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

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,   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/

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