You can import both local and remote JSON File Data quickly.

1. Select JSON File Data Menu

Click '+' button next to 'Data Frames' and select 'Import File Data'.

If you import JSON File on your desktop or laptop, make sure Local tab is selected. If you import a JSON file from remote server like Amazon S3, Dropbox, etc or accessing REST APIs that return JSON data, make sure Remote tab is selected. Click 'JSON File'

2. Select File.

If you select local, file picker shows up so select a file to import.

2.1 Local File

2.2 Remote File

if you select remote, small dialog shows up so enter a URL for the file. Enter either json file URL or REST API endpoint URL that returns JSON as response.

3. JSON Tree

JSON Tree and Preview sections are same for both local and remote.

Select node on JSON Tree.

On the left hand side, you an see JSON Tree and you can select red table icon for importing data.

4. Column Selection

On top of input parameters, you can also use checkboxes on the preview table to include/exclude columns. if you uncheck the checkboxes on the columns, these columns are excluded when you save the data.

5. Preview and Import

Select red table node on the tree (or Click Get Data button) to see the data in JSON File (or REST API). If it looks ok, then you can click 'Import' to import the JSON data into Exploratory.

5. More details about JSON