Latest Activity

code

Json data source pagination

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

Pagination REST API get JSON oauth2

code

Query report data from Oracle Service Cloud

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

Oracle Service Cloud JSON

code

How to flatten JSON Source on web returning different number of registers based on parameters

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

flatten registers Json date parameters

code

create base view for xml record from json file

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

Base view XML JSON

code

How to configure a JSON data source.

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

authorization Ivanti Service Manager JSON

code

MongoDB vs JSON

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

Connector JSON API mongodb

code

GENERATE_VQL_TO_CREATE_<json>_BASE_VIEW()

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

Create Base View JSON Delimited Files

code

JSON Resource cannot be created due to problem with charset?

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

JSON

code

Can JSON Data source do join operation?

I have a JSON data source from RESTful API and create a view. I want do join operation and can't select the join conditions. Cause in JSON View, it's Object type not the same type as normal table view. JSON view: { "name" : "test", "elements" : [{"c1" ...

JSON

code

OData2 Wrapper converting DateTime to "Local" DateTime?

I have been using a JSON data source and switched to a custom wrapper for Odata3 (using OData2 custom wrapper with headers 'Content-type="application/json";Accept="application/json";DataServiceVersion="2.0";MinDataServiceVersion="2.0";MaxDataServiceVer...

ODATA OData Date Conversion Timezone conversion json JSON