Dataset Flatten and Field Mapper avatar

Dataset Flatten and Field Mapper

Pricing

Pay per usage

Go to Apify Store
Dataset Flatten and Field Mapper

Dataset Flatten and Field Mapper

Flatten nested JSON, rename and drop fields, and coerce simple types in Apify datasets without writing transformation code.

Pricing

Pay per usage

Rating

0.0

(0)

Developer

Lau Kuan Ee

Lau Kuan Ee

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

8 days ago

Last modified

Categories

Share

Turn nested scraper output into export-ready Apify dataset rows without writing JavaScript or Python. Map dot paths, flatten nested objects, drop fields, and apply conservative type coercion in one bounded run.

Why this Actor

  • Works with an Apify dataset ID or inline records.
  • Keeps arrays intact, so a record never multiplies into surprise rows.
  • Runs no user-supplied code.
  • Continues after a record-level coercion error and emits a safe error row without the failed raw value.
  • Reads private datasets with the run's APIFY_TOKEN, which is never logged or stored.

Input example

{
"datasetId": "YOUR_DATASET_ID",
"mappings": [
{"from": "person.name", "to": "name"},
{"from": "person.age", "to": "age"}
],
"keepUnmapped": false,
"coerce": {"age": "number"},
"maxItems": 10000
}

When mappings are present, unmapped fields are dropped by default. Set keepUnmapped to true to retain them. Set flattenAll to recursively flatten objects using separator.

Supported coercions are string, number, boolean, and canonical json. Boolean parsing accepts common values such as true, false, yes, no, 1, and 0.

Output

The default dataset receives one row per input record. A failed coercion creates a row like:

{
"recordType": "error",
"index": 4,
"errors": [{"field": "age", "target": "number", "message": "string is not a number"}]
}

OUTPUT.json reports loaded, emitted, failed, dropped-field, and coercion-error counts. Runs are capped at 100,000 input records.

Pricing proposal

$0.50 per 1,000 emitted rows plus Apify's required minimum Actor-start event. Final pricing is staged separately in the Apify Console.