Latest Activity


Push down filter to JSON data source

Hi Team, I have a scenario where a REST API exposing large volume of data which required to be configured in Denodo as data source. We are able to achieve this by using JSON data souce and HTTP client. The data volume is high, hence filter conditions ...

JSON Data Source HTTP client


JSON Datasource Request

Hello, Is there a way to send a the current user name logged in or current session in a JSON Data Source Request. PS: I don't want to create 2 views and create a derived view just to pass the session id. Would it be possible to pass it directly in th...

JSON Data Source


Not able to escape special character in post body

Hello, I am trying to pass this expression: { ^ExecuteIfIsNotNull("\"'"customerId\"'" : "\"", @CID, "\", " ,"\"'"customerId\"'" :null, "), ^ExecuteIfIsNotNull("\"'"employeeId\"'" : "\"", @EID, "\", " ,"\"'"employeeId\"'" :null, "), ^ExecuteIfIsNotNul...

post Json JSON Data Source


JSON-stat Data Sources

Hi everyone, I need to import a Data Source which is in JSON-stat format (, which basically represents multidimensional arrays of data in a flattened fashion. I wanted to ask you if there is a predefined Denodo routine to import ...

json source json JSON Data Source JSON Json



I have tested a call with a cursor url parameter in Postman without any issues. But, when I add the cursor url in Denodo, I receive an error. URL:

JSON Data Source API HTTP client


Connecting to Census data using the API and can't flatten multiple levels of json arrays

I am using Denodo Express 8.0. I am trying to connect to the census api, and I'm able to create a base view using the url (,group(B01001) and a denodo json data source. But when I try to flatten it, i...

census JSON Data Source


JSON Data Sources Pagination Field - Help Text is Inconsistent with Validation Rules. -- Is it mandatory or not?

For JSON data sources retrieved via HTTP, the help text for "Parameter in URL for page size" and "Page size" for token continuation pagination indicates that they are "(Optional)", but when omitted, I can't save because a field validation tool tip pops...

design studio issue UI JSON Data Source HTTP


Flatten view

Hi Team, I have created one view from Json data source.In this view there are multiple columns and 4-5 coloumns are itself a collection of array.And Inside these element array there are elements which are itself a collection of array. I want to flatt...



How to set Dynamic value in Json Request Header for OAuth 2.0 Client Credential Value

Hi Team, I am trying to do JSON PoC with OAuth Authentication for below scanarios. 1) Request to Get Access Token using OAuth2.0 client credential Authentication 2) Pass this acces token dynamically to client application as a bearer token to get sess...

JSON Data Source


Auth 2.0 authentication in JSON source

Hi Team, We have created few java custom wrappers to connect to some API which is based on STS authentication method. Now they have migrated to Auth 2.0 authentication from STS. Now that we can connect to their API using json data source, GET method a...

JSON Data Source oauth2