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);}

[Khanna Ji]

it worked, thanks you.

[Abhijit4]

Hi,

Please try below,

var arr=gs.getProperty("myprop");

var parsed = JSON.parse(arr);
for (var i = 0; i < parsed.length; i++){
gs.info(parsed[i].field1);}

put value in property like below

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

Its working for me in my PDI.

Let me know if you have any further queries.

Please mark this as Correct or helpful if it helps.

Thanks and Regards,
Abhijit

[Khanna Ji]

JSON object doesn't work in scoped app.

[Abhijit4]

try with below once

var arr=gs.getProperty("myprop");

var parsed = global.JSON.parse(arr);
for (var i = 0; i < parsed.length; i++){
gs.info(parsed[i].field1);}