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?

I'd use Regex or JSON libs for that one. Seems like the best bet. — NoGall
– NoGall, Commented Jul 12, 2013 at 14:44
looks like JSON stackoverflow.com/questions/6620165/how-to-parse-json-in-c — gheese
– gheese, Commented Jul 12, 2013 at 14:45

Nimantha · Accepted Answer · 2023-11-11 17:05:30Z

182

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);

edited Nov 11, 2023 at 17:05

Nimantha

6,5276 gold badges32 silver badges78 bronze badges

answered Jul 12, 2013 at 14:48

Rubens Mariuzzo

29.4k28 gold badges124 silver badges149 bronze badges

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

7 Comments

Alon Shmiel Over a year ago

thank you.. I used: dynamic data = JsonConvert.DeserializeObject(elements[0].Text);

Callum Over a year ago

This is all good but until you have a dynamic string you need to get from the json. eg Users.{ID}.Username

Callum Over a year ago

EDIT: found a way using this method:- String username = data["Users"]["" + User]["Username"];

J86 Over a year ago

Love the dynamic usage here! +1

LordCommanDev Over a year ago

If I try to return a property(for example result) from the dynamic objetc, returns null :s

|

Oli4 · Accepted Answer · 2019-10-10 10:13:45Z

31

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"}

edited Oct 10, 2019 at 10:13

Oli4

4991 gold badge9 silver badges24 bronze badges

answered Aug 2, 2016 at 7:46

Muhammad Awais

4,5121 gold badge47 silver badges38 bronze badges

Comments

Stefan · Accepted Answer · 2022-08-28 08:42:22Z

29

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");

edited Aug 28, 2022 at 8:42

answered Dec 16, 2021 at 6:26

Stefan

17.7k11 gold badges65 silver badges86 bronze badges

Comments

Loofer · Accepted Answer · 2019-06-21 11:21:46Z

24

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, 2019 at 11:21

Loofer

7,0239 gold badges67 silver badges107 bronze badges

answered Mar 20, 2019 at 11:11

DKR

5,8162 gold badges22 silver badges21 bronze badges

1 Comment

Stefan Over a year ago

I think your string is not a string ;-)

Sam · Accepted Answer · 2015-06-10 17:47:16Z

10

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, 2015 at 17:47

Sam

7,41616 gold badges48 silver badges68 bronze badges

answered Jul 12, 2013 at 14:51

Ligabb

1266 bronze badges

3 Comments

Rubens Mariuzzo Over a year ago

Json.NET is far better than DataContractJsonSerializer. See the feature comparison table: json.codeplex.com

Sam Over a year ago

And ServiceStack.Text is far better than JSON.Net.

wcm Over a year ago

I like Json.NET but this is a good answer that doesn't introduce a lot of external code and it easy to understand.

Rubens Mariuzzo · Accepted Answer · 2023-04-07 03:06:16Z

3

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);

answered Apr 7, 2023 at 3:06

Rubens Mariuzzo

29.4k28 gold badges124 silver badges149 bronze badges

1 Comment

Praveen Nayak Over a year ago

once we get into the world of arrays and linq processing, concrete types are just easier to get our head around, thanks.

Pooja Parmar · Accepted Answer · 2024-05-01 10:44:13Z

3

This code is working for us:

string json = "{\"subjectId\":\"d7aa0fdf-df51-4ef7-ad0b-9ace314b5ppb\"}";
dynamic data = JObject.Parse(json);
string userId = data["subjectId"];

answered May 1, 2024 at 10:44

Pooja Parmar

1333 silver badges14 bronze badges

Collectives™ on Stack Overflow

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

7 Answers 7

7 Comments

Comments

Comments

1 Comment

3 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

7 Comments

Comments

Comments

1 Comment

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related