Latest Activity

code

How to pass the API key to this API

Hi, I am working on pulling the data from followign API and i need help in how to pass in the API key in the URL? URL https://mymarketnews.ams.usda.gov/mymarketnews-api/authentication I am using this URL in the JSON data source and aslo using the API...

code

Using OFFSET, FETCH, and LIMIT in an Integration View

I am trying to limit the volume returned by a view for testing purposes. I have tried using FETCH or LIMIT. Let's say I have a dataset that has groups A, B, and C and I only want to return two records for each group (I don't care which two- I'm only co...

code

Getting Year Value : 1 through getyear function for date field in HANA where the date field is null.

We created a denodo view on top of HANA view where we tried to use getyear function for a date field. That field is also getting null values and also date values. For date values the year is properly displayed but for date values which are null it is d...

code

OAuth2 in RESTful services

Is OAuth2 authentication supported for RESTful services as like its available for GraphQL? We have some extened querying requirements which GraphQL (for which we use OAuth2) doesn't seem to support. But RESTful services as per documentation support on...

code

Denodo RESTful Webservice

With respect to Denodo RESTful Webservice, which of the following is the appropriate URL to delete a customer record (of cust_id=100) from a customer view, assuming that the primary key of the view is cust_id? http://localhost:9090/denodo-restfulws...

code

Impersonation on RESTful and GraphQL services.

We are invoking the APIs using service account from an application but need to execute the query in Denodo as the user connecting to the calling application. Can this be achieved for RESTful and GraphQL services? Impesonation only seems to be support...

code

Improper import and element showing in VDP

Hi Team, I am facing a weird issue in denodo 8 VDP. so i have 1 derived where i am doing joins . In that join i am joing base table A with table B and table C. Now i modified the derived view vql and replaced the table B with D and table C with E na...

code

long field. division

Hi Team I have a column of type 'long'. values like 20, 15, 133, 100. I have to create a new column using it which must have values like .20, .15, 1.33, 1.00 so something like long field/100. How do I do that. ? for me 'long field'/100 is returning ...

code

Is there a way to enable non admins to assign roles to users and other roles ?

Is there a way to allow users in non admin role to assign roles? They are able to create new users and roles, assign privileges but not able to assign roles and also not able to export vql with user privileges. They are admin on all databases and are a...

code

How can you access the Scheduler Log files without Client API?

We are interested in analyzing the Denodo Scheduler log data to monitor jobs, identify trends in errors/job failures, and to identify trends on when jobs are being run. From my research, it looks like the only documneted way to get this data with Denod...