[{"Name":"Test 1","ROW_ID":"4646"},{&quo

padmanabhanv over 10 years ago

[{"Name":"Test 1","ROW_ID":"4646"},{"Name":"Test 2","ROW_ID":"4648"}] is the output of a executeQuery() function. Need to display this in a grid - I am not able to parse this with the json functions. We are in 7.5, hence using queryEntity is not an option....

Discussion posts and replies are publicly visible

Parents

0 siddharthg521 over 10 years ago

Hi, wef Appian 77, there is a new json function available OOB named - a!fromJSON that will parse given JSON and return the datasubset result (CDT like structure) and then you can use the conventional dot operator to access any field(s)

For example, in your case - =a!fromJson("[{"Name":"Test 1","ROW_ID":"4646"},{"Name":"Test 2","ROW_ID":"4648"}]") will return [Name:Test 1,ROW_ID:4646], [Name:Test 2,ROW_ID:4648] as output, and now lets say you only need ROW_ID, then you can use =a!fromJson(ri!json).ROW_ID which will give you 4646, 4648 as output.

Hope it helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 siddharthg521 over 10 years ago

Hi, wef Appian 77, there is a new json function available OOB named - a!fromJSON that will parse given JSON and return the datasubset result (CDT like structure) and then you can use the conventional dot operator to access any field(s)

For example, in your case - =a!fromJson("[{"Name":"Test 1","ROW_ID":"4646"},{"Name":"Test 2","ROW_ID":"4648"}]") will return [Name:Test 1,ROW_ID:4646], [Name:Test 2,ROW_ID:4648] as output, and now lets say you only need ROW_ID, then you can use =a!fromJson(ri!json).ROW_ID which will give you 4646, 4648 as output.

Hope it helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data