Dear All, i am using api and there is data coming in Json i need to convert into Datatable and i created public class as well and trying to desrilized but not working. please need your support.
below my code and json format.
var response = await client.SendAsync(request); response.EnsureSuccessStatusCode();
string responseData = await response.Content.ReadAsStringAsync(); var data = JsonConvert.DeserializeObject<Datum>(responseData);
public class Branch { public string id { get; set; } public Name name { get; set; } } // private DateTime date = "2023-10-23"; public class Datum { public string id { get; set; } public string type { get; set; } public string origin { get; set; } public string documentNumber { get; set; } public DateTime documentDate { get; set; } public string currency { get; set; } public Supplier supplier { get; set; } public Retailer retailer { get; set; } public Location location { get; set; } public Branch branch { get; set; } public List<Item> items { get; set; } public Totals totals { get; set; } }
public class Item { public ItemCategory itemCategory { get; set; } public double lineAmount { get; set; } public int discount { get; set; } public double subTotal { get; set; } public int taxRate { get; set; } public string taxCode { get; set; } public double taxAmount { get; set; } public double total { get; set; } }
public class ItemCategory { public string id { get; set; } public Name name { get; set; } }
public class Location { public string id { get; set; } public Name name { get; set; } }
public class Metadata { public int count { get; set; } public int total { get; set; } }
public class Name { public string en { get; set; } public object ar { get; set; } }
public class Retailer { public string id { get; set; } public Name name { get; set; } }
public class Root { public List<Datum> data { get; set; } public Metadata metadata { get; set; } }
public class Supplier { public string id { get; set; } public Name name { get; set; } }
public class Totals { public double taxAmount { get; set; } public double subTotal { get; set; } public double total { get; set; } }
Json file
{
"data": [
"id": "653f7b98175871ae0da687b0",
"type": "invoice",
"origin": "purchase",
"documentNumber": "2023/10/00218",
"documentDate": "2023-10-28T14:00:06.805Z",
"currency": "SAR",
"supplier": {
"id": "6537a057fc7d89c5400713ef",
"name": {
"en": "Supplier Name"
}
},
"retailer": {
"id": "64e4527cc78560ea7f3bb2b8",
"en": "Company Name"
"location": {
"id": "64e4527cc78560ea7f3bb2c1",
"en": "Food"
"branch": {
"id": "64e4527cc78560ea7f3bb2ba",
"en": "ABC",
"ar": null
"items": [
"itemCategory": {
"id": "64e477e4b5958a0428e41440",
"en": "Meat",
"lineAmount": 684.552,
"discount": 0,
"subTotal": 684.552,
"taxRate": 15,
"taxCode": "VAT15",
"taxAmount": 102.6828,
"total": 787.2348000000001
],
"totals": {