Link to home
Start Free TrialLog in
Avatar of sbornstein2
sbornstein2

asked on

HttpWebRequest Parse Json Help Need Guru!

Hello all,

I have C# where I am doing a HttpWebRequest and getting the HttpWebResponse.   My response is doing a streamreader and I get the following JSON string back into a string variable.   What I need to do is somehow parse this where I need to look for the element name "levelFactor" = 1.  There will always only be one of the levels that have the levelFactor = 1 in the JSON.  After I find that I need to get the corresponding levelSize in this example 100000 and set that to an int variable called levelResult.  How can I parse through this to get that levelSize?  I also am doing this in SSIS script task so I can't easily use Newtonsoft JObject it needs to be serializing it somehow.  Thanks all

[
    {
        "categoryName": "PAYABLE",
        "clientTypeId": 5,
        "clientId": 105,
        "levels": [
            {
                "levelTypeId": 1,
                "levelFactor": 0,
                "recordId": 68,
                "levelSize": 0,
            "comp": 1
            },
            {
                "levelTypeId": 3,
                "levelFactor": 1,
                "recordId": 67,
                "levelSize": 100000,
            "comp": 7
            }
        ],
        "recordId": 34,
        "dateActive": "2018-01-14T00:00:00",
        "dateInactive": "9999-12-31T00:00:00",
        "auditDate": "2018-01-14T22:25:11.69"
    }
]
ASKER CERTIFIED SOLUTION
Avatar of Nitin Sontakke
Nitin Sontakke
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial