Latest Activity

code

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...

REST API REST Distinct

code

REST data source returning only text/plain

I am using Denodo 6. I am faced with a REST data source that actually returns text/plain only - application/json or application/xml is not offered. Probably the easiest approach is to create a Delimited File data source with a very uncommon delimiter, ...

REST HTTP

code

Error when using LIKE operator: URLDecoder: Illegal hex characters in escape (%) pattern

Hello, I am running into an issue when using the LIKE operator on my webservice. In order to make the like more effective, I have added a percent sign before and after the text I want to search on. This way I can bring back results that have my text a...

REST search Like Filter encoding URL Web Service

code

ReST API - cookie

We have ReST API which should returns cookie and value . Obviously we can capture the values thru the base view but how do we capture cookie as part of the result. Our idea is capture the Cookie value and use it as interpolation variable for the subseq...

REST API REST

code

Denodo Rest Service execution issues

We have created some views which access data from an API. These views are interdependent. Data from one view (token) acts as an input to make an API call from the second view. All this is working when we are accessing these views as dervied view and re...

REST

code

Aggregate operation on Rest web service

Hi, Does Denodo allow passing aggregates operations over an API? I have a REST API and the user needs to select only 3 columns from that API, group by 2 columns and calculate aggregate(sum operation) over the third column. I am able to select three co...

REST API Aggregate

code

ReST API PDF

I have Rest API which will retrive the PDF content , How would I stroe this file in specific folder As well as , I would to like to schdule the process so that pdf will get stored in daily basis Is this possible with Denodo ? Thanks

REST API REST

code

Rest API - Unable to obtain the data structure

Here is the sample ReST API . I can access this API thru Postman or the Browser https://api.example.com/client-api/v2/suppliers?apikey=12345abcede When I built this API using the JSON Test connection was working fine but when I try to create base vi...

REST API REST

code

Adding Logic to Join View

Hello, I am having some issues designing a solution to a feature that I need to create. Scenario: I have a data set with a specific field that needs to be modified when a condition true is passed in from the web service and not modified when a condi...

VQL REST join Logic Web Service

code

Searching on fields that will be nested on outbound and support the 'in' operation in web service

We have a Denodo service we want to create but have ran into some issues while creating it. The customer required a few things for this service. A default set of parameters if they don't send any themselves, which we are using the 'ExecuteIfIsNotNull' ...

rest restful nesting