C#, JSON.net Loop through and store Jobject objects

Question

New to both C# and to using JSON. Trying to make something that works with some JSON from a web API in the following format. Would like to loop through and store the secondUser_id and and the status for later use.

{
  "user_list": [
    {
      "user_id": "12345678910",
      "secondUser_id": "5428631729616515697",
      "member_since": "1521326679",
      "member_since_date": "2018-03-32",
      "function": "test",
      "rank_int": "1",
      "status": "0"
    },
    {
      "user_id": "11345638910",
      "secondUser_id": "5428631729616515697",
      "member_since": "1521326679",
      "member_since_date": "2018-03-32",
      "function": "test",
      "rank_int": "1",
      "status": "0"
    },
    {
      "user_id": "13452578910",
      "secondUser_id": "12390478910",
      "member_since": "12316578910",
      "member_since_date": "2018-03-32",
      "function": "test",
      "rank_int": "1",
      "status": "0"
    }
  ],
  "returned": 3
}
string jsonUrl = GetJSON("url");
JObject UsersJObject = JObject.Parse(jsonUrl);
JToken user = UsersJObject["user_list"].First["secondUser_id"];

Console.WriteLine("User ID: " + user);

This will get the first entry but I'm not sure what to use for a enumerator?

Consider deserializing

Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp

2018-03-23 01:11:57 +00:00
Commented Mar 23, 2018 at 1:11 — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Mar 23, 2018 at 1:11

jcwmoore · Accepted Answer · 2018-03-23 02:42:24Z

2

try something like this:

foreach (var obj in UsersJObject["user_list"] as JArray)
{
    Console.WriteLine(obj["secondUser_id"]);
}

You can iterate over elements of a JArray, and user_list will be of that type, cast it and you can iterate it in a foreach loop.

edited Mar 23, 2018 at 2:42

answered Mar 23, 2018 at 1:47

jcwmoore

1,1738 silver badges13 bronze badges

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

Comments

D-Shih · Accepted Answer · 2018-03-23 02:20:29Z

I will recommend you to use JsonConvert.DeserializeObject<T>.

This can help you to use objects easily

public class UserList
{
    public string user_id { get; set; }
    public string secondUser_id { get; set; }
    public string member_since { get; set; }
    public string member_since_date { get; set; }
    public string function { get; set; }
    public string rank_int { get; set; }
    public string status { get; set; }
}

public class JsonData
{
    public List<UserList> user_list { get; set; }
    public int returned { get; set; }
}

Use like this.

string jsonUrl = GetJSON("url");

JsonData UsersJObject = JsonConvert.DeserializeObject<JsonData>(jsonUrl);

foreach (var obj in UsersJObject.user_list)
{
    Console.WriteLine(obj.secondUser_id);
}

Collectives™ on Stack Overflow

C#, JSON.net Loop through and store Jobject objects

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related