Q&A BY TAG '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
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
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 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
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
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
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 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-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