JSON Data source

Create the JSON Data source
The first step is to create the data source and provide basic auth credentials. Note that basic auth credentials are optional and you can provide a bearer token if that is your means of authenticating against the API 
Creating a JSON data source
Writing queries
In the query editor, select the JSON data source created above and enter the query parameters. The query parameters use the YAML syntax. For E.g.
Providing HTTP Options
The following HTTP options are used for sending a query
The URL parameter is the only required parameter
url - This is the URL where the RESTful API is exposed
method - the HTTP method to use (default: get)
headers - a dictionary of headers to send with the request
auth - basic auth username/password (should be passed as an array: [username, password])
params - a dictionary of query string parameters to add to the URL
data - a dictionary of values to use as the request body
json - same as data except that it’s being converted to JSON
Filtering response data: path and fields
The response data can be filtered by specifying the path and fields parameters. The path filter allows accessing attributes within the response, for e.g. if a key foo in the response contains rows of objects you want to access, specifying path foo will convert each of the objects into rows. 
In the example below, we are then selecting fields volumeInfo.authors, volumeInfo.title, volumeInfo.publisher and accessInfo.webReaderLink
1
url: https://www.googleapis.com/books/v1/volumes?q=isbn:0747532699
2
path: items
3
fields: ["volumeInfo.authors","volumeInfo.title","volumeInfo.publisher","accessInfo.webReaderLink"]
Copied!
The resulting data from the above query is a nicely formatted table that can be searched in LOGIQ or made available as a widget in a dashboard

DATA SOURCES - Previous

API

RSS

Last modified 9d ago

Export as PDF

Copy link

Edit on GitHub

Contents

Create the JSON Data source

Writing queries

Providing HTTP Options

Filtering response data: path and fields