Latest Activity

code

Obtaining Data from API

Hello. I would like to obtain data from this API: https://www.bankofcanada.ca/valet/ What type of data source do I need to create, please? Thank you.

#Cloud API #Rest API #API #Rest_API API

code

Missing parameter level info Error 106 - json datasource connection

Hi , We are working on Denodo 8 VDP. I have a requirement to extract information from an API. we successfully established connection and extracted few details through the API keys. The real challenge comes when we are trying to access one of the API's ...

API

code
code

api timeout around 30 seconds

I make an api call from Denodo. The Timeout on the HTTPS Configuration is set to 120 seconds and all the other timeout in vdb is set to a higher value. When I make the call, I need to call the same api twice with different set of inputs. I do a union o...

api

code

Apachet Tomcat HTTPS not working

Hi, I want to connect to Adobe Analytics data source using the API with the OAuth credentials. For the process I need to enable the imbedded HTTPS which comes with Apache Tomecat. I have followed all the steps in the below guide in detail, but I am no...

Tomcat HTTPS API

code

Aggregate data via restful web service

I've seen this question asked a couple of times but last answered in 2017. Is there now a way to aggregate (e.g. sum) data via the restful web service? E.g. '...$groupby=category&$select=category,sumValue&$format=json'

REST API API Denodo Rest API Aggregate

code

View model parameters in web service call

I created a view with a parameter, "param_Value". In the where clause I'm filtering on key table value "in" param_Value. My web service vql looks like the following CREATE OR REPLACE VIEW "iv_ViewName1" FOLDER = '/folders/3 - integrated views' PRIMAR...

Filter API

code

How to pass comma delimited value to webservice

My view query looks like Select val1, val2, val3 from iv_view where val1 in (input_Val). I am passing input_Val from query string in web service call. If I pass a single value I get a single result but if I pass multple values I don't get any results...

Filter API

code

Check API data availaibility

Hi Team, Is there a way to check if the connection to the API is working or not? So that in case the API is not accessible we can set up alerts upfront and inform the users that data is not available because the API is down or with the detailed error ...

API

code

API connection working but cannot paginate using a cursor key reference in the JSON response

I have a working API call that returns the first set of data without error (up to first 5000 records). However, when I try to set up pagination using a value in the end of the results it spins indefinitely. The token to use is called "cursor" at th...

Pagination API