Q&A BY TAG 'JSON'

I am trying to execute the following query in VQL Shell: select * from my_table t where jsonpath(t.json_data, '$.property')='value'; But I get the following issue: Finished with error: Error in select view conditions: Function 'jsonpath' not create...

JSON

Hello, i'm trying to develop a koop provider to be able to consume denodo data from ArcGIS. I opted for the Koop Sample app template to install it . I followed the Denodo "Integrating Denodo with ArcGIS Online via GeoJSON" tutorial thoroughly to set up...

geojson arcgis koop JSON

Hi We have JSON files stored in an Oracle DB as BLOBs. We would like to convert the JSON files into a column of type 'Register'. We have ingested the BLOBS into Denodo and converted them into 'text' type columns. We now want to convert the text into a ...

Register JSON Oracle

Hi! I need to query HTTP/JSON datasource with parameters like this: /values?Name=Foobar&Start=2024-01-16&End=2024-01-17 (the previous and the current days) so I create a Base view with relative URL like this: /values?Name=Foobar&Start=@...

JSON HTTP client Date time function

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

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

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

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

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

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