json array and objects

Marco Vitrano marco.vitrano at gmail.com
Fri Mar 3 17:32:18 UTC 2023


hi all,
I need help in Omnis 8.1.5. I need to create a json file but I don't 
know how.
this is what i would like:
/*{*//*
*//*    "Schema": "tableName",*//*
*//*    "Inserted": [{*//*
*//*            "column1": "00",*//*
*//*            "column2": "Tyler",*//*
*//*            "column3": "Durden"*//*
*//*        }, {*//*
*//*            "column1": "01",*//*
*//*            "column2": "Marla",*//*
*//*            "column3": "Singer"*//*
*//*        }*//*
*//*        , {*//*
*//*            "column1": "01",*//*
*//*            "column2": "Robert",*//*
*//*            "column3": "Paulson"*//*
*//*        }*//*
*//*    ],*//*
*//*    "Deleted": [{*//*
*//*            "column1": "99"*//*
*//*        }*//*
*//*    ]*//*
*//*}


*/I created a list variable with 2 list columns.
If I use OJSON.$listorrowtojson, result doesn't show property names
if I use OJSON.$listtoobjectarray, returns "All list columns must be 
defined to have a simple type"

Any suggestions?
Thanks

*Marco Vitrano*




More information about the omnisdev-en mailing list