View source for Cookbook Ingredients - Code Snippets

== JSON ==

=== Find Name of Key Containing an Array Containing a Key/Value Pair ===

Given a JSON object like this one that contains arrays of states returned from getInfo("campaign"):

<pre>{
"other stuff":{},
"states":{
    "no group":
        [
            {"name":"Dead"... },
            {"name":"Hidden"... }
        ]
    "my named group":
        [
            {"name":"Blind"... },
            {"name":"Deaf"... }
        ]
    },
"more stuff":{}
}</pre>

To find the name of the key containing the array that has the desired  key/value pair, e.g.  for the state "Blind" return "my named group".

<pre>[h: jsonObject = getInfo("campaign")]
[h: findKey = "name"]
[h: findValue = "Blind"]
[h: findWithin = "states"]
[r: keyName = listGet(json.get(json.path.read(json.get(jsonObject, findWithin), strformat("\$..[?(@.%{findKey} == '%s')]", findValue), "AS_PATH_LIST"), 0), 1, "'")]
alternatives
[r: keyName = getGroup(strfind(jsonObject, '(?<=\\"'+findWithin+'\\":).*\\"([^\\"]+)\\"(?=:\\[)(?=.*\\"name\\":\\"'+findValue+'\\")'), 1, 1)]
[r: keyName = replace(jsonObject, '.*(?<=\\"'+findWithin+'\\":).*\\"([^\\"]+)\\"(?=:\\[)(?=.*\\"'+findKey+'\\":\\"'+findValue+'\\").*',"\$1", 1)]
[r: keyName = replace(json.get(jsonObject, findWithin),'.*?([^\\"]*)\\"\\:\\[[^\\[]*\\"'+findValue+'\\".*',"\$1", 1)]</pre>

=== Find Name of Key Containing an Object Containing a Key/Value Pair ===

Given a JSON object like this one that contains JSON objects

<pre>[h: jsonObj = '{
  "a": {
    "Return": "No"
  },
  "b": {
    "Return": "Yes"
  },
  "c": {
    "Return": "No"
  }
}']</pre>

To find the key name of the first object containing an occurance of "Return": "Yes"

<pre>[r: listGet(json.get(json.path.read(jsonObj, ".[?(@.Return == 'Yes')]", "AS_PATH_LIST"), 0), 1, "'")]</pre>

To get an array of all key names of objects containing an occurance of "Return": "Yes"

<pre>[r: replace(json.path.read(jsonObj, ".[?(@.Return == 'Yes')]", "AS_PATH_LIST"), "\\\$\\[\\'|\\'\\]", "")]</pre>

[[Category:Cookbook]][[Category:Snippets]]