Dataset JSON Flattener avatar

Dataset JSON Flattener

Pricing

Pay per usage

Go to Apify Store
Dataset JSON Flattener

Dataset JSON Flattener

Flatten nested JSON objects into flat key/value rows using configurable dot notation, from inline JSON or an Apify Dataset.

Pricing

Pay per usage

Rating

0.0

(0)

Developer

Starshape Tools

Starshape Tools

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

2 days ago

Last modified

Categories

Share

Flatten nested JSON objects into flat key/value rows and write them to the run's default Apify Dataset.

The Actor has no external API or credential requirements. Its default inline input runs immediately and produces a non-empty Dataset.

What it does

  • Reads rows from inline JSON or an optional Apify Dataset
  • Recursively flattens nested plain objects
  • Uses . as the default separator, with a configurable alternative
  • Leaves primitives, arrays, and null unchanged
  • Keeps empty nested objects as empty objects
  • Writes every flattened row to the default Dataset

Example

Input row:

{
"id": "A001",
"user": {
"name": "Alice",
"address": {
"city": "Tokyo"
}
}
}

Output row:

{
"id": "A001",
"user.name": "Alice",
"user.address.city": "Tokyo"
}

Input sources

Run with the default input to flatten the two included inline rows without authentication. To process an existing Dataset instead, select it in Source Dataset; that picker requests READ permission only.

When a source Dataset is selected, it takes precedence over inline rows.

Custom separator

Set Key separator to another non-empty string, such as _, to produce keys like user_address_city.

Notes

  • Arrays are retained as arrays and are not flattened.
  • Key collisions are resolved in traversal order. For example, an existing user.name key may be overwritten by a nested user.name path.
  • The Actor uses Apify storage only and does not call external APIs.