Separate JSON objects with JSON.NET (vb)

Question

I am having trouble separating pieces of a JSON object. Inside the json string there are 3 objects. One is called "JSONData", which I need to separate into its own object. I have tried so many things I'm starting to lose track. Two of which that seems to have been most helpful are below. However, they both end up empty. No errors, just empty. Hopefully someone can help!!

Dim j As String = JsonConvert.SerializeXmlNode(xml) 'Started out as XML
Dim o As JObject = JsonConvert.DeserializeObject(j) 'Then Json String to JObject
Dim channel As JObject = DirectCast(o("JSONData"), JObject) 'Try #1 to separate
'/// or
Dim jsondata As String = o.Item("JSONData") 'Try #2
'/// i have tried both above with ("IMSXMLLog.JSONData") as well. Same Result.

https://jsfiddle.net/jharris8567/v23kj42v/ - Full JSON

Brian Rogers · Accepted Answer · 2015-11-02 18:59:29Z

2

JSONData is inside another object IMSXMLLog, so your inclination to use the path IMSXMLLog.JSONData is correct. However, the indexer on JToken does not support paths, only single property names. To use path syntax you need to use the SelectToken method:

Dim data as JObject = DirectCast(o.SelectToken("IMSXMLLog.JSONData"), JObject)

Fiddle: https://dotnetfiddle.net/Wu70Tu

edited Nov 2, 2015 at 18:59

answered Nov 2, 2015 at 18:48

Brian Rogers

130k31 gold badges315 silver badges315 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

RandomlyOnside Over a year ago

AH! SOOO CLOSE!! Thanks so much!

Collectives™ on Stack Overflow

Separate JSON objects with JSON.NET (vb)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related