Here is the code I use to deal = with JSON.
First a function to pull a value when you know wha= t JSON node you want:
[!]
<= br>
<= div>
+++++++++++++++++++++++++++++++++++= ++++++++++++++++++++++++FUNCTION Name: smGetJsonValue
=C2=A0 ** Description: Pull out a value from a JSONobject=
=C2=A0 ** Input:=C2=A0
=C2=A0 =C2=A0 =C2=A0 =C2=A0= jsonObject =3D (the json to be parsed) - required
=C2=A0 =C2=A0 =C2=A0 =C2=A0 jsonNode =3D (the = node that we the value of) - required
=C2=A0 ** usage:=C2=A0
=C2=A0 =C2=A0 =C2=A0 =C2=A0 [smGetJsonValue jsonObject=3D[= url]<the-json-object>[/url]&jsonNode=3D<the-json-node>]
[/!][function name=3DsmGetJsonValue][!]
[/!][text]tReturn=3D[/te= xt][!]
[/!][text]tJsonObject=3D[/text][!]
[/!][text]tJsonNode=3Dnull[= /text][!]
<= /div>
[/!][showif [url][params_string][= /url]^jsonObject][text]tJsonObject=3D[jsonObject][/text][/showif][!]=
[/!][showif [url][params_string]= [/url]^jsonNode][text]tJsonNode=3D[jsonNode][/text][/showif][!]
### =C2=A0Store the jsonObject in a table =C2=A0###
<= font face=3D"monospace, monospace">[/!][jsonstore table=3DjsonOject][tJsonO= bject][/jsonstore][!]
=
### =C2=A0Search the = table =C2=A0###
[/!][search table=3Djso= nOject&ne[tJsonNode]data=3Dfind_all][founditems][!]
[/!][text]tReturn=3D[interpret][[tJsonNode]][/interpret][/text= ][!]
=
[/!][/founditems][/search][!]
### =C2=A0Return the value =C2=A0###
[/!][return][tReturn][/return][!]
[/!][/function]
Second a = Json parser, that's a bit of a hack:
<h3>Paste some JSON</h3>
<form action=3D"[thisurl]" met= hod=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"></te= xtarea><br />
<button>Parse me</button>
</form>
[showif [action]=3Dparse-= json]
<h3>Sample JSON</h3><= /font>
<pre>[text show= =3DT]theJson=3D[sample-json][/text]</pre><br /><br />
[!]
------------------------------------ ### =C2=A0Conversion table to= strip non-breaking spaces ###
[/!][tab= le name=3DjsonClean&fields=3Dfrom,to]
%C2
%A= 0
[/table][!]
=
------------------------------------
### =C2=A0Conversion table to facilitate spliting into key:= value pairs =C2=A0###
=
[/!][table name= =3DjsonSplitConversions&fields=3Dfrom,to]
| ~~~~
\" ^^^^
[/table]= [!]
<= div>
------------------------------------
### =C2=A0Convert back after spliting into ke= y:value pairs =C2=A0###
[/!][table name= =3DjsonSplitConversionsBack&fields=3Dfrom,to]
"
~~~~ |
^^^^ "
[/table][!]