Hi,
I have working on some dynamic representation of json (Generated by a rest webservice call) in the form of a table [In oracle apex to represent in the form a table]. My Webservice call return dynamic column names, how to represent in the form of a table through SQL or PLSQL. Is this possible.
All examples are shown if we know the key values in the json. But i'm not aware of those keys, what ever keys that generated by webservice call, those should be my column names.
e.g.,
If My webservice call generates
{
name: "ramesh"
age: 30
}
Some times, the webservice call might generate more columns or a different column names.
{
name" "ramesh"
dept : "ECE"
title: "Sr.
lastname: "gopi"
}
How do i represent this in the webservice call if i have a dynamic column names through apex_json. I am trying to implement using apex_json but not successful. Any suggestions..
Regards,
Ramesh G