Deserialize json string to object in c# in Key value pair (Comma separated values)

Question

I have below json in string as parameter to a WebMethod.

How can I deserialize in such a way that value comes in Key value pair.

Json String Parameter:

["Ref No,0","Date,0","Amt,0","Sender Name,0","Sender Add,0","Beneficiary Name,0","Beneficiary Add,0","Phone,0","Secret Code,0","Secret Ans,0","Preferred Id,0"]

WebMethod:

[System.Web.Services.WebMethod]
public static string SaveMappings(string mappingData)
{
    //string str = "{\"Arg1\":\"Arg1Value\",\"Arg2\":\"Arg2Value\"}";
    //JavaScriptSerializer serializer = new JavaScriptSerializer();
    //object obj;
    //var data = serializer.Deserialize(mappingData,);

    var data = mappingData.ToArray();
    if (data != null)
    {

    }

    var d2 = mappingData.Split(',');
    if (d2!=null)
    {

    }

    return mappingData;
}

Si8 · Accepted Answer · 2017-07-11 19:02:07Z

1

If you need to work with JSON data then use Newtonsoft.JSON library. Convert the object to an array of strings and then split every line. With this approach you can be sure that the given string is actually an JSON array and it is correct.

    var str = "[\"Ref No,0\",\"Date,0\",\"Amt,0\",\"Sender Name,0\",\"Sender Add,0\",\"Beneficiary Name,0\",\"Beneficiary Add,0\",\"Phone,0\",\"Secret Code,0\",\"Secret Ans,0\",\"Preferred Id,0\"]";

    string[] objs = JsonConvert.DeserializeObject<string[]>(str);

    Dictionary<string, string> dic = new Dictionary<string, string>();

    foreach (var obj in objs)
    {
        var keyValue = obj.Split(',');
        dic.Add(keyValue[0], keyValue[1]);
    }

    foreach (var record in dic)
    {
        Console.WriteLine("{0} => {1}", record.Key, record.Value);
    }

Or this one using LINQ. It looks better and it can be written faster. However, it is less optimal (two calls of Split instead of one).

    public Dictionary<string, string> FromJsonArray(string jsonArray)
    {
        return JsonConvert.DeserializeObject<string[]>(jsonArray)
            .ToDictionary(obj => obj.Split(',')[0], obj => obj.Split(',')[1]);
    }

    // ...

    var str = "[\"Ref No,0\",\"Date,0\",\"Amt,0\",\"Sender Name,0\",\"Sender Add,0\",\"Beneficiary Name,0\",\"Beneficiary Add,0\",\"Phone,0\",\"Secret Code,0\",\"Secret Ans,0\",\"Preferred Id,0\"]";

    foreach (var record in FromJsonArray(str))
    {
        Console.WriteLine("{0} => {1}", record.Key, record.Value);
    }

edited Jul 11, 2017 at 19:02

Si8

9,25522 gold badges120 silver badges223 bronze badges

answered May 28, 2015 at 6:03

Yeldar Kurmangaliyev

34.4k13 gold badges64 silver badges104 bronze badges

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

1 Comment

Gaurav123 Over a year ago

I used string[] objs = serializer.Deserialize<string[]>(mappingData); and it worked for me. Which assembly I need to include in using namespace JsonConvert ?

Hussein Khalil · Accepted Answer · 2015-05-28 05:40:47Z

0

why don't you just change every ',' in the string array to ':' then pass it to the method, from what you wrote in the question, this should work

answered May 28, 2015 at 5:40

Hussein Khalil

1,40111 silver badges29 bronze badges

Collectives™ on Stack Overflow

Deserialize json string to object in c# in Key value pair (Comma separated values)

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related