How to consume Restful service in C#

Vignesh R

Dear Friends,

I am working as Microsoft Dynamics AX consultant. I have requriment to integrate AX application with .net web application. Our client have given one restful service to consume in ax. It is not possible to consume restful service in ax tool. so I want to create one class library file using C# which will GET and POST response from the API. How will I consume the restful service in C#? If i get the response from URL. I will add the dll file as reference in AX then i will proceed with remaining process. Kindly need you help here!

Thanks in advance and Regards,

Vignesh

3 Replies

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

Mageshwaran R6y ago
Hi,
Can you check with the below link:
https://stackoverflow.com/questions/32369201/how-to-consume-rest-web-service-in-c-sharp
Vignesh R7y ago
Hi Rajanikant,

Thanks for your time and suggestion.
For example: Our Restful service is in Json format. Below I have added sample data which is already available in service.
{
"datalist": [
{
"emplId": "7000043",
"emplName": "Kevin peterson",
"vendGroup": null,
"paN_NO": null,
"emplGender": "0",
"currency": "",
"bu": null,
"sbu": null,
"customerDepartment": null,
"project": null,
"unit": null,
"id": 27494
},
How will i get a response from servie and how to view this data?
Rajanikant Hawaldar7y ago
Hi Vignesh R,

check this

var url="http://localhost:8000/DEMOService/Client/156";
var webrequest = (HttpWebRequest)System.Net.WebRequest.Create(url);
using (var response = webrequest.GetResponse())
using (var reader = new StreamReader(response.GetResponseStream()))
{
var result = reader.ReadToEnd();
Label1.Text = Convert.ToString(result);
}

//sample to consume

// http://localhost:{portno}/api/v1/youractionname?UserName=yourusername&Passowrd=yourpassword [HttpGet]
[ActionName("Youractionname")]
public Object Login(string emailid, string Passowrd)
{
if (emailid == null || Passowrd == null)
{
geterror gt1 = new geterror();
gt1.status = "0";
gt1.msg = "All field is required";
return gt1;
}
else
{
string StrConn = ConfigurationManager.ConnectionStrings["cn1"].ConnectionString;
string loginid = emailid;
string Passwrd = Passowrd;
DataTable dtnews = new DataTable();
SqlConnection con = new SqlConnection(StrConn);
con.Open();
SqlCommand cmd = new SqlCommand("sp_loginapi_app", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p1 = new SqlParameter("@emailid", loginid);
SqlParameter p2 = new SqlParameter("@password", Passowrd);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
da.Fill(dtnews);
if (dtnews.Rows[0]["id"].ToString() == "-1")
{
geterror gt1 = new geterror();
gt1.status = "0";
gt1.msg = "Invalid Username or Password";
con.Close();
return gt1;
}
else
{
dtmystring.Clear();
dtmystring.Columns.Add(new DataColumn("id", typeof(int)));
dtmystring.Columns.Add(new DataColumn("Name", typeof(string)));
dtmystring.Columns.Add(new DataColumn("Password", typeof(string)));
dtmystring.Columns.Add(new DataColumn("MobileNo", typeof(string)));
dtmystring.Columns.Add(new DataColumn("Emailid", typeof(string)));
DataRow drnew = dtmystring.NewRow();
drnew["id"] = dtnews.Rows[0]["id"].ToString();
drnew["Name"] = dtnews.Rows[0]["Name"].ToString();
drnew["Password"] = dtnews.Rows[0]["Password"].ToString();
drnew["MobileNo"] = dtnews.Rows[0]["MobileNo"].ToString();
drnew["Emailid"] = dtnews.Rows[0]["emailid"].ToString();
dtmystring.Rows.Add(drnew);
gt.status = "1";
gt.msg = dtmystring;
con.Close();
return gt;
}
}
}