how to fetch specific value from json

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())".

Hi Mike,

I received this below error 

The value parameter must be a CDT, a dictionary, a map, a record, or a list. Received type: [Text],

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

Hi Mike

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

this is the one of the value at index one 

Works just fine...

Hi Mike, 

did you put this value as it is or you have removed something from this

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

Once again, you haven't really clarified what code you're actually trying to run on the value you're getting, so I can't really guess at what might be going wrong.  Please post a code snippet or something.

Hi Mike , 

say I fetching data from database , which returns list of 3 text strings  

"{"name":"PQ","cStartDate":"2012-07-01Z","eTerm":"2028-06-30Z","sStatus":"NA","t":1110.0,"Months":12,"Name":"","Text":"Eng","siteAccessConditionsIfApplicable":"rDo not use  \n++++++++++++++++++++++++++++++++++++++++\n\n\n","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  \n++++++++++++++++++++++++++++++++++++++++\n\n\n","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  \n++++++++++++++++++++++++++++++++++++++++\n\n\n","cMer":"GFTA"}"

I want to iterate this , 

but when I use , 

a!forEach(items: ri!valueToConvert,expression: a!fromJson(fv!item))

I received this Error : 

Hi Mike , 

say I fetching data from database , which returns list of 3 text strings  

"{"name":"PQ","cStartDate":"2012-07-01Z","eTerm":"2028-06-30Z","sStatus":"NA","t":1110.0,"Months":12,"Name":"","Text":"Eng","siteAccessConditionsIfApplicable":"rDo not use  \n++++++++++++++++++++++++++++++++++++++++\n\n\n","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  \n++++++++++++++++++++++++++++++++++++++++\n\n\n","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  \n++++++++++++++++++++++++++++++++++++++++\n\n\n","cMer":"GFTA"}"

I want to iterate this , 

but when I use , 

a!forEach(items: ri!valueToConvert,expression: a!fromJson(fv!item))

I received this Error : 

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.

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  \n++++++++++++++++++++++++++++++++++++++++\n\n\n"",""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  \n++++++++++++++++++++++++++++++++++++++++\n\n\n"",""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  \n++++++++++++++++++++++++++++++++++++++++\n\n\n"",""cMer"":""GFTA""}"
  },
  
  a!forEach(
    local!jsonArray,
    a!fromJson(fv!item)
  )
)