consume web api without database

initally i have json file in which some get methods are defined and i don't have database and i want consume web api in asp.net core console application and read json file from json file and send data to database.

url which i have passes in main method (which is access through postman, impport the json file in postman and retrieved some GET methods).

so please help me in this code

how to consume web service and send data to database.

i have created ue_GDL_CustAddrs.cs which contains

public class ue_GDL_CustAddrs
{
public string Name { get; set; }
public string Addr1 { get; set; }
public string Addr2 { get; set; }
}
public async void GET(string url)
{
//string result = string.Empty;
HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create(url);
httpWebRequest.Method = "Get";
StreamReader reader;
try
{
HttpClient client = new HttpClient();
client.BaseAddress = new Uri(url);
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage response = client.GetAsync("https://csi10a.erpsl.inforcloudsuite.com/IDORequestService/ido/load/ue_GDL_CustAddrs").Result;
if (response.IsSuccessStatusCode)
{
IEnumerable < ue_GDL_CustAddrs > Addr = response.Content.ReadAsAsync>().Result;
foreach (var p in Addr)
{
Console.WriteLine("{0}\t{1};\t{2}", p.Name, p.Addr1, p.Addr2);
Console.ReadLine();
}
}
else
{
Console.WriteLine("{0} ({1})", (int)response.StatusCode, response.ReasonPhrase);
}
}
catch (WebException ex)
{
WebResponse errorResponse = ex.Response;
using (Stream responseStream = errorResponse.GetResponseStream())
{
reader = new StreamReader(responseStream, System.Text.Encoding.GetEncoding("utf-8"));
String errorText = reader.ReadToEnd();
}
throw;
}
}

i have send the url through main method but got an exception

One or more errors occurred. (Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'System.Collections.Generic.IEnumerable`1[Englert_Ewarranty_QAD_Integration_Details.ue_GDL_CustAddrs]' 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.

Path 'Items', line 2, position 10.)'

2 Replies

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

Ritu5y ago
no
0
Arnab Mukherjee5y ago
Hi Ritu, You might be getting this error because of json serialization. You need to create a model class which needs to match the structure of your JSON. There are a couple of ways to create this model.You can check the below link. https://stackoverflow.com/questions/37216070/c-sharp-create-a-net-object-for-json-serialization-and-deserialization
0