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"
}
]
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.