A JSON Feed will parse target JSON data, and bring in a tabular dataset. The feed with be designated as a “JSON” feed in the data pipeline (example below).
Step 1: Base Configuration #
|Poll Interval (seconds)||This value determines how often the server will check the JSON data for updates.|
|Enable Server Subscription||If set, the server will subscribe to the feed, just as a client widget would. This means that the data and any resources that would otherwise be allocated “on-demand” for the first user to view a Visualization that leverages the data produced by this feed are allocated when the server is started and maintained as long as this feed is configured.|
Step 2: JSON Parser #
The JSON Parser step contains two panels:
- The JSON Path panel where you define how to parse the target JSON data.
- The JSON Data panel where you preview the results.
JSON Path #
The JSON Path panel uses Goessner’s JSON Path to select portions of the JSON you want to include in the resulting dataset. Detailed instructions for JSONPath syntax can be found here:
Goessner’s JSONPath Instructions
JSON Data #
The JSON Data panel allows you to preview the source JSON data, as well as the resulting JSON data after applying the JSON Path syntax. (Example shown below)
|Raw Data Tab||This tab shows the raw JSON data from the source file. Use this tab as a reference when writing the JSON Path selector.|
|JSON Path Results Tab||This tab shows the resulting JSON data after parsing it with the supplied JSON Path syntax. To update, press the “Test” button in the JSON Path panel, then toggle back and forth between “Raw” and “Results” to validate your JSON Path syntax.|
|Select Exposed Values Tab||This tab shows a list of all discovered attributes from the JSON Path Results. Any attributes in this list will be used in converting the data to a tabular format. By default, all attributes are included, and the “Include” column can be checked or unchecked to add or remove attributes from the list as desired. Additionally, the value in the “Label” column can be changed at the administrator’s discretion.|
|Download Raw||This button allows the administrator to save a copy of the raw data as a JSON file. The file will be downloaded directly to the local machine, similar to any other file that one would download from the browser.|
|Show As Tree||The “Show As Tree” option is an alternate way to visualize the JSON structure that allows for expanding and collapsing.|