1. Discussion Forums
    2. .NET
    3. Webservices
You must Sign In to post a response.
  • Category: Webservices
    Points:5

    Parsing Json Response in C#

    Hi All,

    I am not able to parse the JSON getting it from consuming an web service .

    i am using c# , deserializing the response.content, but not table to get the records inside "orderInvoiceList" ,

    Please guide me how do i capture all the fields.

    Thanks in Advance


    Given below the JSON data :

    {"responseCode":0,"responseMessage":"Success","totalOrders":9,"totalPages":1,"currentPage":1,"orderInvoiceList":{"RWH9":{"orderLocation":"RWH","orderId":"RWH9","orderNo":"RWH9","paymentMethod":"Prepaid","status":"Confirmed","orderDate":"01/03/2019 23:18:35","orderAmount":"129.00","orderCurrency":"INR","conversionRate":"1.00","customerName":"Test123","shipAddress1":"Sector 76 Noida","shipAddress2":null,"shipAddress3":null,"shipCity":null,"shipState":"Delhi","shipCountry":"India","shipPincode":"201307","shipPhone1":"9972462835","shipPhone2":null,"shipEmail1":"test123@customer.com","shipEmail2":null,"billName":"Test123","billAddress1":"Sector 76 Noida","billAddress2":null,"billAddress3":null,"billCity":null,"billState":"Delhi","billCountry":"India","billPincode":"201307","billPhone1":"9972462835","billPhone2":null,"billEmail1":"test123@customer.com","billEmail2":null,"orderRemarks":null,"shippingCharges":"0.00","cODCharge":"0.00","handlingCharge2":"0.00","storeCredit":"0.00","isVerifiedOrder":"1","isOnHold":"0","giftvoucher":"0.00","otherDiscount":"0.00","discountCode":null,"cancelRemark":null,"isGiftwrap":"0","giftwrapMsg":"","deliverySlot":"-1","customDataFeld1":"","customDataFeld2":"","customDataFeld3":"","customDataFeld4":"","customDataFeld5":"","discountAmount":"0.000","taxAmount":"13.82","updatedDate":"01/03/2019 23:19:13","delivery_no":null,"invoice_no":null,"items":[{"lineno":"1","sku":"ROOKIE","orderQty":"1.00","cancelledQty":"0.00","shippedQty":"0.00","returnQty":"0.00","unitPrice":"129.000","discountAmt":"0.000","taxAmount":"0.000"}]},"RWH7":{"orderLocation":"RWH","orderId":"RWH7","orderNo":"RWH7","paymentMethod":"Prepaid","status":"Confirmed","orderDate":"01/03/2019 17:37:40","orderAmount":"200.00","orderCurrency":"INR","conversionRate":"1.00","customerName":"Test123","shipAddress1":"Sector 76 Noida","shipAddress2":null,"shipAddress3":null,"shipCity":null,"shipState":"Delhi","shipCountry":"India","shipPincode":"201307","shipPhone1":"9972462835","shipPhone2":null,"shipEmail1":"test123@customer.com","shipEmail2":null,"billName":"Test123","billAddress1":"Sector 76 Noida","billAddress2":null,"billAddress3":null,"billCity":null,"billState":"Delhi","billCountry":"India","billPincode":"201307","billPhone1":"9972462835","billPhone2":null,"billEmail1":"test123@customer.com","billEmail2":null,"orderRemarks":null,"shippingCharges":"0.00","cODCharge":"0.00","handlingCharge2":"0.00","storeCredit":"0.00","isVerifiedOrder":"1","isOnHold":"0","giftvoucher":"0.00","otherDiscount":"0.00","discountCode":null,"cancelRemark":null,"isGiftwrap":"0","giftwrapMsg":"","deliverySlot":"-1","customDataFeld1":"","customDataFeld2":"","customDataFeld3":"","customDataFeld4":"","customDataFeld5":"","discountAmount":"0.000","taxAmount":"21.43","updatedDate":"01/03/2019 17:46:19","delivery_no":null,"invoice_no":null,"items":[{"lineno":"1","sku":"SANDY","orderQty":"1.00","cancelledQty":"0.00","shippedQty":"0.00","returnQty":"0.00","unitPrice":"200.000","discountAmt":"0.000","taxAmount":"0.000"}]},"RWH5":{"orderLocation":"RWH","orderId":"RWH5","orderNo":"RWH5","paymentMethod":"Prepaid","status":"Confirmed","orderDate":"01/03/2019 16:58:20","orderAmount":"120.00","orderCurrency":"INR","conversionRate":"1.00","customerName":"Test123","shipAddress1":"Sector 76 Noida","shipAddress2":null,"shipAddress3":null,"shipCity":null,"shipState":"Delhi","shipCountry":"India","shipPincode":"201307","shipPhone1":"9972462835","shipPhone2":null,"shipEmail1":"test123@customer.com","shipEmail2":null,"billName":"Test123","billAddress1":"Sector 76 Noida","billAddress2":null,"billAddress3":null,"billCity":null,"billState":"Delhi","billCountry":"India","billPincode":"201307","billPhone1":"9972462835","billPhone2":null,"billEmail1":"test123@customer.com","billEmail2":null,"orderRemarks":null,"shippingCharges":"0.00","cODCharge":"0.00","handlingCharge2":"0.00","storeCredit":"0.00","isVerifiedOrder":"1","isOnHold":"0","giftvoucher":"0.00","otherDiscount":"0.00","discountCode":null,"cancelRemark":null,"isGiftwrap":"0","giftwrapMsg":"","deliverySlot":"-1","customDataFeld1":"","customDataFeld2":"","customDataFeld3":"","customDataFeld4":"","customDataFeld5":"","discountAmount":"0.000","taxAmount":"12.86","updatedDate":"01/03/2019 16:59:22","delivery_no":null,"invoice_no":null,"items":[{"lineno":"1","sku":"DAYA","orderQty":"1.00","cancelledQty":"0.00","shippedQty":"0.00","returnQty":"0.00","unitPrice":"120.000","discountAmt":"0.000","taxAmount":"0.000"}]},"RWH17":{"orderLocation":"RWH","orderId":"RWH17","orderNo":"RWH17","paymentMethod":"Prepaid","status":"Confirmed","orderDate":"02/03/2019 12:19:29","orderAmount":"400.00","orderCurrency":"INR","conversionRate":"1.00","customerName":"Test123","shipAddress1":"Sector 76 Noida","shipAddress2":null,"shipAddress3":null,"shipCity":null,"shipState":"Delhi","shipCountry":"India","shipPincode":"201307","shipPhone1":"9972462835","shipPhone2":null,"shipEmail1":"test123@customer.com","shipEmail2":null,"billName":"Test123","billAddress1":"Sector 76 Noida","billAddress2":null,"billAddress3":null,"billCity":null,"billState":"Delhi","billCountry":"India","billPincode":"201307","billPhone1":"9972462835","billPhone2":null,"billEmail1":"test123@customer.com","billEmail2":null,"orderRemarks":null,"shippingCharges":"0.00","cODCharge":"0.00","handlingCharge2":"0.00","storeCredit":"0.00","isVerifiedOrder":"1","isOnHold":"0","giftvoucher":"0.00","otherDiscount":"0.00","discountCode":null,"cancelRemark":null,"isGiftwrap":"0","giftwrapMsg":"","deliverySlot":"-1","customDataFeld1":"","customDataFeld2":"","customDataFeld3":"","customDataFeld4":"","customDataFeld5":"","discountAmount":"0.000","taxAmount":"42.86","updatedDate":"02/03/2019 12:19:37","delivery_no":null,"invoice_no":null,"items":[{"lineno":"1","sku":"26D842","orderQty":"1.00","cancelledQty":"0.00","shippedQty":"0.00","returnQty":"0.00","unitPrice":"400.000","discountAmt":"0.000","taxAmount":"42.860"}]},"RWH6":{"orderLocation":"RWH","orderId":"RWH6","orderNo":"RWH6","paymentMethod":"Prepaid","status":"Confirmed","orderDate":"01/03/2019 17:12:44","orderAmount":"700.00","orderCurrency":"INR","conversionRate":"1.00","customerName":"Test123","shipAddress1":"Sector 76 Noida","shipAddress2":null,"shipAddress3":null,"shipCity":null,"shipState":"Delhi","shipCountry":"India","shipPincode":"201307","shipPhone1":"9972462835","shipPhone2":null,"shipEmail1":"test123@customer.com","shipEmail2":null,"billName":"Test123","billAddress1":"Sector 76 Noida","billAddress2":null,"billAddress3":null,"billCity":null,"billState":"Delhi","billCountry":"India","billPincode":"201307","billPhone1":"9972462835","billPhone2":null,"billEmail1":"test123@customer.com","billEmail2":null,"orderRemarks":null,"shippingCharges":"0.00","cODCharge":"0.00","handlingCharge2":"0.00","storeCredit":"0.00","isVerifiedOrder":"1","isOnHold":"0","giftvoucher":"0.00","otherDiscount":"0.00","discountCode":null,"cancelRemark":null,"isGiftwrap":"0","giftwrapMsg":"","deliverySlot":"-1","customDataFeld1":"","customDataFeld2":"","customDataFeld3":"","customDataFeld4":"","customDataFeld5":"","discountAmount":"0.000","taxAmount":"75.00","updatedDate":"01/03/2019 17:31:37","delivery_no":null,"invoice_no":null,"items":[{"lineno":"1","sku":"VEER","orderQty":"1.00","cancelledQty":"0.00","shippedQty":"0.00","returnQty":"0.00","unitPrice":"700.000","discountAmt":"0.000","taxAmount":"0.000"}]},"RWH1":{"orderLocation":"RWH","orderId":"RWH1","orderNo":"RWH1","paymentMethod":"Prepaid","status":"Confirmed","orderDate":"01/03/2019 15:06:56","orderAmount":"1200.00","orderCurrency":"INR","conversionRate":"1.00","customerName":"eRetail Test","shipAddress1":"wewew","shipAddress2":null,"shipAddress3":null,"shipCity":null,"shipState":"Delhi","shipCountry":"India","shipPincode":"110022","shipPhone1":"9999999999","shipPhone2":null,"shipEmail1":"eretaildevteam@gmail.com","shipEmail2":null,"billName":"eRetail Test","billAddress1":"wewew","billAddress2":null,"billAddress3":null,"billCity":null,"billState":"Delhi","billCountry":"India","billPincode":"110022","billPhone1":"9999999999","billPhone2":null,"billEmail1":"eretaildevteam@gmail.com","billEmail2":null,"orderRemarks":null,"shippingCharges":"0.00","cODCharge":"0.00","handlingCharge2":"0.00","storeCredit":"0.00","isVerifiedOrder":"1","isOnHold":"0","giftvoucher":"0.00","otherDiscount":"0.00","discountCode":null,"cancelRemark":null,"isGiftwrap":"0","giftwrapMsg":"","deliverySlot":"-1","customDataFeld1":"","customDataFeld2":"","customDataFeld3":"","customDataFeld4":"","customDataFeld5":"","discountAmount":"0.000","taxAmount":"128.57","updatedDate":"01/03/2019 15:07:05","delivery_no":null,"invoice_no":null,"items":[{"lineno":"1","sku":"TEST","orderQty":"10.00","cancelledQty":"0.00","shippedQty":"0.00","returnQty":"0.00","unitPrice":"120.000","discountAmt":"0.000","taxAmount":"0.000"}]},"RWH12":{"orderLocation":"RWH","orderId":"RWH12","orderNo":"RWH12","paymentMethod":"Prepaid","status":"Confirmed","orderDate":"02/03/2019 00:50:16","orderAmount":"120.00","orderCurrency":"INR","conversionRate":"1.00","customerName":"Test123","shipAddress1":"Sector 76 Noida","shipAddress2":null,"shipAddress3":null,"shipCity":null,"shipState":"Delhi","shipCountry":"India","shipPincode":"201307","shipPhone1":"9972462835","shipPhone2":null,"shipEmail1":"test123@customer.com","shipEmail2":null,"billName":"Test123","billAddress1":"Sector 76 Noida","billAddress2":null,"billAddress3":null,"billCity":null,"billState":"Delhi","billCountry":"India","billPincode":"201307","billPhone1":"9972462835","billPhone2":null,"billEmail1":"test123@customer.com","billEmail2":null,"orderRemarks":null,"shippingCharges":"0.00","cODCharge":"0.00","handlingCharge2":"0.00","storeCredit":"0.00","isVerifiedOrder":"1","isOnHold":"0","giftvoucher":"0.00","otherDiscount":"0.00","discountCode":null,"cancelRemark":null,"isGiftwrap":"0","giftwrapMsg":"","deliverySlot":"-1","customDataFeld1":"","customDataFeld2":"","customDataFeld3":"","customDataFeld4":"","customDataFeld5":"","discountAmount":"0.000","taxAmount":"12.86","updatedDate":"02/03/2019 00:51:52","delivery_no":null,"invoice_no":null,"items":[{"lineno":"1","sku":"DAYA","orderQty":"1.00","cancelledQty":"0.00","shippedQty":"0.00","returnQty":"0.00","unitPrice":"120.000","discountAmt":"0.000","taxAmount":"0.000"}]},"RWH13":{"orderLocation":"RWH","orderId":"RWH13","orderNo":"RWH13","paymentMethod":"Prepaid","status":"Confirmed","orderDate":"02/03/2019 00:56:47","orderAmount":"120.00","orderCurrency":"INR","conversionRate":"1.00","customerName":"Test123","shipAddress1":"Sector 76 Noida","shipAddress2":null,"shipAddress3":null,"shipCity":null,"shipState":"Delhi","shipCountry":"India","shipPincode":"201307","shipPhone1":"9972462835","shipPhone2":null,"shipEmail1":"test123@customer.com","shipEmail2":null,"billName":"Test123","billAddress1":"Sector 76 Noida","billAddress2":null,"billAddress3":null,"billCity":null,"billState":"Delhi","billCountry":"India","billPincode":"201307","billPhone1":"9972462835","billPhone2":null,"billEmail1":"test123@customer.com","billEmail2":null,"orderRemarks":null,"shippingCharges":"0.00","cODCharge":"0.00","handlingCharge2":"0.00","storeCredit":"0.00","isVerifiedOrder":"1","isOnHold":"0","giftvoucher":"0.00","otherDiscount":"0.00","discountCode":null,"cancelRemark":null,"isGiftwrap":"0","giftwrapMsg":"","deliverySlot":"-1","customDataFeld1":"","customDataFeld2":"","customDataFeld3":"","customDataFeld4":"","customDataFeld5":"","discountAmount":"0.000","taxAmount":"12.86","updatedDate":"02/03/2019 00:57:11","delivery_no":null,"invoice_no":null,"items":[{"lineno":"1","sku":"DAYA","orderQty":"1.00","cancelledQty":"0.00","shippedQty":"0.00","returnQty":"0.00","unitPrice":"120.000","discountAmt":"0.000","taxAmount":"0.000"}]},"RWH10":{"orderLocation":"RWH","orderId":"RWH10","orderNo":"RWH10","paymentMethod":"Prepaid","status":"Pending","orderDate":"02/03/2019 00:09:08","orderAmount":"129.00","orderCurrency":"INR","conversionRate":"1.00","customerName":"Test123","shipAddress1":"Sector 76 Noida","shipAddress2":null,"shipAddress3":null,"shipCity":null,"shipState":"Delhi","shipCountry":"India","shipPincode":"201307","shipPhone1":"9972462835","shipPhone2":null,"shipEmail1":"test123@customer.com","shipEmail2":null,"billName":"Test123","billAddress1":"Sector 76 Noida","billAddress2":null,"billAddress3":null,"billCity":null,"billState":"Delhi","billCountry":"India","billPincode":"201307","billPhone1":"9972462835","billPhone2":null,"billEmail1":"test123@customer.com","billEmail2":null,"orderRemarks":null,"shippingCharges":"0.00","cODCharge":"0.00","handlingCharge2":"0.00","storeCredit":"0.00","isVerifiedOrder":"1","isOnHold":"0","giftvoucher":"0.00","otherDiscount":"0.00","discountCode":null,"cancelRemark":null,"isGiftwrap":"0","giftwrapMsg":"","deliverySlot":"-1","customDataFeld1":"","customDataFeld2":"","customDataFeld3":"","customDataFeld4":"","customDataFeld5":"","discountAmount":"0.000","taxAmount":"13.82","updatedDate":"02/03/2019 00:10:35","delivery_no":null,"invoice_no":null,"items":[{"lineno":"1","sku":"ROOKIE","orderQty":"1.00","cancelledQty":"0.00","shippedQty":"0.00","returnQty":"0.00","unitPrice":"129.000","discountAmt":"0.000","taxAmount":"0.000"}]}}}
  • #769843

    Points:4
    Hi Vinay,
    You can make use of newton json converter (nuget package) to parse your json.

    Sample:
    // First define your json content as properties in a model class as below:

    public class Students
    {
    public List<StudentInformation> data { get; set; }
    }

    public class StudentInformation
    {
    public string success { get; set; }
    public string terms { get; set; }
    public string privacy { get; set; }
    public string timestamp { get; set; }
    public string source { get; set; }
    }

    --- JSON PARSER -----

    using System.Linq;
    using Newtonsoft.Json;
    using Newtonsoft.Json.Linq;

    static void Main(string[] args)
    {
    string json = @"your json content";
    Students students = JsonConvert.DeserializeObject<Students>(json);
    foreach (var item in students.data)
    {
    Console.WriteLine("id: {0}, name: {1}", item.source, item.terms);
    Console.ReadLine();
    }
    }

    Hope it helps you...

  • #769848

    Points:1
    well its an complex json, "RWH000000037" these values are coming dynamically, i am not able to read it. please guide

    {
    "responseCode": 0,
    "responseMessage": "Success",
    "totalOrders": 2,

    "orderInvoiceList": {
    "RWH000000037": {
    "orderLocation": "RWH",
    "orderId": "RWH32",
    "orderNo": "RWH32",
    "delivery_no": "RWH000000037",
    "invoice_no": "RWH-2018/19-023",
    "items": [
    {
    "lineno": "1",
    "sku": "214653",
    "orderQty": "1.00"

    },
    {
    "lineno": "2",
    "sku": "214286",
    "orderQty": "1.00"

    }

    ]
    },
    "RWH000000036": {
    "orderLocation": "RWH",
    "orderId": "RWH31",
    "orderNo": "RWH31",
    "delivery_no": "RWH000000036",
    "invoice_no": "RWH-2018/19-022",
    "items": [
    {
    "lineno": "1",
    "sku": "468436",
    "orderQty": "1.00"

    }
    ]
    }
    }
    }

  • #769855

    Points:4
    Hi Vinay,

    This is a VS2017 project, console app. Newtonsoft added through "Tools/NuGet Package Manager/Manage NuGet Packages for Solution...". Your data from the post is in the file "C:\Projekt\JSONtest\test.json". (Projekt is Swedish and means Project in English).

    This way you get a raw view of the json data, the rest is up to you.

    using System;
    using System.IO;
    using Newtonsoft.Json;

    namespace JSONtest
    {
    class Program
    {
    static void Main(string[] args)
    {
    string json = File.ReadAllText(@"C:\Projekt\JSONtest\test.json");

    JsonTextReader reader = new JsonTextReader(new StringReader(json));
    while (reader.Read())
    {
    if (reader.Value != null)
    {
    Console.WriteLine("Token: {0}, Value: {1}", reader.TokenType, reader.Value);
    }
    else
    {
    Console.WriteLine("Token: {0}", reader.TokenType);
    }
    }
    }
    }
    }


    • Sign In to post your comments
    Submit New Thread
    Return to Return to Discussion Forum

    Top Contributors

    TodayLast 7 Days

    more...

    Email subscription

  • .NET Jobs
  • .NET Articles
  • .NET Forums
    • Articles Rss Feeds
    Forum Rss Feeds

    About dotnetspider.com

    We believe in providing quality content to our readers. If you have any questions or concerns regarding any content published here, feel free to contact us using the Contact link below.

    Quick Links
    General
    Services

    Digital Marketing by SpiderWorks Technologies, Kochi - India. ©