Here is the code I use to deal with JSON.
[!]
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
FUNCTION Name: smGetJsonValue
** Description: Pull = out a value from a JSONobject
** = Input:
jsonObject =3D (the = json to be parsed) - required
= jsonNode =3D (the node that we the value of) - required
** = usage:
[smGetJsonValue = jsonObject=3D[url]<the-json-object>[/url]&jsonNode=3D<the-jso= n-node>]
[/!][function = name=3DsmGetJsonValue][!]
[/!][text]tReturn=3D[/text][!]
= [/!][text]tJsonObject=3D[/text][!]
= [/!][text]tJsonNode=3Dnull[/text][!]
[/!][showif = [url][params_string][/url]^jsonObject][text]tJsonObject=3D[jsonObject][/te= xt][/showif][!]
[/!][showif = [url][params_string][/url]^jsonNode][text]tJsonNode=3D[jsonNode][/text][/s= howif][!]
= ### Store the jsonObject in a table = ###
[/!][jsonstore = table=3DjsonOject][tJsonObject][/jsonstore][!]
### Search the table = ###
[/!][search = table=3DjsonOject&ne[tJsonNode]data=3Dfind_all][founditems][!]<= /div>
= [/!][text]tReturn=3D[interpret][[tJsonNode]][/interpret][/text][!]<= /font>
[/!][/founditems][/search][!]
= ### Return the value ###
[/!][return][tReturn][/return][!]
[/!][/function]
[text]debug=3DF[/text]
<h3>Paste = some JSON</h3>
<form action=3D"[thisurl]" = method=3D"post">
<input type=3D"hidden" name=3D"action" = value=3D"parse-json" />
<textarea name=3D"sample-json"= style=3D"width: 50%; height: 200px;" placeholder=3D"paste some = json"></textarea><br />
<button>Parse = me</button>
</form>
[showif [action]=3Dparse-json]
<h3>Sample JSON</h3>
<pre>[text= show=3DT]theJson=3D[sample-json][/text]</pre><br /><br = />
[!]
= ------------------------------------
= ### Conversion table to strip non-breaking spaces = ###
[/!][table = name=3DjsonClean&fields=3Dfrom,to]
%C2 =
%A0
[/table][!]
= ------------------------------------
= ### Conversion table to facilitate spliting into key:value = pairs ###
[/!][table = name=3DjsonSplitConversions&fields=3Dfrom,to]
| = ~~~~
\" ^^^^
[/table][!]
= ------------------------------------
= ### Convert back after spliting into key:value pairs = ###
[/!][table = name=3DjsonSplitConversionsBack&fields=3Dfrom,to]
" =
~~~~ |
^^^^ = "
[/table][!]
= ------------------------------------
= ### pass one - run the conversions = ###
[/!][text]theJson=3D[convertwords= table=3DjsonSplitConversions][convertchars = table=3DjsonClean][theJson][/convertchars][/convertwords][/text][!]=
= ------------------------------------
= ### pass two - add bar to just before each key:value pair = ###
[/!][text]theJson=3D[grep = search=3D("[^"]*"):&replace=3D|\1=3D][theJson][/grep][/text][!]=
= ------------------------------------
= ### pass three - list out the key:value pairs and assign = them to text variables ###
[/!][text]count=3D0[/text][listwords = words=3D[url][theJson][/url]&delimiters=3D|{}][!]
[/!][text]thisVal=3D[grep = search=3D(,$)&replace=3D][getchars = start=3D1&trim=3Dboth][convertwords = table=3DjsonSplitConversionsBack][word][/convertwords][/getchars][/grep][/= text][!]
=
= [/!][showif [debug]=3DT][index]. = [url][thisVal][/url]<br />[/showif][!]
=
= [/!][hideif [url][thisVal][/url]=3D][!]
= [/!][text]json-[format .2d][text = show=3DT]count=3D[math][count]+1[/math][/text][/format]-[thisVal][/text][!= ]
= [/!][/hideif][!]
[/!][/listwords][!]
= ------------------------------------
= ### Let's have a look at the variables = ###
[/!]<h3>JSON Assigned to = Text Variables</h3>
[listvariables = name=3Djson-&exact=3DF][name] =3D [value]<br = />
[/listvariables]
[/showif]