Q&A BY TAG 'JSON'

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

HTTP client JSON
answered 24-04-2019 17:22:22 -0400

Hi Team, Denodo Express 7.0 Please provide a working URL and supporting data for a JSON HTTP client example to practice. This does not work : http://data-server:8080/sales-ws/sales/ Thanks.

Answers: 1

JSON HTTP client

Working with JSON hierarchical data
answered 15-04-2019 17:47:30 -0400

Hi Denodo Team, I am struggling with virtualizing data which is in JSON format (and can only be pulled in JSON format from the API). There are numerous arrays within Registers within arrays. My requirement is that I do not create numerous flattened vi...

Answers: 1

flatten JSON

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 REST Webservice JSON

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