# JSON

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'.

![](/files/-M4oMx1vuumKACr0xqof)

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'

![](/files/-M4oN7OgwNBdFir-_0io)

## 2. Select File.

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

### 2.1 Local File

![](/files/-M4oN7OihiZ3zwzxraj-)

### 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.

![](/files/-M4oN7OkmsJ6Fw9qJF6e)

## 3. JSON Tree

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

![](/files/-M4oN7OmlelhRBipl4LP)

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.

You can configure the following properties for the JSON Tree.

* Max Tree Depth: How deep you want to show the tree structure. If your JSON tree structure is deep and you want to see the deeper levels, increase this. If you increase this, it may take time to load the tree.
* Max List Size: How many list items to show in the tree. If you want to see more list items in the list data type in your JSON tree, increase this. If you increase this, it may take time to load the tree.

## 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

* [Analyzing JSON data by taking advantage of what makes it JSON in R](https://blog.exploratory.io/analyzing-json-data-by-taking-advantage-of-the-structure-in-r-1e0508e30117)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.exploratory.io/data_import/file-data/json.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.