How to Convert a string received from dynamics CRM to Dictionary in C#

Question

I'm dynamics CRM developer an I'm writing a codeactivity where I'm receiving field value in format like:

[{"name":"Sherlock","id":"a10ef25"}]

I want to convert this value to dictionary format. I'm thinking of using ToDictionary() method after removing the [] from the value by converting it to string like this:

{"name":"Sherlock","exid":"a10ef25"}

I need the value of Key which contains "id" but the number of pairs in the string can be more than 2 also some times like:

{"name":"Sherlock","id":"a10ef25","date":"25062019"}.

var value=[{"name":"Sherlock","id":"a10ef25"}]; // i'm receiving it from crm & converting to string
var dict=value.Substring(1.value.Length-1);

I'm unable to go forward than this. can anyone help?

Does this answer your question? [How can I parse JSON with C#?](https://stackoverflow.com/questions/6620165/how-can-i-parse-json-with-c) — Selvin, Jul 09 '20 at 11:53

Guru Stron · Answer 1 · 2020-07-09T11:41:27.553

This looks pretty much as json, so you can try just deserialize it to a collection of Dictionary<string, string>. With Newtonsoft Json.NET it will look like this:

string value = "[{\"name\":\"Sherlock\",\"id\":\"a10ef25\"}]"; // the original value, no need to trim/remove
var collectionOfDicts = JsonConvert.DeserializeObject<List<Dictionary<string,string>>>(value);

To get the key which contains id you can manipulate the collection, for example like this:

var id = collectionOfDicts
    .FirstOrDefault()
    ?.Where(kvp => kvp.Key.Contains("id", StringComparison.InvariantCultureIgnoreCase))
    .Select(kvp => kvp.Value)
    .FirstOrDefault();

UPD

Another option would be using LINQ to JSON from the same library:

var id = JArray.Parse(value)
    .Descendants()
    .OfType<JProperty>()
    .FirstOrDefault(p => p.Name.Contains("id", StringComparison.InvariantCultureIgnoreCase))
    ?.Value

So very close. You probably need to test this before posting. — Enigmativity, Jul 09 '20 at 10:47
@Enigmativity was editing the question - originally the string was inline. — Guru Stron, Jul 09 '20 at 10:49

Roman Marusyk · Accepted Answer · 2020-07-10T06:59:32.410

1

One more solution

var value ="[{ \"name\":\"Sherlock\",\"id\":\"a10ef25\"}]".TrimStart('[').TrimEnd(']');
var dict = JsonConvert.DeserializeObject<Dictionary<string, string>>(value);
var id = dict["id"]; // or dict.TryGetValue("id", out string id);

edited Jul 10 '20 at 06:59

answered Jul 09 '20 at 10:36

Roman Marusyk

23,328
24
73
116

Alaa Mohammed · Answer 3 · 2020-07-09T10:53:02.460

0

This is JSON format Use Json Converter

 var value= @"{""name"":""Sherlock"",""id"":""a10ef25"",""date"":""25062019""}";
           
var dict= JsonConvert.DeserializeObject<Dictionary<string, string>>(value);

edited Jul 09 '20 at 10:53

answered Jul 09 '20 at 10:32

Alaa Mohammed

382
2
14

2

It will not work) the root object is array of object – Guru Stron Jul 09 '20 at 10:34
copy and paste an example please – Alaa Mohammed Jul 09 '20 at 10:35
Copy-pasted. It will not even compile. – Guru Stron Jul 09 '20 at 10:37
Still will not compile. – Guru Stron Jul 09 '20 at 10:38
i can see you edited your question. so you want only the value of the Id ? – Alaa Mohammed Jul 09 '20 at 10:39
It is not my question. – Guru Stron Jul 09 '20 at 10:39
@KrushnaKumar can there be multiple keys with id? – Guru Stron Jul 09 '20 at 10:46
instead of dictionary you can use List for example ? – Alaa Mohammed Jul 09 '20 at 10:46
@AlaaMohammed - Did you test this before posting? – Enigmativity Jul 09 '20 at 10:47
no only one key which includes the string id. i mean the it was coming like extid sometimes or as projectid sometimes but only one key will contain "id" word. – Krushna Kumar Jul 09 '20 at 10:49
@Enigmativity yes i edited and i tested it . its working – Alaa Mohammed Jul 09 '20 at 10:53
+ [0] {[name, Sherlock]} + [1] {[id, a10ef25]} + [2] {[date, 25062019]} – Alaa Mohammed Jul 09 '20 at 10:54

How to Convert a string received from dynamics CRM to Dictionary in C#

3 Answers3