In the JSON_Listify demo, the output is not valid because the third key of "director" has a value which contains an array rather than a string. Is there a way to use ardoJSON to turn the entire JSON string into valid key/value pairs?
Yes this is the issue with JSON in OutSystems. Direct array can not be handled due to key is converted as structure.
I faces same issue with following json ( in my case array of arrays)
can you please share your json ?
I understand that this is a limitation of OutSystems, but I thought this was the issue ardoJSON was supposed to solve?
So in the example of a list of movies, is there a way to "listify" the entire thing?
{
"title": "The Lord of the Rings: The Fellowship of the Ring",
"ReleaseDate": "2001-12-19T00:00:00",
"director": { "firstName": "Peter", "lastName": "Jackson" },
"SCORE": 8.8,
"actors": [
{ "name": "Elijah Wood", "plays": "Frodo Baggins"},
{ "name": "Sean Astin", "plays": "Samwise 'Sam' Gamgee"},
{ "name": "Sean Bean", "plays": "Boromir"},
{ "name": "Cate Blanchett", "plays": "Galadriel"},
{ "name": "Ian Holm", "plays": "Bilbo Baggins"}
],
"keywords": [ "ring", "hobbit", "doom", "middle earth", "quest", "epic" , "bravery"]
}
As checking your JSON i think it will work
create a structure with the JSON and try to assign output to structure and check.
Or possible please provide oml to check at my end.
In your json listify will not work because the director is not an array. it is a object
it will work for actors
If your director will be an array then it will work. here is the example.