Q&A BY TAG 'JSON Datasource'

I have a JSON data source which first needs an authentication call (HTTP POST), that returns the session cookie to be used in consecutive (HTTP GET) calls. Unfortunately the first POST call doesn't return any HTTP body, so I can't create a base view. ...

HTTP client JSON Datasource

I want to make a JSON Data Source from this URL: https://data.cdc.gov/resource/52kb-ccu2.json This URL supports filtering by adding query strings to the end of the URL. These simple query string filters are optional. Here are 2 such examples? https://...

Interpolation Variables JSON Data Source JSON Datasource

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

I am using a REST Webservice as a Datasource. To get the data, the Webservice GET function takes three Parameters "accountingClientId", "customerId" and "invoiceId". The first two are mandatory, the third is optional. I managed to do this by using ^Exe...

REST Parameter REST Webservice JSON Datasource DataSource

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

I am trying to use SSRS to connect to Denodo as a data source. The ODBC connection takes far too long to establish the connection - longer than it takes Denodo to return to data and longer than SSRS takes to render the report by an order of magnitude. ...

SSRS JSON Datasource

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

Hello, Is there a way to create interpolation variable and make it as an optional for GET Request on HTTP JSON datasource

JSON Datasource