Fetch value from json

Ankit Shukla

9y1kC#

Hello;

We have a json file like as:

{

"records": [

{

"status": null,

"version": 1,

"id": "89fc25ea-721b-42ca-9ff1-756a7d386dd8",

"created_at": "2017-02-15T04:29:23Z",

"updated_at": "2017-02-15T04:29:23Z",

"client_created_at": "2017-02-15T04:24:44Z",

"client_updated_at": "2017-02-15T04:29:08Z",

"created_by": "Graham Patterson",

"created_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f",

"updated_by": "Graham Patterson",

}]}

Please tell me how to fetch value of "created_by"?

Thank you in advance.

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
Accepted answer
Try following:
dynamic col = JsonConvert.DeserializeObject(jsonString);
Then
Strin value = col.records[0].form_values.e7ba;
Nitin Sontakke9y ago
I suspected that right when I first saw the full json you posted.

Trouble is C# will not allow a property starting with number because it is illegal in C# sytax. Honestly, I don't know the answer.

I even don't know how a dynamic object gets successfully created.

May be you just google, which is what I will be doing anyway...
Ankit Shukla9y ago
Hello Sir,

I need some more help.

dynamic col = JsonConvert.DeserializeObject(text);
String Project = col.records[0].form_values.5576;

I am facing error cause their is numeric value "5576". What can I do?
Ankit Shukla9y ago
Thank you Sir. You rocks.
Ankit Shukla9y ago
I did not understand sir. I already mention class code there, which is provided by you.

I explain again. Actually my json file path is "https://web.fulcrumapp.com/shares/411d99df8a5ad72d.json". Please check this link.

I need value of "7705", "e7ba" etc and want to bind in datagid. Thanks for continuously helping me.
Ankit Shukla9y ago
Dear Sir, I need data: records > form_values > e7ba.

Value of e3ba is "Structure number". "e3ba "is inside "form_values" and "form_values" is inside "records".
Nitin Sontakke9y ago
What is important is the class definition. Please share the classes code.
Ankit Shukla9y ago
Sir, I tried your code. But I get null value. Although there is a value "Structure number". May be their is some problem to fetch data which is nested. Please help. and Thanks for your valuable time.

public Form1()
{
InitializeComponent();
// MessageBox.Show("hello");
Task.Run(() => GetContact()).Wait();
}
public class Records
{
public records[] records { get; set; }
}
public class records
{
public String status { get; set; }
public Int32 version { get; set; }
public Guid id { get; set; }
public String created_by { get; set; }
public DateTime updated_at { get; set; }
public DateTime client_created_at { get; set; }
public DateTime client_updated_at { get; set; }
public String e7ba { get; set; }
public Guid created_by_id { get; set; }
public String updated_by { get; set; }
}
private async Task GetContact()
{
HttpClient client = new HttpClient();
var requestData = new HttpRequestMessage(HttpMethod.Get, new Uri("https://web.fulcrumapp.com/shares/411d99df8a5ad72d.json"));
var response = await client.SendAsync(requestData);
string text = await response.Content.ReadAsStringAsync();
JObject joResponse = JObject.Parse(text);
JArray array = (JArray)joResponse["records"];
string id = array[0].ToString();
var data = (JObject)JsonConvert.DeserializeObject(id);
string timeZone = data["created_by"].Value();
Records col = JsonConvert.DeserializeObject(text);
string a2 = col.records[0].created_by;----------------------------------Get Value
string a1 = col.records[0].e7ba;---------------------------------------------get NULL
// var obj = JObject.Parse(text);
// var url = (string)obj["records"]["form_values"]["7705"];
// var url = (string)joResponse.SelectToken("records.form_values");
dtEvents = new DataTable();
foreach (JObject content in array.Children())
{
foreach (JProperty prop in content.Properties())
{
dtEvents.Columns.Add(prop.Name.ToString());
}
break;
}
int index = 0;
foreach (JObject content in array.Children())
{
dtEvents.Rows.Add();
foreach (JProperty prop in content.Properties())
{
dtEvents.Rows[index][prop.Name.ToString()] = prop.Value.ToString();
}
index++;
}
dataGridView1.DataSource = dtEvents;

}
Nitin Sontakke9y ago
If you have seen what I have done, could you not continue on the same lines?

