Latest Activity

code

Creating JSON output

Hi, I have some usecases that require delivery of data objects (nested hierarchical objects such as JSON) via REST service. I've worked with flatenning JSON data sources, but never tried building JSON output from other flat views. Could you point me to...

JSON

code

Parsing JSON file

Hi there, I face the following challenge when trying to create a base view from a JSON file. The content of the file is as follow: {"key1":"xxxx","key2":"xxxxx","key3":"xxxxx","key4":"xxxxx"} {"key1":"xxxxx","key2":"xxxxx","key3":"xxxxx","key4":"xxxx...

JSON Data Source Json

code

Passing a list of same objects and passing a list of different objects in a select query view.

I would like to pass the following data into denodo view. Json1 = {'name': 'Kelly', 'code': 'KL'} Json2 = {'name': 'John', 'code': 'JH'} payload = [Json1, Json2] I am expecting two of Jsons to query the view. I tried putting payload into my denodo ...

JSON

code

generate JSON-files from Denodo?

Is it possible to generate json-files directly from Denodo, like it is possible with XML. Or, alternativly, is it possible to ingest json (provided by a Denodo created REST webservice) into a remote table (Snowflake table with VARIANT data type for ex...

JSON

code

Unable to use row_number() function when JSON as Data source

Hi,I am using JSON as data source. I would like to use row_number() function in my view. Getting data source from API in JSON format. Base view is created from the root JSON array. I have used flattern view to remove the top JSON array. From the fla...

row_number() JSON JSON Datasource

code

Dendo Design Studio's problem with Neo4J

Hello Team, I'm using Denodo 8 via Web Design Studio. I created the Neo4j datasource via HTTP configuration with post method, also making use of a Json file. I inserted the fields via the following source query: {"statements": [ \{ "statement": "MATCH ...

Array flatten Neo4j JSON FLATTEN Derived views JSON Datasource WEB design Studio

code

How to do error handling on accessing data sources that we do not control + Different REST Web Service formats don't seem to return the same information?

Hello! There are two problems, that my team was wondering if there were answers to. The first problem: There are several data sources that we have no control over, and therefore can't tell if those services are live or not. My team was wondering how w...

denodo platform XML Denodo Testing Tool REST Webservice json HTML Error Handling

code

Change detection property groups in Data Catalog

Hello, I would like to output the username of in the "property groups" -> "Edit property" --> " Allow variables in value" and not only in denodo but also in the export file (custom_property.json). So far there is only the "Default value" ->"$...

Data Catalog JSON

code

Integration of a Json file with a special structure

Hello all, I currently have the problem that a json file cannot be read correctly into Denodo. No data is displayed here, see image 1. With other Json files this works perfectly. I used tuple root as "TUPLEROOT = /JSONFile/JSONArray". Attached is the...

JSON Data Source JSON

code

JSON datasource - HTTP POST - ARRAY request and response FLATTEN

HI, i've set a JSON source for the API https://www.openfigi.com/api, with a parameter in POST body. CREATE DATASOURCE JSON ds_openfigi FOLDER = '/01-connectivity/01-data-sources/openfigi' ROUTE HTTP 'http.CommonsHttpClientConnection,120000' POST 'http...

ARRAY JSON FLATTEN JSON Datasource