How can I get the specific value from json?

Question

0.00/5 (No votes)

See more:

I have a json model. In this model i want to get the name of each value in this json using c#. If you look to the picture, you will see what i want. Can you help me please?

What I have tried:

I have a json model. In this model i want to get the name of each value in this json using c#. If you look to the picture, you will see what i want. Can you help me please?

dynamic model = JsonConvert.DeserializeObject<string>(noteText);
var n= model.locations[0].name; //It gives me The 'string' does not contain a 'locations' definition error

Posted 12-Nov-20 3:40am

muharrem altun

Updated 12-Nov-20 10:37am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vincent Maverick Durano · Accepted Answer · 2020-11-12T10:37:00

You can also try using JObject and access the element via keys. For example:

C#

var data = JObject.Parse("Some Json String");
var elementValue = data["SomeProperty"];

Another approach is using JsonDocument. For example:

C#

var jsonDocument = JsonDocument.Parse("Some Json String");

var elementValue = jsonDocument.RootElement.GetProperty("SomeProperty").GetString();

var jsonElement = jsonDocument.RootElement.TryGetProperty("SomeProperty", out var targetElement);

if (!jsonElement)
{
  // Element not found
}

F-ES Sitecore · Accepted Answer · 2020-11-12T04:11:00

Solution 1

C#

string noteText = "{locations : [{name: \"loc1\"}, {name:\"loc2\"}]}";

// you're converting to dynamic so use that in the angled brackets, not string
dynamic model = JsonConvert.DeserializeObject<dynamic>(noteText);
var n = model.locations[0].name;

If it still doesn't work then check your code matches the shape of your json objects.

Posted 12-Nov-20 4:11am

F-ES Sitecore

v2

Comments

muharrem altun 13-Nov-20 0:41am

I tried you soulution but i got the error in this line: var n=model.locations[0].name;
The error message is : string 'does not contain a' location 'definition.
My json begins like this:
{ "locations": [ { "name": "accounts/103890250566243670362/locations/17566485131419324180", "storeCode": "006841020I01", "locationName": "İstikbal - ATAK TICARET", "primaryPhone": "(0312) 814 10 22", "primaryCategory": { "displayName": "Mobilya mağazası", "categoryId": "gcid:furniture_store" }, "websiteUrl": "http://www.istikbal.com.tr/", "regularHours": { "periods": [ { "openDay": "SUNDAY", "openTime": "09:00", "closeDay": "SUNDAY", "closeTime": "21:00" }, { "openDay": "MONDAY", "openTime": "09:00", "closeDay": "MONDAY", "closeTime": "21:00" }, { "openDay": "TUESDAY", "openTime": "09:00", "closeDay": "TUESDAY", "closeTime": "21:00" }, { "openDay": "WEDNESDAY", "openTime": "09:00", "closeDay": "WEDNESDAY", "closeTime": "21:00" }, { "openDay": "THURSDAY", "openTime": "09:00", "closeDay": "THURSDAY", "closeTime": "21:00" }, { "openDay": "FRIDAY", "openTime": "09:00", "closeDay": "FRIDAY", "closeTime": "21:00" }, { "openDay": "SATURDAY", "openTime": "09:00", "closeDay": "SATURDAY", "closeTime": "21:00" } ] }, "locationKey": { "placeId": "ChIJux7UUUVwgkAR4AuSDLY30hY", .....

muharrem altun 13-Nov-20 0:50am

Thank you. I found the solution with your approach.