Q&A BY TAG 'JSON'

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

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

JSON Data Source Array Issue
answered 17-07-2020 11:25:32 -0400

Hi, I am trying to create a Base View for a JSON based Data Source : [{"a":1, "b":2, "c":3}, {"a":11, "b":22, "c":33}, {"a":111, "b":222, "c":333}, {"a":1111, "b":2222, "c":3333}, {"a":11111, "b":22222, "c":33333}] If I create the view using the defau...

Answers: 2

data array JSON

Json data source pagination
answered 30-06-2020 17:43:41 -0400

Hi , I am able to fetch the data from API using oauth2 successfully, I am facing a challenge in configuring the pagination. https://apiexplorer.csod.com/apiconnectorweb/apiexplorer#/info I am trying to fetch the data from the above instructions, as ...

Answers: 3

Pagination REST API get JSON oauth2

Query report data from Oracle Service Cloud
answered 19-05-2020 15:49:38 -0400

Hi, I am trying to create a single view of a report obtained via a web service hosted by Oracle Service Cloud. The column names and row values are returned in seperate registers. In a base view query, the column names appear as rows as do the individu...

Answers: 3

Oracle Service Cloud JSON

How to flatten JSON Source on web returning different number of registers based on parameters
answered 12-05-2020 16:05:41 -0400

Apologies if my query has been answered elsewhere, but I haven't been able to find a relevant article / direction so far. I have an API source that is drawn into VDP as a JSON format. The API accepts dates as input parameters. Based on the dates enter...

Answers: 2

flatten registers Json date parameters

create base view for xml record from json file
answered 06-04-2020 12:05:31 -0400

Please i want to ask how i can create base view for spcific key at JSON obect file , which means I import json object from json file and this file contain key which it's value xml .. i need to create base view for this xml key

Answers: 1

Base view XML JSON

How to configure a JSON data source.
answered 10-03-2020 18:57:06 -0400

Hi, I'm trying to connect to a REST API (https://help.ivanti.com/ht/help/en_US/ISM/2019.1/admin/Content/Configure/API/Get-All-Business-Objects.htm) using Session ID method (auth token) I am able to do it connecting via Postman, but struggling to conf...

Answers: 2

authorization Ivanti Service Manager JSON