Q&A BY TAG 'JSON'

You must sign in to ask a question. If you do not have an account, you can register here

How to achieve JSON custom format for array of values while applying Denodo nest()
answered 11-01-2019 05:21:35 -0500

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

Answers: 1

Nested Array DENODO JSON REST Webservice

How to do error handling on accessing data sources that we do not control + Different REST Web Service formats don't seem to return the same information?
answered 10-01-2019 10:31:48 -0500

Hello! There are two problems, that my team was wondering if there were answers to. The first problem: There are several data sources that we have no control over, and therefore can't tell if those services are live or not. My team was wondering how w...

Answers: 2

denodo platform XML Denodo Testing Tool REST Webservice json HTML Error Handling

Json format issue while accessing through REST webservice with SQL having Double Quotes(") character
answered 09-01-2019 23:11:17 -0500

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

Answers: 3

JSON REST Webservice

Denodo Views
answered 03-07-2018 08:12:42 -0400

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

Answers: 4

post Json Base view JSON

Adding field in flatten view with file name as value
answered 05-06-2018 05:41:41 -0400

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.

Answers: 1

flatten field json JSON FLATTEN

When importing multiple files from JSON Data Source, a default name is given for the files. Can we change those default names?
answered 01-06-2018 12:04:58 -0400

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

Answers: 1

import Mulitple Files JSON

How to flatten an unknown hierarchy
answered 22-01-2018 12:52:33 -0500

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

Answers: 1

flatten array JSON

JSON Resource cannot be created due to problem with charset?
answered 06-12-2017 07:05:55 -0500

When creating the base view of a new JSON resource I get this error: ( ISO-8859-1) Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: Unexpected character ('­' (code 173)): expected a valid value (number, String, ...

Answers: 2

JSON

Unable to import XML file .
answered 30-11-2017 07:29:36 -0500

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

Answers: 1

Excel XML CSV XML Data Source JSON

JSON from https
answered 29-08-2017 08:33:15 -0400

How can I connect json data source from https? thanks

Answers: 1

JSON