how to fetch specific value from json

Question

Hi All , 
 
 I have values stored in database in a particular field i.e. say previousValues, like below

"{"name":"xyz","regDate":"2012-07-01","regStatus":"Completed"}" -- (Text)

Now my requirement is to fetch regStatus value from this format . 
 How can I achieve this

Mike Schmitt · Answer

You will need to read up on the built-in JSON functions - a!toJson(), and (the one you need) a!fromJson() . Passing your text string through this rule will return a dictionary value, from which you can directly pull the named property by the normal means including just using the dot property (i.e. "local!result.regStatus") or by use of the "property()" function, i.e. "property(local!result, "regStatus", null())".

Mike Schmitt · Answer

Please share a code snippet for what you're trying. It works right away when I try it.

Mike Schmitt · Answer

as-is, minus the outermost quotes which aren't part of the valid JSON string.

Mike Schmitt · Answer

How are they getting passed into "ri!valueToConvert" after being queried? If they're coming in with the outer quotes somehow, those aren't a valid part of the JSON.

Mike Schmitt · Answer

As you can see, all 3 of those are valid JSON and a!fromJson() works on them just fine. In fact we can even manually set them as local variables (we just have to properly escape all internal quotes in that case to make them proper strings). a!localVariables(
 local!jsonArray: {
 "{""name"":""PQ"",""cStartDate"":""2012-07-01Z"",""eTerm"":""2028-06-30Z"",""sStatus"":""NA"",""t"":1110.0,""Months"":12,""Name"":"""",""Text"":""Eng"",""siteAccessConditionsIfApplicable"":""rDo not use 
++++++++++++++++++++++++++++++++++++++++

"",""cMer"":""GFTA""}",

 "{""name"":""PQ"",""cStartDate"":""2012-07-01Z"",""eTerm"":""2028-06-30Z"",""sStatus"":""NA"",""t"":1110.0,""Months"":12,""Name"":"""",""Text"":""Eng"",""siteAccessConditionsIfApplicable"":""rDo not use 
++++++++++++++++++++++++++++++++++++++++

"",""cMer"":""GFTA""}"
 },
 
 a!forEach(
 local!jsonArray,
 a!fromJson(fv!item)
 )
)