# JSON Data Setup

![](https://3704152374-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FR2ujwbobyWgp6ePwLRdC%2Fuploads%2FPsMtBiXWBRf27CjpONgR%2FScreen%20Shot%202022-09-27%20at%2011.58.03%20AM.png?alt=media\&token=0a4e3939-db3e-4e94-8064-0a4a5e94155b)

## Example:

```json
[
    {
        "make": "Ford",
        "model": "Mustang",
        "color": "Black",
        "hp": 490
    },
    {
        "make": "Mazda",
        "model": "CX-30",
        "color": "Gray",
        "hp": 190
    },
    {
        "make": "Volvo",
        "model": "S60",
        "color": "Blue",
        "hp": 250
    }
]
```

## How to hide extra data

If you want to import a large amount of JSON data, but only want to show a few columns, you can configure the column settings to hide all undefined columns.

Let's say your data looks like this:

<pre class="language-json"><code class="lang-json">{
    "make": "Ford",
<strong>    "model": "Mustang",
</strong>    "color": "Black",
    "year": 2016
}
</code></pre>

But you only want to show data for "make" and "model"... You can set your column JSON like so:

```json
[
    {
        "id": "make",
        "type": "text",
        "order": 1
    },
    {
        "id": "model",
        "type": "text",
        "order": 2
    },
    {
        "id": "",
        "type": "hidden"        
    }
]
```

## Using table data in Bubble

If the JSON data isn't enough, and you need to access the data in a more bubble-friendly format, you can use the `Get column data` action in combination with the `data exported from action` field.

Let's say you want to display a list of values that have been entered in your table. You can set up an action to `Get column data` using the ID of the specified column. Then, for example, you can set the state of a group to `data exported from action` immediately after.