You can translate the question and the replies:

Creating JSON output

Hi, I have some usecases that require delivery of data objects (nested hierarchical objects such as JSON) via REST service. I've worked with flatenning JSON data sources, but never tried building JSON output from other flat views. Could you point me to some tutorial or to appropriate documentation on this site? Thank you.
user
22-09-2023 03:17:34 -0400
code

1 Answer

Hi, In Denodo you can use the NEST operation that will be transformed into arrays with the values of the selected fields. For more details on the Nest function you could take a look at [Aggregate functions](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/aggregation_functions/aggregation_functions#nest) Virtual DataPort guide. You can use the [RESTful Web service](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/restful_architecture/restful_web_service/restful_web_service) of Denodo Platform that publishes the contents of the entire Virtual DataPort server. By default, the RESTful Web service returns the data represented in HTML, but you can choose another [representation](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/restful_architecture/restful_web_service/representations#json-representation) (JSON) by either sending the appropriate Accept header in the HTTP request or by including the **$format** parameter in the URL. The following answer may help: [How to specify json structure when we publish a flat view as rest web service](https://community.denodo.com/answers/question/details?questionId=90670000000Xd6OAAS&title=How+to+specify+json+structure+when+we+publish+a+flat+view+as+rest+web+service) Hope this helps!
Denodo Team
22-09-2023 06:43:21 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here