Latest Activity
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...
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...
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 ...
flatten Array Neo4j JSON FLATTEN Derived views JSON Datasource WEB design Studio
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
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" ->"$...
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...
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...
Hello all, I would like to connect to the "live data" of the files view_custom_property.json and localviews.json. And afterwards I would like to create these as a base view. Unfortunately I can't find the right schema to access it via REST API: ...
Hi team, How to create a dynamic query for the specific field or multiple fields? Because, I think Dynamic query helps to filter the data in runtime and gets to filter the huge data and provide the result much faster than the usual one. So I need to ...
Dynamic JSON Data Source JSON JSON Datasource Dynamic Datasources
I am seeing some odd behavior with a derived view that is the result of a field with JSON data being turned into an array and joined back to the original data set and the flattened. if I do a select * (no where clause) of the resulting join (after th...