Read JSON

Question

Hi,

I'm starting to develop a SOE that take this JSON

{
 "INSERT":[
     {
           "url":"C:\Users\pasq4\Documents\where_tech\TELECOM\PRO\SDK.gdb\test_1_1",
          "ids":[4,6]
     },
    {
           "url":"C:\Users\pasq4\Documents\where_tech\TELECOM\PRO\SDK.gdb\test_1_1",
           "ids":[4,6]
    }

]
}

I've tryed with all the possibility of "operationInput.TryGet...." but i Don't know how to take this json string correctly.

Someone can help me?

Anonymous User · Accepted Answer

Your JSON contains an "INSERT" JSON object with a JSON array, so you need to parse the JSON object and array first and then get their values inside. Say if you have an input parameter called "parm1" in your REST SOE, and your JSON is the value passed to the "parm1" parameter, you can parse the JSON like this:

JsonObject result = new JsonObject();
            JsonObject parm1Value;
            bool found = operationInput.TryGetJsonObject("parm1", out parm1Value);
            if (!found)
                throw new ArgumentNullException("parm1");
            object[] insertArr;
            if (!parm1Value.TryGetArray("INSERT", out insertArr))
                return Encoding.UTF8.GetBytes(result.ToJson());
            foreach (object insertContent in insertArr)
            {
                JsonObject insertJson = insertContent as JsonObject;
                if (insertJson != null)
                {
                    string url;
                    object[] ids;
                    if (insertJson.TryGetString("url", out url))
                        System.Diagnostics.Debug.WriteLine(url);
                    if (insertJson.TryGetArray("ids", out ids))
                        System.Diagnostics.Debug.WriteLine(String.Join(",", ids.Cast()));
                }
            }