Give it a shot. Then share your classes if you continue to face issues. It is very simple, if you see closely.
Ankit Shukla9y ago
Thank you Nitin Sir for your valuable reply. I need more help. My json data is like this:

"records": [
{
"status": null,
"version": 1,
"id": "89fc25ea-721b-42ca-9ff1-756a7d386dd8",
"created_at": "2017-02-15T04:29:23Z",
"updated_at": "2017-02-15T04:29:23Z",
"client_created_at": "2017-02-15T04:24:44Z",
"client_updated_at": "2017-02-15T04:29:08Z",
"created_by": "Graham Patterson",
"created_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f",
"updated_by": "Graham Patterson",
"updated_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f",
"created_location": null,
"updated_location": null,
"created_duration": 264,
"updated_duration": 264,
"edited_duration": 264,
"form_id": "a8ac8685-21d4-4e72-9ecc-705254fb3f80",
"project_id": null,
"assigned_to": null,
"assigned_to_id": null,
"form_values": {
"6963": {
"other_values": [],
"choice_values": [
"Fine",
"Hot",
"Sunny"
]
},
"7705": "Xyz",
"e7ba": "Structure number",
"c353": "Name of line\n",
"576f": [
{
"id": "4d7acf29-c342-4c2c-95d9-ea3c57efa10f",
"created_at": "1487132878",
"form_values": {
"3962": "Issue 1",
"bd46": [
{
"caption": null,
"photo_id": "3d68109b-fd3f-4d77-9634-a872daca87b7"
}
]
},
"geometry": null,
"created_duration": 18,
"updated_at": "1487132896",
"updated_duration": 18,
"edited_duration": 18,
"version": 1,
"created_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f",
"updated_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f",
"changeset_id": "6a0ac5b9-0063-4993-a0eb-0ea448b232bf"
},
{
"id": "49541964-4a2e-414b-bcd9-76863004ee59",
"created_at": "1487132899",
"form_values": {
"3962": "Issue 2",
"bd46": [
{
"caption": null,
"photo_id": "1d1434c7-6795-47f7-aa98-33fb550dcaa7"
}
]
},
"geometry": null,
"created_duration": 13,
"updated_at": "1487132912",
"updated_duration": 13,
"edited_duration": 13,
"version": 1,
"created_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f",
"updated_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f",
"changeset_id": "6a0ac5b9-0063-4993-a0eb-0ea448b232bf"
}
],
"cf63": [
{
"created_location": {
"latitude": -27.2264784317734,
"longitude": 152.984398535856,
"altitude": 26,
"horizontal_accuracy": 65
},
"id": "8a3a27c5-69d0-4017-85b6-1e52aefc2717",
"created_at": "1487132922",
"form_values": {
"794f": {
"other_values": [],
"choice_values": [
"U71-776"
]
}
},
"geometry": {
"type": "Point",
"coordinates": [
152.984398535856,
-27.2264784317734
]
},
"updated_location": {
"latitude": -27.2264784317734,
"longitude": 152.984398535856,
"altitude": 26,
"horizontal_accuracy": 65
},
"created_duration": 6,
"updated_at": "1487132929",
"updated_duration": 6,
"edited_duration": 6,
"version": 1,
"created_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f",
"updated_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f",
"changeset_id": "6a0ac5b9-0063-4993-a0eb-0ea448b232bf"
},
{
"created_location": {
"latitude": -27.2264784317734,
"longitude": 152.984398535856,
"altitude": 26,
"horizontal_accuracy": 65
},
"id": "6bc31253-1512-415c-94d4-d243f42b0d29",
"created_at": "1487132937",
"form_values": {
"794f": {
"other_values": [],
"choice_values": [
"680-SZJ"
]
}
},
"geometry": {
"type": "Point",
"coordinates": [
152.984398535856,
-27.2264784317734
]
},
"updated_location": {
"latitude": -27.2264784317734,
"longitude": 152.984398535856,
"altitude": 26,
"horizontal_accuracy": 65
},
"created_duration": 5,
"updated_at": "1487132942",
"updated_duration": 5,
"edited_duration": 5,
"version": 1,
"created_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f",
"updated_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f",
"changeset_id": "6a0ac5b9-0063-4993-a0eb-0ea448b232bf"
}
],
"5dd8": "10:29",
"d0c9": {
"other_values": [],
"choice_values": [
"Back to base Training - 12003"
]
},
"e17c": "Work completed today",
"7f8a": {
"other_values": [],
"choice_values": [
"Staff"
]
},
"f3af": "2017-02-15",
"06ab": [
{
"id": "7e4e4b66-1256-46e1-8f2b-b5afa339e6f9",
"created_at": "1487132693",
"form_values": {
"2533": "14:24",
"34f7": "yes",
"96d2": {
"other_values": [],
"choice_values": [
"112.78"
]
},
"719c": {
"other_values": [],
"choice_values": [
"Gerald Clifton"
]
},
"54b0": "14:24"
},
"geometry": null,
"created_duration": 11,
"updated_at": "1487132705",
"updated_duration": 11,
"edited_duration": 11,
"version": 1,
"created_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f",
"updated_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f",
"changeset_id": "6a0ac5b9-0063-4993-a0eb-0ea448b232bf"
},
{
"id": "77d5fc68-0929-4ab0-97fa-2cdd0f24e015",
"created_at": "1487132706",
"form_values": {
"2533": "14:25",
"34f7": "no",
"96d2": {
"other_values": [],
"choice_values": [
"112.78"
]
},
"719c": {
"other_values": [],
"choice_values": [
"Maxinr Rhind"
]
},
"54b0": "08:25"
},
"geometry": null,
"created_duration": 22,
"updated_at": "1487132728",
"updated_duration": 22,
"edited_duration": 22,
"version": 1,
"created_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f",
"updated_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f",
"changeset_id": "6a0ac5b9-0063-4993-a0eb-0ea448b232bf"
}
],
"bf00": "14:27",
"dd43": "Bus was late"
},
"latitude": null,
"longitude": null,
"altitude": null,
"speed": null,
"course": null,
"horizontal_accuracy": null,
"vertical_accuracy": null
}
]
}

