You can translate the question and the replies:

Query to Json and send result

Good Morning, Could someone be able to help me carry out the task we are trying to achieve. Since we did not finish finding the key. The tasks would be the following: 1- Connect to BBDD (We can connect without problems) 2- SQL query to the DB (It returns the result of the query without problems) 3- Transform the result of the query to JSON format ** (We do not know how to perform this action) ** 4- Send the JSON (step 3) to a server. **(We do not know how to perform this action)** 5- Repeat the process every 5 min approx. (We know how to create tasks with the Job Scheduler) As you can see, I'm not sure if Denodo can do task 3 and 4. Any help will be great
user
25-03-2021 06:29:30 -0400

3 Answers

Hi, I would suggest you to use any of the following options available in the Denodo Platform to represent tabular data in **JSON** format. * 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) by either sending the appropriate Accept header in the HTTP request or by including the **$format** parameter in the URL. * You can publish views and associations in Denodo Platform as a [REST web service](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/publication_of_web_services/publishing_rest_web_services/publishing_rest_web_services) and choose JSON representation in [Settings Tab](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/publication_of_web_services/publishing_rest_web_services/settings_tab_rest) of the REST Web service in the Virtual DataPort Administration Tool. Hope this helps !
Denodo Team
26-03-2021 05:13:00 -0400
Hi, Thank you very much for your comments. Yeah I know I can use the Restful Web service to return the data in JSON format but we are not interested in that action. What we are trying to archive is to send in JSON format the result of the query to a server that is waiting for the data. Thanks in advance.
user
26-03-2021 05:41:46 -0400
Hi, For this scenario, I would publish views as [REST](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/publication_of_web_services/publishing_rest_web_services/publishing_rest_web_services) web services in the Denodo Platform and use the $format parameter to display the data in JSON format. By this, I would be able to use the REST API in different applications which expect JSON data as input. Hope this helps!
Denodo Team
02-04-2021 08:49:30 -0400
You must sign in to add an answer. If you do not have an account, you can register here