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

Hi, Did you tried parsing thr returned json array with extractjsonarray function ?
I have used this multiple times to parse thr json and populating the returned set in cdts and mapping them on grid.

Ok, which plugin is this by the way? I don't see it as part of the json functions.

Hi, I have exactly the same problem, I used extractjsonarray but I got a regular array, but I need a subset to be able to use it in the grid

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.