Data Transform Toolkit avatar

Data Transform Toolkit

Pricing

Pay per usage

Go to Apify Store
Data Transform Toolkit

Data Transform Toolkit

Transform data between JSON, CSV, and XML formats. Flatten, filter, sort, pick fields, compute stats, and validate JSON — all in one actor.

Pricing

Pay per usage

Rating

0.0

(0)

Developer

2x lazymac

2x lazymac

Maintained by Community

Actor stats

0

Bookmarked

1

Total users

0

Monthly active users

2 hours ago

Last modified

Categories

Share

Transform data between JSON, CSV, and XML formats. Flatten, filter, sort, pick fields, compute stats, and validate JSON -- all in one actor.

Operations

OperationDescription
json_to_csvConvert JSON array to CSV text
csv_to_jsonParse CSV text into JSON array
json_to_xmlConvert JSON to XML string
flattenFlatten nested object to dot-notation keys
unflattenRestore dot-notation keys to nested object
filterFilter array by query (supports >, <, ! prefixes)
pickPick specific fields from each object
sortSort array by a field (asc/desc)
statsCompute count, sum, mean, min, max, median for a numeric field
validateValidate a JSON string and return type/size

Input

FieldTypeRequiredDescription
operationstringYesOne of the operations listed above
datastringYesInput data (JSON string or raw CSV)
optionsobjectNoOperation-specific options (see below)

Options by Operation

  • json_to_csv / csv_to_json: { "delimiter": ";" }
  • json_to_xml: { "rootName": "data" }
  • filter: { "query": { "age": ">25", "status": "active" } }
  • pick: { "fields": ["name", "email"] }
  • sort: { "field": "age", "order": "desc" }
  • stats: { "field": "price" }

Example

{
"operation": "json_to_csv",
"data": "[{\"name\":\"Alice\",\"age\":30},{\"name\":\"Bob\",\"age\":25}]",
"options": { "delimiter": "," }
}

Output

Results are pushed to the default dataset. The output structure varies by operation.