Skip to main content

How to Load Data from a JSON File into Instadeq

Create new "JSON File" card

Create a new empty card by selecting the Add Card + button that's above and below each card in a deck, then from the available options select JSON File.

Settings overview

Persistent

Ask to store loaded files into persistent storage to be used when loading and to notify of new values when new files are loaded.

Channel

The name of the channel to store the files, on creation each card gets its own unique channel name, you can change it by editing it and selecting the "Apply" button.

Load Last Count

How many files to load, by default it will load the last one.

Detect Table and Sheet Format

Detect common JSON table/sheet formats and convert them directly into a table or sheet accordingly

Load file via drag & drop

Drag a file and drop it into the card's drop area to load it, the drop area should highlight while dragging.

Load file via file picker

Alternatively you can click the drop area to open a file picker and select the file there.

Persistent overview: Store in channel?

Persistent cards will ask you if you want to store the data into a channel.

Data stored in a channel will load automatically when a deck or dashboard that depends on cards configured with the same channel name is loaded, they will also get new values when you store new files, this will make dashboards, charts and decks reflect the latest data as soon as it is stored.

JSON data collapse & navigation

You can collapse/expand sections by selecting the collapse/expand icon above the keys in records or indexes in lists.

You can see more fields in records or items in lists by selecting the previous/next icons to the right of the collapse/expand icons.

Manually convert JSON data into a table

If auto detection of tables doesn't work for your case you can do it manually by dragging fields from the JSON data into a Select card and changing the index value in every input field from the index to a range (0:∞).