Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.databar.ai/llms.txt

Use this file to discover all available pages before exploring further.

The JSON Expander extracts individual values from JSON columns and places them into their own columns, turning nested API response data into structured, usable table fields.
JSON Expander is a transformation — it does not consume any credits.

​
How it works

Many enrichment APIs return complex JSON objects. The JSON Expander lets you visually browse those objects and select exactly which fields to extract — without writing any code.
1

Click on a JSON cell

Click any cell that contains JSON data in your table.
2

Browse in the sidebar panel

The JSON Expander opens in the right-side panel, keeping your table visible while you explore the JSON structure.
3

Select fields to extract

Check the fields you want. Each selected field becomes a new column in your table.
JSON Expander panel open in the right sidebar with field selection

​
Key capabilities

Nested JSON mapping

Map columns directly to nested JSON values without expanding into intermediate columns first.

Export JSON as column

Extract a full nested JSON object into a separate column — not just primitive text or number fields.

Parallel processing

JSON Expander runs up to 6x faster than before. Values are processed in parallel for large tables.

Side panel view

The expander lives in the right-side panel so you can keep your table context visible while working.

​
When to use JSON Expander vs. JQ formulas

ScenarioRecommended tool
Quickly extract a few top-level or nested fieldsJSON Expander
Filter arrays, count items, or build custom structuresJQ formulas
Non-technical users who prefer a visual interfaceJSON Expander
Complex transformations on deeply nested dataJQ formulas

JQ formulas

Use JQ expressions for advanced JSON manipulation.

Tables overview

Learn how tables work in Databar.