how to set the value of a json path using json.net

Question

I am trying to set an arbitrary path in a JSON structure and I am having difficulty figuring out how to do a simple set value...

What I would like is some method like, SetValue(path,value) which operates like SelectToken, but creates the path if it does not exist and sets the value.

public void SetPreference(string username, string path, string value)
{
    var prefs = GetPreferences(username);

    var jprefs = JObject.Parse(prefs ?? @"{}");

    var token = jprefs.SelectToken(path);

    if (token != null)
    {
        // how to set the value of the path?
    }
    else
       // how to add the path and value, example {"global.defaults.sort": { "true" }}
}

what I mean by global.defaults.sort path is actually { global: { defaults: { sort: { true } } } }

Timmerz · Accepted Answer · 2013-07-09 15:23:53Z

10

    public string SetPreference(string username, string path, string value)
    {
        if (!value.StartsWith("[") && !value.StartsWith("{"))
            value = string.Format("\"{0}\"", value);

        var val = JObject.Parse(string.Format("{{\"x\":{0}}}", value)).SelectToken("x");

        var prefs = GetPreferences(username);

        var jprefs = JObject.Parse(prefs ?? @"{}");

        var token = jprefs.SelectToken(path) as JValue;

        if (token == null)
        {
            dynamic jpart = jprefs;

            foreach (var part in path.Split('.'))
            {
                if (jpart[part] == null)
                    jpart.Add(new JProperty(part, new JObject()));

                jpart = jpart[part];
            }

            jpart.Replace(val);
        }
        else
            token.Replace(val);

        SetPreferences(username, jprefs.ToString());

        return jprefs.SelectToken(path).ToString();
    }

edited Jul 9, 2013 at 15:23

answered Jul 8, 2013 at 14:35

Timmerz

6,1795 gold badges38 silver badges50 bronze badges

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

2 Comments

Mahmoud Farahat Over a year ago

Thanks but it needs modification to handle JSON arrays , i'll post code sample when i finish it

Gordon Bean Over a year ago

So the answer is essentially: "Newtonsoft doesn't do it, but you can interpret the jsonpath yourself"

Collectives™ on Stack Overflow

how to set the value of a json path using json.net

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related