Q&A BY TAG 'Json'

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

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

MongoDB vs JSON
answered 26-02-2020 07:37:35 -0500

Hello, Here is the context for my question. It is an architecture question. We have centralized our data sources in Denodo. Now, this data must be consumed by a system that has a back-end on MongoDB. I would like a billateral communication. The linea...

Answers: 1

Connector API JSON mongodb

GENERATE_VQL_TO_CREATE_<json>_BASE_VIEW()
answered 07-02-2020 20:22:19 -0500

Hey, There is a stored procedure to generate vql to create base view for jdbc sources - GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW() but is there a option i can generate vql for otehr datasource. I.e json, csv, custom, etc

Answers: 1

Create Base View Delimited Files JSON

JSON Resource cannot be created due to problem with charset?
answered 26-09-2019 05:19:10 -0400

When creating the base view of a new JSON resource I get this error: ( ISO-8859-1) Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: Unexpected character ('­' (code 173)): expected a valid value (number, String, ...

Answers: 3

JSON