RESTful Web service apply the ideas of the web to data-delivery, by providing scalable, flexible and stateless access to data assets based on well-known protocols and formats like HTTP, HTML, XML and JSON. Additionally to traditional SQL type access methods such as JDBC or ODBC, all the views in Denodo can be accessed using the RESTful interface.
The Denodo RESTful Web service is an HTTP service deployed by default in the URL http://localhost:9090/denodo-restfulws that exposes resources like databases and views in the following standard representation formats:
This Web service allows Denodo to work inside applications following the REST service architecture style and provides support for linked data in the enterprise deployment (see next section for more information about this).
When accessed from a browser, the Denodo RESTful endpoint will look like this:
See the examples below to know how to query this service:
tutorial
.client
of the database tutorial
.client
whose client_id
is C005
.We mentioned at the beginning of this section that Denodo supports three representation formats (XML, JSON and XHTML). You saw in the previous examples the XHTML format using a browser. How can you get the response in the other formats? The answer is easy, by adding a query parameter to the URL:
$format=json
. For example,$format=xml
. For example,In the next section, you will learn how to link your Denodo views to allow browsing linked data through the RESTful Web service.