You can translate the question and the replies:

How to access unique/distinct values from the column in a Base view in RESTful web service?

I have added a base view in REST web service. How to access DISTINCT values of a particular column from that base view? Currently I am seeing entire base view here: http://servername:port/denodo-restfulws/database/views/baseview Representaion: JSON VQL code: SELECT DISTINCT columnname from baseview
user
09-05-2018 09:25:37 -0400

1 Answer

Hi, I would add **$groupby** and **$select** parameters on the REST Web Service invocation URL to apply DISTINCT and to SELECT only the required columns. For example: http://servername:port/denodo-restfulws/database/views/baseview?$groupby=col1&$select=col1 The above URL will retrieve and show only the DISTINCT values of *col1*. You can refer to the [Parameters of the RESTful Web Service](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/restful_architecture/restful_web_service/representations#parameters-of-the-restful-web-service) section of the [Virtual DataPort Administration Guide](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/index) to get more details. Alternatively, I would perform the following steps: 1. Create a derived view using “**Selection**”, where I keep only the expected column on the **Output** tab and select “**DISTINCT clause**” check box available on the same tab. 1. Publish the newly created derived view as RESTful Web Service to retrieve only the DISTINCT records. Hope this helps.
Denodo Team
10-05-2018 06:18:56 -0400
You must sign in to add an answer. If you do not have an account, you can register here