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