Help Centre › Functions & Formulas
Flatten a nested JSON object into dot-notation keys.
Add it to a process
In the process designer, open the Add step tab. Find Flatten JSON under Data › JSON, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| JSON data | Yes | The data variable or JSON string to process |
| Variable | Yes | Variable name to store the result Default: data. |
| Separator | No | The delimiter to split or join on Default: .. |
What it gives back
{data}– Flattened JSON
See all Data steps.
Errors
| Error | Description |
|---|---|
| Invalid JSON | The data is not valid JSON |
Tips
- Useful for transforming nested API responses into flat rows for spreadsheets or databases
- Change the separator to use underscores or other characters if dots conflict with your data