JSON Data Setup

Example:

[
    {
        "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:

{
    "make": "Ford",
    "model": "Mustang",
    "color": "Black",
    "year": 2016
}

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

[
    {
        "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.