json property extract

[Khanna Ji]

Hi Friends - Happy New Year to you all.

I have a custom app and there is a property as shown below. How can I fetch this property values which are in Nested Json format? I tried JSON.parse(property) but its not working in scoped app.

{
"field1": "value1",
"field2": "value1"
},
{
"field1": "value2",
"field2": "value2"
}

var msg = gs.getProperty('myproperty');
var parsed = JSON.parse(msg);
for (var i = 0; i < parsed.length; i++){
gs.print(parsed[i].field1);}

[Ankur Bawiskar]

Hi,

it worked fine for me when I ran in BS

Are you running similar script in BS? please share that

Regards
Ankur

[Khanna Ji]

Propert is in scoped app

var prop = gs.getProperty('sn_hr_core.myprop');
var parse = JSON.stringify(prop);
var parsed = JSON.parse(parse);
gs.info(parsed.length);
for (var i = 0; i < parsed.length; i++){
gs.info(parsed[i].field1);
}

*** Script: 95
*** Script: undefined
*** Script: undefined
*** Script: undefined
*** Script: undefined
*** Script: undefined
*** Script: undefined
*** Script: undefined
*** Script: undefined

[Ankur Bawiskar · Accepted solution]

Hi,

the property is already string so don't use JSON.stringify()

I used as I was testing in background script

use this

var prop = gs.getProperty('sn_hr_core.myprop');
var parsed = JSON.parse(prop);
gs.info(parsed.length);
for (var i = 0; i < parsed.length; i++){
	gs.info(parsed[i].field1);
}

Regards
Ankur

[Ankur Bawiskar]

@Khanna Ji 

JSON.parse() works in scope app

Regards
Ankur

[Khanna Ji]

try it with property, it doesn't work