Q&A BY TAG 'Json'
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 JSON Data Source 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
Exposing JSON data into API with specific parameter
answered
25-05-2021 15:01:46 -0400
I have this format as of now when I exposed my data into JSON format(the default one): { "name": "cp", "elements": [ { "reference": "beta5", "ordernumber_0": 8008, "product": "gaiytaqw", "what": "sagar", "applicat...
Answers:
5
Get all JSON results from restful webservice
answered
21-04-2021 07:22:54 -0400
I have the following URL that is return JSON format for one of my views: http://mycompany:9090/denodo-restfulws/hcc_dv/views/mytestview/?$format=JSON However, it only returns the first 25 rows. I have tried every conceivable varitation to get all 150 ...
Answers:
1
How to configure the Json data source for VDP-Data Catalog - Synchronize?
answered
15-12-2020 21:43:31 -0500
Hi Team, I am refering link "https://community.denodo.com/answers/question/details?questionId=9060g0000004FVuAAM&title=Data+Catalog+-+Synchronize+comments" for the Data Catalog - VDP - Code Synchronize. I am trying to create JSON data source calls ...
Answers:
9
Creating Json, confirming to open targets schema from any datasource,
answered
30-10-2020 01:56:17 -0400
Hello, I have tried to search for this in denodo if I can call any Api or other data in other form into JSON and I cannot find anything. SO is it possible to get any such data in JSOn format always irrespective of data Source form? Any way of conver...
Answers:
1
Poor performance for jdbc and json array type join
answered
09-10-2020 08:19:14 -0400
Hi, I observered a poor performance for a join between a jdbc type view and json array. individually when queried they are running fast but when we do a join it's performance degrades. Can you suggest how to improve performance ? Also i see 347 subp...
Answers:
1