Nested JSON Fields

When importing JSON data, some values may be stored inside nested objects instead of appearing at the top level. Simple Tables lets you reference those nested values and expose them as table columns.

If nested fields are detected during import, you can add them later from the Columns tab by creating a new column and entering the nested field path.

How it works

Nested fields are referenced using dot-separated paths. For example:

[
  {
    "user": {
      "name": "Alice",
      "email": "alice@example.com"
    },
    "order": {
      "id": 123,
      "total": 99.99
    }
  },
  {
    "user": {
      "name": "Bob",
      "email": "bob@example.com"
    },
    "order": {
      "id": 124,
      "total": 149.5
    }
  }
]

From this structure, you can create columns such as:

user.name
user.email
order.id
order.total

Use case: Customer profile extraction

Customer Insights Team

Shinkansen Systems — CRM Analytics

Context and challenge:
The CRM team works with JSON profile data where useful information such as contact details, status, and account metadata is stored inside nested objects.

Solution:
They add columns using paths like user.name, user.email, and status.level so those values can appear directly in the table.

Impact:
Teams can work with structured JSON data directly in Confluence without flattening the file in advance or writing extra transformation scripts.

Tip
Dot paths also work with arrays. For example, use items.0.price to access the price of the first item in an array.

Nested field support is especially useful for customer profiles, product catalogs, API responses, and other structured JSON datasets.

Want to try it in your site? InstallSimple Tables for Confluence from the Atlassian Marketplace.