Latest Activity

code

How to achieve JSON custom format for array of values while applying Denodo nest()

Hi Denodo Team, I have created a base view with 3 employee records for Dept_id= 'D100' as below. SELECT 'D100' AS dept_id , 'E1' AS empid FROM DUAL UNION SELECT 'D100' AS dept_id , 'E2' AS empid FROM DUAL UNION SELECT 'D100' AS dept_id , 'E3' AS empid...

Nested Array DENODO REST Webservice JSON

code

Json format issue while accessing through REST webservice with SQL having Double Quotes(") character

Here are the steps we tried and we are hitting with JSON format issue in output while accessing REST webservice on Denodo derived view. Can anybody help suggesting on how to get rid of backslash \ character in the output? We are looking for output to...

JSON REST Webservice

code

Denodo Views

Hi Denodo community, I have the following: Data Source: JSON * Name: HTTP CLIENT * Configure: Post * URL: Rest Call The source currently has nested elements, some fields either appear as a register or arrays. I do not want to...

post Json Base view JSON

code

Adding field in flatten view with file name as value

I am creating a flatten view on top of the base view of JSON Data Source. I want a new field to be added in the output within which the field contains file name( ex:- name.json) as value.

flatten field json JSON FLATTEN

code

When importing multiple files from JSON Data Source, a default name is given for the files. Can we change those default names?

After creating JSON data source and selecting a folder containing multiple files, after executing in the execution panel the results are given a default name. I am getting the output as: [Array]... [Array]... [Array]... [Array]... [Array]... There ar...

import Mulitple Files JSON

code

How to flatten an unknown hierarchy

I have a JSON datasource which returns a hierarchy along the lines of the JSON below. The key thing here is that from one web service call to the next the folder structure can differ i.e. each folder is an array and can contain different numbers of sub...

flatten array JSON

code

Unable to import XML file .

We have multiple data present in multiple files (xml,csv,json,excel) in multiple linux servers . When we tried to connect using available option under connections -> Data route ->configurations (FTP/SFTP/FTPS) using URL ftp://server_ip:port/dir/f...

Excel XML CSV XML Data Source JSON

code

JSON from https

How can I connect json data source from https? thanks

JSON

code

JSON parameter with OR condition

Team, We are creating datasource going into Datasource -> Json and creating datasource connection and creating base view from API 1) We are succesfully able to create Datasource the connection passing below credentials DATA route: HTTP Client HTTP...

DENODO json JSON

code

Using JSON data source from file, when the root is array

Hi, I tried to use the JSON data source, when the root json type is array. Let's take for example a file containing the following data : [{"id" : 3, "name" : "xxx", "color" : "blue", "available" : false},{"id" : 13, "name" : "yyy", "color" : "green", ...

JSON