Dataset JSON Flattener
Pricing
Pay per usage
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
Maintained by CommunityActor 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
nullunchanged - 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.namekey may be overwritten by a nesteduser.namepath. - The Actor uses Apify storage only and does not call external APIs.