Q&A BY TAG 'JSON Data Source'

You must sign in to ask a question. If you do not have an account, you can register here

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 JSON Data Source JSON Datasource Dynamic Datasources

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 Data Source HTTP client

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

JSON Data Source

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

post Json JSON Data Source

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 source json JSON JSON Data Source Json

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

JSON Data Source API HTTP client

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

census JSON Data Source

JSON Data Sources Pagination Field - Help Text is Inconsistent with Validation Rules. -- Is it mandatory or not?
answered 21-12-2020 10:08:18 -0500

For JSON data sources retrieved via HTTP, the help text for "Parameter in URL for page size" and "Page size" for token continuation pagination indicates that they are "(Optional)", but when omitted, I can't save because a field validation tool tip pops...

Answers: 1

design studio UI issue JSON Data Source HTTP

Flatten view
answered 29-09-2020 16:27:53 -0400

Hi Team, I have created one view from Json data source.In this view there are multiple columns and 4-5 coloumns are itself a collection of array.And Inside these element array there are elements which are itself a collection of array. I want to flatt...

Answers: 1

JSON Data Source FLATTEN

How to set Dynamic value in Json Request Header for OAuth 2.0 Client Credential Value
answered 20-08-2020 08:21:05 -0400

Hi Team, I am trying to do JSON PoC with OAuth Authentication for below scanarios. 1) Request to Get Access Token using OAuth2.0 client credential Authentication 2) Pass this acces token dynamically to client application as a bearer token to get sess...

Answers: 1

JSON Data Source