Hi Denodo Team,
I have created a base view with 3 employee records for Dept_id= 'D100' as below.
SELECT 'D100' AS dept_id , 'E1' AS empid FROM DUAL
UNION
SELECT 'D100' AS dept_id , 'E2' AS empid FROM DUAL
UNION
SELECT 'D100' AS dept_id , 'E3' AS empid FROM DUAL
**My requirement is to display the array of empid's in JSON output format (given below) through REST webservice:
**"employees": {"empid": ["E1","E2","E3"] }.
- I have performed nest() and here is my current output & SQL used:
Query Used:
select nest(empid) as employees from bv_test group by dept_id;
**REST OUTPUT: **
{
"name": "p_bv_test",
"elements": [
{
"employees": [
{
"empid": "E1"
},
{
"empid": "E2"
},
{
"empid": "E3"
}
]
}
]
}
Please suggest appropriate function(s) or advise to use in Denodo to achieve the desired output.
Thanks & Regards,
Srujan.