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

Using JSON data source from file, when the root is array
answered 05-03-2017 04:48:34 -0500

Hi, I tried to use the JSON data source, when the root json type is array. Let's take for example a file containing the following data : [{"id" : 3, "name" : "xxx", "color" : "blue", "available" : false},{"id" : 13, "name" : "yyy", "color" : "green", ...

Answers: 2


Twitter tweets limiting
answered 25-10-2016 04:02:09 -0400

I am trying to get the tweets from twitter using below query https://api.twitter.com/1.1/search/tweets.json?q=@query&count=@count&since=@from_date&until=@to_date I have flattened the statuses field and created the view. For every api call i...

Answers: 1

REST API twitter search json

JSON Parsing in Denodo
answered 29-08-2016 11:09:31 -0400

Hi support Quick question about Json parsing. I know there are currently no native functions (please let me know if that is incorrect) for parsing json on the read, like you would have natively with HIve or Presto (using something like get_json_object...

Answers: 3


What ports does Denodo uses when connecting to JSON Data sources
answered 16-08-2016 12:32:19 -0400

Hi, I would like to know what ports does denodo internally uses to connect to JSON data sources? is there any place where I can check all the ports being used by denodo currently. I know denodo uses 80, 8080, 443 ports to connect to webservices. howev...

Answers: 1

connectivity JSON ports

JSON query with REST API exposed via Denodo
answered 27-05-2016 09:49:04 -0400

Hi, I have created an view in denodo and exposed the details as REST API. I want to query the API with JSON query. I know we can do it by dynamic URI parameters. Any help is appreciated. Thanks

Answers: 4


JSON Parsing within string fields
answered 24-02-2016 11:18:16 -0500

Hi, We are recently getting stood up with Denodo for our organization and I am trying to find native functions that will work for JSON parsing. This is a bit different than the "flatten" or other abstractions that you can do from VDP, but rather manip...

Answers: 3


When creating JSON source, how to save Session ID from an authentication and then use another URL for data ?
answered 26-11-2014 09:07:31 -0500

Hi, I am trying to create a JSON source in Denodo (and I've done it before). This particular external source has the following condition - "In order to access documents via the API, you must be logged in as an authenticated user. This is handled throu...

Answers: 3


JSON / Odata as Source
answered 24-10-2014 09:35:25 -0400

Hello, we are trying to consume data from a web service, that supports both JSON and XML results. We have the source imported as JSON, and can use variables in the URL just fine. The problem is we want to be a little more dynamic, and have the where ...

Answers: 1