Databases
StackOverflow2013
Postsdbo
POHow to decode JSON in C#
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to decode JSON in C#
    text
    copied!<p>I'm trying to decode JSON received from twitter streaming API using JSONConvert from NewtonSoft.Json</p> <p>I created this class to mimic the twitter status object</p> <pre><code>class tweeter { public string geo { get; set; } public string text { get; set; } public string name { get; set; } public string screen_name { get; set; } public string created_at { get; set; } public string id { get; set; } } </code></pre> <p>Then in my code I do the following to decode it</p> <pre><code>try { System.Threading.Interlocked.Increment(ref linesRead); var des = JsonConvert.DeserializeObject&lt;tweeter&gt;(e.Line); listBox1.Items.Add(e.Line); dbhelper.insertTweet(des.id,des.screen_name,des.text,des.created_at,"","","", com); listBox1.SelectedIndex = listBox1.Items.Count - 1; listBox1.SelectedIndex = -1; label1.Text = string.Format("Lines Read: {0:F0}", linesRead); } catch (Exception x) { MessageBox.Show(x.Message); } </code></pre> <p>However, the nested elements like screen_name for example, always return null, how do I access those nested elements?</p> <p>The other root elements like geo, text, created_at, id, return normally and have values.</p> <p>ُEDIT: this is a sample from the feed<code>{"in_reply_to_status_id":null,"favorited":false,"text":"Haa I'm joking everyone I wish! Need it for #ibiza2012 and #Egypt","in_reply_to_status_id_str":null,"entities":{"hashtags":[{"text":"ibiza2012","indices":[44,54]},{"text":"Egypt","indices":[59,65]}],"urls":[],"user_mentions":[]},"geo":null,"retweet_count":0,"place":null,"truncated":false,"created_at":"Wed Mar 14 15:14:47 +0000 2012","in_reply_to_user_id_str":null,"source":"\u003Ca href=\"http:\/\/twitter.com\/#!\/download\/iphone\" rel=\"nofollow\"\u003ETwitter for iPhone\u003C\/a\u003E","retweeted":false,"in_reply_to_screen_name":null,"coordinates":null,"in_reply_to_user_id":null,"user":{"contributors_enabled":false,"geo_enabled":false,"profile_sidebar_fill_color":"DDEEF6","lang":"en","listed_count":0,"created_at":"Sat Apr 11 17:12:45 +0000 2009","profile_sidebar_border_color":"C0DEED","is_translator":false,"show_all_inline_media":true,"follow_request_sent":null,"verified":false,"url":null,"description":"Ibiza 2012 for openings! Have a bang on that!","default_profile":true,"following":null,"profile_use_background_image":true,"time_zone":null,"profile_text_color":"333333","statuses_count":2513,"notifications":null,"profile_background_image_url_https":"https:\/\/si0.twimg.com\/images\/themes\/theme1\/bg.png","profile_background_image_url":"http:\/\/a0.twimg.com\/images\/themes\/theme1\/bg.png","location":"London","profile_link_color":"0084B4","followers_count":350,"protected":false,"profile_image_url_https":"https:\/\/si0.twimg.com\/profile_images\/1895048740\/image_normal.jpg","profile_image_url":"http:\/\/a0.twimg.com\/profile_images\/1895048740\/image_normal.jpg","default_profile_image":false,"screen_name":"wyatt69","name":"Dean Wyatt","favourites_count":0,"profile_background_color":"C0DEED","id":30482455,"id_str":"30482455","profile_background_tile":false,"utc_offset":null,"friends_count":384},"id":179948698397196288,"id_str":"179948698397196288","contributors":null} d":false,"profile_image_url_https":"https:\/\/si0.twimg.com\/profile_images\/1673331511\/logo-for-twitter_normal.png","profile_image_url":"http:\/\/a0.twimg.com\/profile_images\/1673331511\/logo-for-twitter_normal.png","default_profile_image":false,"screen_name":"itwitex","name":"itwitex","favourites_count":0,"profile_background_color":"EBEBEB","id":307251688,"id_str":"307251688","profile_background_tile":false,"utc_offset":3600,"friends_count":0},"id":179948696308432896,"possibly_sensitive_editable":true,"possibly_sensitive":false,"id_str":"179948696308432896","contributors":null} </code></p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload