Q&A BY TAG 'Json'

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

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 Data Source JSON Json

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

#Rest API json api

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

pagination json REST Webservice

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

Synchronize json Data Catalog

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

JSON

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

performance JSON join

Flattening json content blob to separate columns
answered 22-09-2020 23:42:18 -0400

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 ...

Answers: 1

json

HTTP client JSON
answered 19-09-2020 16:28:08 -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: 2

JSON HTTP client

json_object_agg
answered 04-09-2020 08:21:05 -0400

What is the equivalent for postgres function json_object_agg(name, value) function in Denodo ?

Answers: 1

json_object_agg JSON

Working with JSON hierarchical data
answered 21-07-2020 15:24:12 -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: 3

flatten JSON