Flow.Documentation
ProfessionalTables

Column: JSON

4 steps± 3 minVideoVerified 22 Oct 2026
  1. Step 1 · Open your development environment
  2. Step 2 · Add a JSON column
  3. Step 3 · Fill in an object
  4. Step 4 · Valid JSON only

A JSON column stores a structured value in one cell: an object with fields, or a list. Handy for what differs per row, such as the parts of a repair or the raw answer from another system. For what you want to filter or sort on, ordinary columns are better.

Watch the whole guide as a video4 steps in one film
Step 1 / 4

Open your development environment

In the portal, under Environments, click Development, and there Open. Flow opens in a new tab and you are signed in straight away.

  1. Click Development
Open your development environment · Click Development
  1. Click Open ↗
Open your development environment · Click Open ↗
Step 2 / 4

Add a JSON column

Open the table, go to Columns, click ＋ Column and choose JSON under Type.

  1. Click the table ‘Repairs (JSON)’
Add a JSON column · Click the table ‘Repairs (JSON)’
  1. Click Columns
Add a JSON column · Click Columns
  1. Click ＋ Column
Add a JSON column · Click ＋ Column
  1. In Name, type parts
  2. In Type, choose JSON
Add a JSON column · In Name, type parts; In Type, choose JSON
Add a JSON column · The column parts, of type JSON.
  1. Click Save structure
Add a JSON column · Click Save structure
Add a JSON column · The notice Table saved.
Step 3 / 4

Fill in an object

Under Data you type the value as JSON: between curly braces, with names between double quotes. A workflow reads the fields back out, for example {{row.parts.valve}}.

  1. Click Data
Fill in an object · Click Data
  1. In repair, type Flat front tyre
  2. In parts, type {"inner_tube": 2, "valve": 1}
Fill in an object · In repair, type Flat front tyre; In parts, type {"inner_tube": 2, "valve": 1}
  1. Click Add
Fill in an object · Click Add
Fill in an object · The repair with its parts.
Step 4 / 4

Valid JSON only

If the text is not valid JSON, or not an object or list, Flow refuses the row. A common mistake: names without quotes.

  1. In repair, type Adjust the brakes
  2. In parts, type {brake_pads: 2}
Valid JSON only · In repair, type Adjust the brakes; In parts, type {brake_pads: 2}
  1. Click Add
Valid JSON only · Click Add
Valid JSON only · parts: Must be of type json.

This guide was carried out step by step on 22 Oct 2026 by an automated test on Flow (version 3e563176).