Q&A BY TAG 'JSON Data Source'
JSON file within a ZIP --- can access but the formatting is odd ---
answered
11-04-2022 03:50:06 -0400
I have created a data source that pulls in a zip file with a JSON file inside it and I am strugging to parse it with a custom tupple pattern. No matter what tuple root I use Denodo fails to display it -- it just blanks out and no error message provided...
Answers:
2
Integration of a Json file with a special structure
answered
23-03-2022 07:03:02 -0400
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...
Answers:
1
JSON Datasource Tuple Root Rows
answered
10-11-2021 15:14:19 -0500
Hello, I'm trying to create a JSONDatasource from this sample: [ { "Header": { "publishedDateTime": "20211110150141", "messageId": null, "messageType": null, }, "Investment": { ...
Answers:
1
Dynamic Query in JSON
answered
02-09-2021 07:11:26 -0400
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 ...
Answers:
1
Dynamic JSON Data Source JSON Dynamic Datasources JSON Datasource
Push down filter to JSON data source
answered
15-07-2021 02:33:44 -0400
Hi Team, I have a scenario where a REST API exposing large volume of data which required to be configured in Denodo as data source. We are able to achieve this by using JSON data souce and HTTP client. The data volume is high, hence filter conditions ...
Answers:
3
JSON Datasource Request
answered
01-07-2021 08:26:20 -0400
Hello, Is there a way to send a the current user name logged in or current session in a JSON Data Source Request. PS: I don't want to create 2 views and create a derived view just to pass the session id. Would it be possible to pass it directly in th...
Answers:
1
Not able to escape special character in post body
answered
28-06-2021 22:52:32 -0400
Hello, I am trying to pass this expression: { ^ExecuteIfIsNotNull("\"'"customerId\"'" : "\"", @CID, "\", " ,"\"'"customerId\"'" :null, "), ^ExecuteIfIsNotNull("\"'"employeeId\"'" : "\"", @EID, "\", " ,"\"'"employeeId\"'" :null, "), ^ExecuteIfIsNotNul...
Answers:
1
JSON-stat Data Sources
answered
09-06-2021 21:03:56 -0400
Hi everyone, I need to import a Data Source which is in JSON-stat format (https://json-stat.org/), which basically represents multidimensional arrays of data in a flattened fashion. I wanted to ask you if there is a predefined Denodo routine to import ...
Answers:
1
JSON HTTP Client
answered
01-06-2021 05:28:36 -0400
I have tested a call with a cursor url parameter in Postman without any issues. But, when I add the cursor url in Denodo, I receive an error. URL: https://api.mypurecloud.com/api/v2/analytics/conversations/details/jobs/##################/results?curso...
Answers:
5
Connecting to Census data using the API and can't flatten multiple levels of json arrays
answered
28-05-2021 13:34:32 -0400
I am using Denodo Express 8.0. I am trying to connect to the census api, and I'm able to create a base view using the url (https://api.census.gov/data/2018/acs/acs1?get=NAME,group(B01001) and a denodo json data source. But when I try to flatten it, i...
Answers:
3