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 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 07-04-2022 08:37:10 -0400

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: 4

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

Change detection property groups in Data Catalog
answered 25-03-2022 12:01:38 -0400

Hello, I would like to output the username of in the "property groups" -> "Edit property" --> " Allow variables in value" and not only in denodo but also in the export file (custom_property.json). So far there is only the "Default value" ->"$...

Answers: 1

Data Catalog JSON

Integration of a Json file with a special structure
answered 23-03-2022 07:03:02 -0400

Hello all, I currently have the problem that a json file cannot be read correctly into Denodo. No data is displayed here, see image 1. With other Json files this works perfectly. I used tuple root as "TUPLEROOT = /JSONFile/JSONArray". Attached is the...

Answers: 1

JSON Data Source JSON

JSON datasource - HTTP POST - ARRAY request and response FLATTEN
answered 21-03-2022 04:15:04 -0400

HI, i've set a JSON source for the API https://www.openfigi.com/api, with a parameter in POST body. CREATE DATASOURCE JSON ds_openfigi FOLDER = '/01-connectivity/01-data-sources/openfigi' ROUTE HTTP 'http.CommonsHttpClientConnection,120000' POST 'http...

Answers: 1

ARRAY JSON FLATTEN JSON Datasource

Connect to embedded Denodo database (Apache Derby) using REST API (required metadata view_custom_property.json, localviews.json).
answered 15-03-2022 08:29:04 -0400

Hello all, I would like to connect to the "live data" of the files view_custom_property.json and localviews.json. And afterwards I would like to create these as a base view. Unfortunately I can't find the right schema to access it via REST API: ...

Answers: 5

#Export_metadata JSON Denodo Rest API

Dynamic Query in JSON
answered 02-09-2021 07:11:26 -0400

Hi team, How to create a dynamic query for the specific field or multiple fields? Because, I think Dynamic query helps to filter the data in runtime and gets to filter the huge data and provide the result much faster than the usual one. So I need to ...

Answers: 1

Dynamic JSON Data Source JSON JSON Datasource Dynamic Datasources

Json array in data set - joining back to original data --- losing records when select * is used
answered 11-08-2021 06:58:14 -0400

I am seeing some odd behavior with a derived view that is the result of a field with JSON data being turned into an array and joined back to the original data set and the flattened. if I do a select * (no where clause) of the resulting join (after th...

Answers: 2

select query flatten ARRAY missing records JSON join

Flatten View to JSON Array Structure
answered 14-07-2021 05:08:19 -0400

I have joined three tables from oracle DB and projected two columns in each table. Now I tried to expose this as a JSON REST service endspoint. I have modified the output JSON structure, From the flattern view to JSON Array. Something like below. { 'ke...

Answers: 3

json

JSON exposed data discrepancy
answered 22-06-2021 16:17:20 -0400

Hi, I have exposed data into JSOn from Denodo API, the source system from which denodo is getting data is in form like this,it is in two line India - 123456; INDIA When exposed this data from denodo into JSOn format using API I am getting output: Ind...

Answers: 1

JSON

JSON-stat Data Sources
answered 09-06-2021 21:03:56 -0400

Hi everyone, I need to import a Data Source which is in JSON-stat format (https://json-stat.org/), 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 ...

Answers: 1

json source json JSON JSON Data Source Json