Parse json string to find and element (key / value)

Question

I have following json in a file timezones.json:

  { "Atlantic/Canary": "GMT Standard Time", "Europe/Lisbon": "GMT Standard Time", 
"Antarctica/Mawson": "West Asia Standard Time", "Etc/GMT+3": "SA Eastern Standard Time", 
"Etc/GMT+2": "UTC-02", "Etc/GMT+1": "Cape Verde Standard Time", "Etc/GMT+7": "US Mountain 
Standard Time", "Etc/GMT+6": "Central America Standard Time", "Etc/GMT+5": "SA Pacific 
Standard Time", "Etc/GMT+4": "SA Western Standard Time", "Pacific/Wallis": "UTC+12", 
"Europe/Skopje": "Central European Standard Time", "America/Coral_Harbour": "SA Pacific 
Standard Time", "Asia/Dhaka": "Bangladesh Standard Time", "America/St_Lucia": "SA Western 
Standard Time", "Asia/Kashgar": "China Standard Time", "America/Phoenix": "US Mountain 
Standard Time", "Asia/Kuwait": "Arab Standard Time" }

I want to search for a particular key e.g. "Atlantic/Canary" from it and as a result want its value back i.e. "GMT Standard Time".

How can I do this using Json.Net or any other efficient mean in C#?

Look here, https://stackoverflow.com/questions/9010021/get-value-from-json-with-json-net — Jsperk, Feb 16 '19 at 17:01

score 75 · Accepted Answer · answered Feb 10 '14 at 13:24

Use a JSON parser, like JSON.NET

string json = "{ \"Atlantic/Canary\": \"GMT Standard Time\", \"Europe/Lisbon\": \"GMT Standard Time\", \"Antarctica/Mawson\": \"West Asia Standard Time\", \"Etc/GMT+3\": \"SA Eastern Standard Time\", \"Etc/GMT+2\": \"UTC-02\", \"Etc/GMT+1\": \"Cape Verde Standard Time\", \"Etc/GMT+7\": \"US Mountain Standard Time\", \"Etc/GMT+6\": \"Central America Standard Time\", \"Etc/GMT+5\": \"SA Pacific Standard Time\", \"Etc/GMT+4\": \"SA Western Standard Time\", \"Pacific/Wallis\": \"UTC+12\", \"Europe/Skopje\": \"Central European Standard Time\", \"America/Coral_Harbour\": \"SA Pacific Standard Time\", \"Asia/Dhaka\": \"Bangladesh Standard Time\", \"America/St_Lucia\": \"SA Western Standard Time\", \"Asia/Kashgar\": \"China Standard Time\", \"America/Phoenix\": \"US Mountain Standard Time\", \"Asia/Kuwait\": \"Arab Standard Time\" }";
var data = (JObject)JsonConvert.DeserializeObject(json);
string timeZone = data["Atlantic/Canary"].Value<string>();

It's not really efficient if the json is very long and you need just one key of it — Loreno, Aug 30 '18 at 09:09

score 47 · Answer 2 · answered Feb 10 '14 at 13:25

47

You want to convert it to an object first and then access normally making sure to cast it.

JObject obj = JObject.Parse(json);
string name = (string) obj["Name"];

answered Feb 10 '14 at 13:25

shmyq

562
3
6

what if there are many "Name" on the Json? – alansiqueira27 Mar 28 '19 at 18:16
7

@alansiqueira27 Then it's not JSON. Keys have to be unique – Kurtis Streutker Apr 20 '19 at 15:49
1

I think he may mean a array of JSON objects, which would then have multiple names – Thomas Clague Aug 19 '19 at 20:40
Can you add the full "using" statements and/or package-references? – granadaCoder Jul 01 '20 at 16:24

Parse json string to find and element (key / value)

2 Answers2

Linked