Latest Activity
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...
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...
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 ...
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...
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 ...
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 ...
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...
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...
Hi, I am working with certain base views containing json data blobs as a column with the field type as text and not something like arrays.I am looking to flatten the view and get all the keys/values in separate columns. The content json blob column is ...
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.