I need value of 7705 and 6963 . which are highlighted by red color. I am facing problem coz these are nested. And Yes , I need c# code coz this is a part of windows application.
Nitin Sontakke9y ago
Assuming yes, here is the code...
String jsonString = "{\"records\": [{\"status\": null,\"version\": 1,\"id\": \"89fc25ea-721b-42ca-9ff1-756a7d386dd8\",\"created_at\": \"2017-02-15T04:29:23Z\",\"updated_at\": \"2017-02-15T04:29:23Z\",\"client_created_at\": \"2017-02-15T04:24:44Z\", \"client_updated_at\": \"2017-02-15T04:29:08Z\", \"created_by\": \"Graham Patterson\", \"created_by_id\": \"571fdc4a-28ee-4fd8-8c2d-7d6758f3910f\", \"updated_by\": \"Graham Patterson\",}]} ";
Records col = JsonConvert.DeserializeObject(jsonString);
And here are associated classes:
public class Records
{
  public records[] records { get; set; }
}

public class records
{
  public String status { get; set; }
  public Int32 version { get; set; }
  public Guid id { get; set; }
  public DateTime created_at { get; set; }
  public DateTime updated_at { get; set; }
  public DateTime client_created_at { get; set; }
  public DateTime client_updated_at { get; set; }
  public String created_by { get; set; }
  public Guid created_by_id { get; set; }
  public String updated_by { get; set; }
}
And then you can just...
col.records[0].created_by
Nitin Sontakke9y ago
It definitely helps if you explicitly mention in which environment you are doing this? Should I just assume C#?