Q&A BY TAG '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
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
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
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
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
Can JSON Data source do join operation?
answered
20-09-2019 06:57:50 -0400
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" ...
Answers:
1
OData2 Wrapper converting DateTime to "Local" DateTime?
answered
01-07-2019 09:00:51 -0400
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...
Answers:
1