How to consume the web api in xamarin forms?

Demo Cloud

5y1.5kMobile Development

Hello,

Below is the code for web api, I wanted to consume/call the web api in xamarin forms and bind the result to the picker.

[System.Web.Http.HttpGet]
public HttpResponseMessage GetNames()
{
//Conectionstrings for different databases
string client1 = ConfigurationManager.ConnectionStrings["client_db1"].ConnectionString;
string client2 = ConfigurationManager.ConnectionStrings["client_db2"].ConnectionString;
string client3 = ConfigurationManager.ConnectionStrings["client_db3"].ConnectionString;
//Applying the select command for different databases
SqlConnection con = new SqlConnection(client1);
SqlDataAdapter da1 = new SqlDataAdapter("select provider_name,Id from Provider_details", con);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
con = new SqlConnection(client2);
da1.SelectCommand.Connection = con;
DataSet ds2 = new DataSet();
da1.Fill(ds2);
con = new SqlConnection(client3);
da1.SelectCommand.Connection = con;
DataSet ds3 = new DataSet();
da1.Fill(ds3);
//Merging the database to select the provider name
ds1.Merge(ds2);
ds1.Merge(ds3);
return Request.CreateResponse(HttpStatusCode.OK, ds1);
}

Please help me,

Thanks

12 Replies

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

Sachin Singh5y ago
Accepted answer
as per your response you need to create two classes , full code is shown below , don't change anything except url. the property Table is important.
public void  GetData()
{
  var httpClient=new HttpClient();

            HttpResponseMessage data= client.GetAsync("api/controllerName").Result;
            if (data.IsSuccessStatusCode)
            {


                var source=data.Content.ReadAsAsync().Result;

                   picker.ItemsSource = source.Table.ToList();
            }
            else
            {
                return null;
            }

}

   public class MyData
    {
        public List Table { get; set; }
    }

    public class JsonObject
    {
        public int Id { get; set; }

        public string provider_name { get; set; }
    }
+2
Sachin Singh5y ago
if (data.IsSuccessStatusCode)
{

var name= JsonConvert.DeserializeObject(data);
provider_name.ItemsSource = name;
return dataList;
}
+2
Demo Cloud5y ago
Hello,

below is the updated code, please help
getting error for data at json line

public List GetData()
{
var httpClient = new HttpClient();
List dataList = new List();
HttpResponseMessage data = httpClient.GetAsync("http://192.168.0.108:8080/api/Multi_DB_Login/GetNames").Result;
if (data.IsSuccessStatusCode)
{
dataList = data.Content.ReadAsAsync>().Result.ToList();
var name= JsonConvert.DeserializeObject>(data);
provider_name.ItemsSource = name;
return dataList;
}
else
{ return null;}
}

THanks
+2
Sachin Singh5y ago
add reference of Json.Net and do like below , idk which type of reference you are getting
public List  GetData()
{
  var httpClient=new HttpClient();
  List dataList = new List();
            HttpResponseMessage data= client.GetAsync("api/controllerName").Result;
            if (data.IsSuccessStatusCode)
            {
               // var data= data.Content.ReadAsAsync>().Result.ToList();

                return JsonConvert.DeserializeObject>(data)  ;
            }
            else
            {
                return null;
            }

}
+1
Demo Cloud5y ago
Hello,

After changing the code, im getting below error,

System.AggregateException: 'One or more errors occurred. (Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'System.Collections.Generic.List`1[Multiple.Models.Provider_name]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly.
To fix this error either change the JSON to a JSON array (e.g. [1,2,3]) or change the deserialized type so that it is a normal .NET type (e.g. not a primitive type like integer, not a collection type like an array or List) that can be deserialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object.

Please help
Thanks
+2
Sachin Singh5y ago
set the item source to datalist
var picker = new Picker { Title = "Select a monkey", TitleColor = Color.Red };
picker.ItemsSource = dadaList; // api response.ToList();
+2
Demo Cloud5y ago
Hello,
Thanks for your quick response, how to bind it to the picker as in the example we are returing the list.
Thanks.
+2
Sachin Singh5y ago
this is very very common error install Client
PM> install-package Microsoft.AspNet.WebApi.Client
+2
Demo Cloud5y ago
Hello,
Thank you I understood and I've already changed the variable , but Im getting an error,

Severity Code Description Project File Line Suppression State Error CS1061 'HttpContent' does not contain a definition for 'ReadAsAsync' and no accessible extension method 'ReadAsAsync' accepting a first argument of type 'HttpContent' could be found (are you missing a using directive or an assembly reference?)

Pleaser help
Thanks
+2
Sachin Singh5y ago
it was a typo error
getEmployee actually was data.
+2
Demo Cloud5y ago
Hello,
what is getEmployee in the code?
Thanks
+1
Sachin Singh5y ago
give a referenece of Sytem.Net.Http and use HttpClient in Xamrine forms
public List GetData()
{
  var httpClient=new HttpClient();
  List dataList = new List();
            HttpResponseMessage data= client.GetAsync("api/controllerName").Result;
            if (data.IsSuccessStatusCode)
            {
                dataList= data.Content.ReadAsAsync>().Result.ToList();

                return dataList;
            }
            else
            {
                return null;
            }

}


public class ConnectionObj
{

public int Id{get;set;}

public string provider_name{get;set;}

}
+2