How to get some values from a JSON string in C#?

Question

I have a string and I want to get some values from it.

My strings seem like:

string1:

"{\r\n   \"id\": \"100000280905615\",
 \r\n \"name\": \"Jerard Jones\",
 \r\n   \"first_name\": \"Jerard\",
 \r\n   \"last_name\": \"Jones\",
 \r\n   \"link\": \"https://www.facebook.com/Jerard.Jones\",
 \r\n   \"username\": \"Jerard.Jones\",
 \r\n   \"gender\": \"female\",
 \r\n   \"locale\": \"en_US\"\r\n}"

string2:

"{\r\n   \"id\": \"100000390001929\",
  \r\n   \"name\": \"\\u05d1\\u05d2\\u05e8\\u15dc\\u25d9 \\u05d1\\u05e8\\u05d5\\u05e9\",
  \r\n   \"first_name\": \"\\u05d4\\u05d2\\u05e7\\u02dc\\u05d9\",
  \r\n   \"last_name\": \"\\u05d1\\u05e8\\u05d5\\u05e9\",
  \r\n   \"link\": "https://www.facebook.com/people/\\u05d2\\u05d1\\u05e@\\u05dc\\u05d9-\\u05d1\\u05e8\\u05d4\\u05e9/100000390001929\",
  \r\n   \"gender\": \"female\",
  \r\n   \"locale\": \"he_IL\"\r\n}"

Unfortunately, there is a situation that a string will be by the same concept, but without some parameters:

string3:

"{\r\n   \"id\": \"100000390001929\",
  \r\n   \"last_name\": \"\\u05d1\\u05e8\\u05d5\\u05e9\",
  \r\n   \"gender\": \"female\",
  \r\n   \"locale\": \"he_IL\"\r\n}"

How can I get the values of: id, first_name, last_name, gender, locale?

Any help appreciated!

Looks like you need a [JSON parser](https://www.google.co.uk/search?q=c%23+parse+json). — Rawling, Jul 12 '13 at 14:43
I'd use Regex or JSON libs for that one. Seems like the best bet. — laminatefish, Jul 12 '13 at 14:44
looks like JSON http://stackoverflow.com/questions/6620165/how-to-parse-json-in-c — gheese, Jul 12 '13 at 14:45
See: [Deserializing JSON string into dynamic object](http://stackoverflow.com/a/8972079/439427) — Rubens Mariuzzo, Jul 12 '13 at 14:54
Possible duplicate of [Deserialize json object into dynamic object using Json.net](http://stackoverflow.com/questions/4535840/deserialize-json-object-into-dynamic-object-using-json-net) — Michael Freidgeim, Jul 11 '16 at 01:53
Possible duplicate of [How can I parse JSON with C#?](https://stackoverflow.com/questions/6620165/how-can-i-parse-json-with-c) — Heretic Monkey, Jun 24 '18 at 16:30

Rubens Mariuzzo · Accepted Answer · 2018-04-25T14:29:26.023

168

Your strings are JSON formatted, so you will need to parse it into a object. For that you can use JSON.NET.

Here is an example on how to parse a JSON string into a dynamic object:

string source = "{\r\n   \"id\": \"100000280905615\", \r\n \"name\": \"Jerard Jones\",  \r\n   \"first_name\": \"Jerard\", \r\n   \"last_name\": \"Jones\", \r\n   \"link\": \"https://www.facebook.com/Jerard.Jones\", \r\n   \"username\": \"Jerard.Jones\", \r\n   \"gender\": \"female\", \r\n   \"locale\": \"en_US\"\r\n}";
dynamic data = JObject.Parse(source);
Console.WriteLine(data.id);
Console.WriteLine(data.first_name);
Console.WriteLine(data.last_name);
Console.WriteLine(data.gender);
Console.WriteLine(data.locale);

Happy coding!

edited Apr 25 '18 at 14:29

answered Jul 12 '13 at 14:48

Rubens Mariuzzo

28,358
27
121
148

9

thank you.. I used: dynamic data = JsonConvert.DeserializeObject(elements[0].Text); – Alon Shmiel Jul 13 '13 at 15:53
1

This is all good but until you have a dynamic string you need to get from the json. eg Users.{ID}.Username – Callum Feb 28 '15 at 01:23
2

EDIT: found a way using this method:- String username = data["Users"]["" + User]["Username"]; – Callum Feb 28 '15 at 01:41
1

Love the `dynamic` usage here! +1 – J86 Jan 02 '18 at 12:08
2

If I try to return a property(for example result) from the dynamic objetc, returns null :s – LordCommanDev May 18 '18 at 02:14
using Newtonsoft.Json.Linq; – Alex Abreu Mulet Oct 21 '21 at 20:35
Thanks... In my case, it wasn't working, returning NULL, so I continued with: ``` var parsedData = JObject.Parse(payload); var elementId = parsedData["entity"]["element"].ToString(); ``` – Rahim Jan 03 '23 at 15:03

score 27 · Answer 2 · edited Oct 10 '19 at 10:13

Following code is working for me.

Usings:

using System.IO;
using System.Net;
using Newtonsoft.Json.Linq;

Code:

 using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
                {
                    using (Stream responseStream = response.GetResponseStream())
                    {
                        using (StreamReader responseReader = new StreamReader(responseStream))
                        {
                            string json = responseReader.ReadToEnd();
                            string data = JObject.Parse(json)["id"].ToString();
                        }
                    }
                }

//json = {"kind": "ALL", "id": "1221455", "longUrl": "NewURL"}

score 22 · Answer 3 · edited Jun 21 '19 at 11:21

22

my string

var obj = {"Status":0,"Data":{"guid":"","invitationGuid":"","entityGuid":"387E22AD69-4910-430C-AC16-8044EE4A6B24443545DD"},"Extension":null}

Following code to get guid:

var userObj = JObject.Parse(obj);
var userGuid = Convert.ToString(userObj["Data"]["guid"]);

edited Jun 21 '19 at 11:21

Loofer

6,841
9
61
102

answered Mar 20 '19 at 11:11

DKR

5,426
1
19
21

I think your string is not a string ;-) – Stefan Dec 16 '21 at 06:27

Stefan · Answer 4 · 2022-08-28T08:42:22.443

A .NET 6 version using System.Text.Json

using System;
                    
public class Program
{
    public static void Main()
    {
        var jsonString = @"{ ""id"" : 123 }";
        
        //parse it
        var yourObject = System.Text.Json.JsonDocument.Parse(jsonString);
        //retrieve the value
        var id= yourObject.RootElement
                          .GetProperty("id");
        
        Console.WriteLine(id);
    }
}

To retrieve nested properties, you can chain the GetProperty calls. As a more advanced example:

//access first element of array "persons" get nested property "age" 
var age = yourObject.rootElement.GetProperty("persons")[0]
                                .GetProperty("age");

this should be top answer – MistaGoustan Jan 26 '22 at 17:05 — MistaGoustan, Jan 26 '22 at 17:05

score 9 · Answer 5 · edited Jun 10 '15 at 17:47

9

Create a class like this:

public class Data
{
    public string Id {get; set;}
    public string Name {get; set;}
    public string First_Name {get; set;}
    public string Last_Name {get; set;}
    public string Username {get; set;}
    public string Gender {get; set;}
    public string Locale {get; set;}
}

(I'm not 100% sure, but if that doesn't work you'll need use [DataContract] and [DataMember] for DataContractJsonSerializer.)

Then create JSonSerializer:

private static readonly XmlObjectSerializer Serializer = new DataContractJsonSerializer(typeof(Data));

and deserialize object:

// convert string to stream
byte[] byteArray = Encoding.UTF8.GetBytes(contents);
using(var stream = new MemoryStream(byteArray))
{
    (Data)Serializer.ReadObject(stream);
}

edited Jun 10 '15 at 17:47

Sam

7,252
16
46
65

answered Jul 12 '13 at 14:51

Ligabb

116
5

7

Json.NET is far better than DataContractJsonSerializer. See the feature comparison table: http://json.codeplex.com/ – Rubens Mariuzzo Jul 12 '13 at 15:03
And ServiceStack.Text is far better than JSON.Net. – Sam Jun 10 '15 at 17:39
3

I like Json.NET but this is a good answer that doesn't introduce a lot of external code and it easy to understand. – wcm Jun 06 '17 at 12:42

score 0 · Answer 6 · answered Apr 07 '23 at 03:06

You can also use this alternative specifying the expected type:

using Newtonsoft.Json;

class Person {
    public string Name { get; set; }
    public int Age { get; set; }
}

string jsonString = "{\"name\": \"John\", \"age\": 30}";

Person person = JsonConvert.DeserializeObject<Person>(jsonString);

How to get some values from a JSON string in C#?

6 Answers6

Linked

Related