# Data Converter — JSON, CSV & XML (`accurate_pouch/data-converter`) Actor
Convert between JSON, CSV, and XML formats in bulk. JSON to CSV, CSV to JSON, JSON to XML, XML to JSON. Handles quoted fields, nested objects. $0.003/conversion.
- **URL**: https://apify.com/accurate\_pouch/data-converter.md
- **Developed by:** [Manchitt Sanan](https://apify.com/accurate_pouch) (community)
- **Categories:** Developer tools
- **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet
## Pricing
$4.00 / 1,000 conversions
This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.
Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event
## What's an Apify Actor?
Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases.
In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours,
and optionally produces a well-defined JSON output, datasets with results, or files in key-value store.
In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server.
Actors are written with capital "A".
## How to integrate an Actor?
If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.
The best way to integrate Actors is as follows.
In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js.md):
```bash
npm install apify-client
```
In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.md):
```bash
pip install apify-client
```
In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md):
````bash
# MacOS / Linux
curl -fsSL https://apify.com/install-cli.sh | bash
# Windows
irm https://apify.com/install-cli.ps1 | iex
```bash
In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/platform/integrations/mcp.md).
If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md).
For usage examples, see the [API](#api) section below.
For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt).
# README
## Data Converter -- JSON, CSV & XML
Convert between JSON, CSV, and XML formats in bulk. Handles quoted fields, commas in values, nested objects. No external dependencies -- pure Node.js implementation.
### Quick Start
```json
{
"items": [
{
"data": "[{\"name\":\"Alice\",\"age\":30,\"city\":\"New York\"},{\"name\":\"Bob\",\"age\":25,\"city\":\"London\"}]",
"operation": "json-to-csv"
},
{
"data": "name,age,city\nAlice,30,New York\nBob,25,London",
"operation": "csv-to-json"
},
{
"data": "[{\"name\":\"Alice\",\"age\":30}]",
"operation": "json-to-xml",
"options": { "rootElement": "people", "itemElement": "person" }
},
{
"data": "Alice30",
"operation": "xml-to-json"
}
]
}
````
### Input Reference
| Field | Type | Required | Description |
|-------|------|----------|-------------|
| `items` | array | Yes | Array of conversion items |
| `items[].data` | string | Yes | Data string to convert (or URL to fetch from) |
| `items[].operation` | string | Yes | One of: `json-to-csv`, `csv-to-json`, `json-to-xml`, `xml-to-json` |
| `items[].options` | object | No | Optional conversion settings |
#### Options
| Option | Type | Default | Description |
|--------|------|---------|-------------|
| `delimiter` | string | `,` | CSV delimiter character |
| `rootElement` | string | `root` | XML root element name |
| `itemElement` | string | `item` | XML item element name |
| `includeHeader` | boolean | `true` | Include header row in CSV output |
#### Operations
- **json-to-csv**: Converts a JSON array of objects to CSV format. Flattens nested objects with dot notation.
- **csv-to-json**: Parses CSV (with proper quoted field handling) into a JSON array of objects.
- **json-to-xml**: Converts a JSON array of objects to XML with configurable element names.
- **xml-to-json**: Parses simple XML into a JSON array of objects.
### Output Example
```json
{
"index": 0,
"operation": "json-to-csv",
"input": "[{\"name\":\"Alice\",\"age\":30}]",
"output": "name,age\nAlice,30",
"success": true
}
```
#### Error Output
```json
{
"index": 1,
"operation": "csv-to-json",
"input": "",
"output": null,
"success": false,
"error": "Data content is required"
}
```
### Pricing
- **$0.003 per conversion** (per item in the input array)
- No free tier
- Pay-per-event billing via Apify platform
### Related Tools by manchittlab
- [Markdown & HTML Converter](https://apify.com/manchittlab/markdown-html) -- Bidirectional Markdown/HTML conversion
- [All Tools](https://apify.com/manchittlab) -- Browse all tools by manchittlab
# Actor input Schema
## `items` (type: `array`):
Array of items to convert. Each item needs `data` (string content or URL), `operation`, and optional `options`.
## Actor input object example
```json
{
"items": [
{
"data": "[{\"name\":\"Alice\",\"age\":30},{\"name\":\"Bob\",\"age\":25}]",
"operation": "json-to-csv"
}
]
}
```
# API
You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup.
## JavaScript example
```javascript
import { ApifyClient } from 'apify-client';
// Initialize the ApifyClient with your Apify API token
// Replace the '' with your token
const client = new ApifyClient({
token: '',
});
// Prepare Actor input
const input = {
"items": [
{
"data": "[{\"name\":\"Alice\",\"age\":30},{\"name\":\"Bob\",\"age\":25}]",
"operation": "json-to-csv"
}
]
};
// Run the Actor and wait for it to finish
const run = await client.actor("accurate_pouch/data-converter").call(input);
// Fetch and print Actor results from the run's dataset (if any)
console.log('Results from dataset');
console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
items.forEach((item) => {
console.dir(item);
});
// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs
```
## Python example
```python
from apify_client import ApifyClient
# Initialize the ApifyClient with your Apify API token
# Replace '' with your token.
client = ApifyClient("")
# Prepare the Actor input
run_input = { "items": [{
"data": "[{\"name\":\"Alice\",\"age\":30},{\"name\":\"Bob\",\"age\":25}]",
"operation": "json-to-csv",
}] }
# Run the Actor and wait for it to finish
run = client.actor("accurate_pouch/data-converter").call(run_input=run_input)
# Fetch and print Actor results from the run's dataset (if there are any)
print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"])
for item in client.dataset(run["defaultDatasetId"]).iterate_items():
print(item)
# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start
```
## CLI example
```bash
echo '{
"items": [
{
"data": "[{\\"name\\":\\"Alice\\",\\"age\\":30},{\\"name\\":\\"Bob\\",\\"age\\":25}]",
"operation": "json-to-csv"
}
]
}' |
apify call accurate_pouch/data-converter --silent --output-dataset
```
## MCP server setup
```json
{
"mcpServers": {
"apify": {
"command": "npx",
"args": [
"mcp-remote",
"https://mcp.apify.com/?tools=accurate_pouch/data-converter",
"--header",
"Authorization: Bearer "
]
}
}
}
```
## OpenAPI specification
```json
{
"openapi": "3.0.1",
"info": {
"title": "Data Converter — JSON, CSV & XML",
"description": "Convert between JSON, CSV, and XML formats in bulk. JSON to CSV, CSV to JSON, JSON to XML, XML to JSON. Handles quoted fields, nested objects. $0.003/conversion.",
"version": "0.1",
"x-build-id": "WsCKxS5gEU3wufZMK"
},
"servers": [
{
"url": "https://api.apify.com/v2"
}
],
"paths": {
"/acts/accurate_pouch~data-converter/run-sync-get-dataset-items": {
"post": {
"operationId": "run-sync-get-dataset-items-accurate_pouch-data-converter",
"x-openai-isConsequential": false,
"summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.",
"tags": [
"Run Actor"
],
"requestBody": {
"required": true,
"content": {
"application/json": {
"schema": {
"$ref": "#/components/schemas/inputSchema"
}
}
}
},
"parameters": [
{
"name": "token",
"in": "query",
"required": true,
"schema": {
"type": "string"
},
"description": "Enter your Apify token here"
}
],
"responses": {
"200": {
"description": "OK"
}
}
}
},
"/acts/accurate_pouch~data-converter/runs": {
"post": {
"operationId": "runs-sync-accurate_pouch-data-converter",
"x-openai-isConsequential": false,
"summary": "Executes an Actor and returns information about the initiated run in response.",
"tags": [
"Run Actor"
],
"requestBody": {
"required": true,
"content": {
"application/json": {
"schema": {
"$ref": "#/components/schemas/inputSchema"
}
}
}
},
"parameters": [
{
"name": "token",
"in": "query",
"required": true,
"schema": {
"type": "string"
},
"description": "Enter your Apify token here"
}
],
"responses": {
"200": {
"description": "OK",
"content": {
"application/json": {
"schema": {
"$ref": "#/components/schemas/runsResponseSchema"
}
}
}
}
}
}
},
"/acts/accurate_pouch~data-converter/run-sync": {
"post": {
"operationId": "run-sync-accurate_pouch-data-converter",
"x-openai-isConsequential": false,
"summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.",
"tags": [
"Run Actor"
],
"requestBody": {
"required": true,
"content": {
"application/json": {
"schema": {
"$ref": "#/components/schemas/inputSchema"
}
}
}
},
"parameters": [
{
"name": "token",
"in": "query",
"required": true,
"schema": {
"type": "string"
},
"description": "Enter your Apify token here"
}
],
"responses": {
"200": {
"description": "OK"
}
}
}
}
},
"components": {
"schemas": {
"inputSchema": {
"type": "object",
"required": [
"items"
],
"properties": {
"items": {
"title": "Items",
"type": "array",
"description": "Array of items to convert. Each item needs `data` (string content or URL), `operation`, and optional `options`.",
"items": {
"type": "object",
"properties": {
"data": {
"title": "Data",
"type": "string",
"description": "The data string to convert, or a URL to fetch data from"
},
"operation": {
"title": "Operation",
"type": "string",
"enum": [
"json-to-csv",
"csv-to-json",
"json-to-xml",
"xml-to-json"
],
"description": "Conversion operation"
},
"options": {
"title": "Options",
"type": "object",
"description": "Optional conversion settings",
"properties": {
"delimiter": {
"title": "Delimiter",
"type": "string",
"description": "CSV delimiter character (default: comma)"
},
"rootElement": {
"title": "Root Element",
"type": "string",
"description": "XML root element name (default: root)"
},
"itemElement": {
"title": "Item Element",
"type": "string",
"description": "XML item element name (default: item)"
},
"includeHeader": {
"title": "Include Header",
"type": "boolean",
"description": "Include header row in CSV output (default: true)"
}
}
}
},
"required": [
"data",
"operation"
]
}
}
}
},
"runsResponseSchema": {
"type": "object",
"properties": {
"data": {
"type": "object",
"properties": {
"id": {
"type": "string"
},
"actId": {
"type": "string"
},
"userId": {
"type": "string"
},
"startedAt": {
"type": "string",
"format": "date-time",
"example": "2025-01-08T00:00:00.000Z"
},
"finishedAt": {
"type": "string",
"format": "date-time",
"example": "2025-01-08T00:00:00.000Z"
},
"status": {
"type": "string",
"example": "READY"
},
"meta": {
"type": "object",
"properties": {
"origin": {
"type": "string",
"example": "API"
},
"userAgent": {
"type": "string"
}
}
},
"stats": {
"type": "object",
"properties": {
"inputBodyLen": {
"type": "integer",
"example": 2000
},
"rebootCount": {
"type": "integer",
"example": 0
},
"restartCount": {
"type": "integer",
"example": 0
},
"resurrectCount": {
"type": "integer",
"example": 0
},
"computeUnits": {
"type": "integer",
"example": 0
}
}
},
"options": {
"type": "object",
"properties": {
"build": {
"type": "string",
"example": "latest"
},
"timeoutSecs": {
"type": "integer",
"example": 300
},
"memoryMbytes": {
"type": "integer",
"example": 1024
},
"diskMbytes": {
"type": "integer",
"example": 2048
}
}
},
"buildId": {
"type": "string"
},
"defaultKeyValueStoreId": {
"type": "string"
},
"defaultDatasetId": {
"type": "string"
},
"defaultRequestQueueId": {
"type": "string"
},
"buildNumber": {
"type": "string",
"example": "1.0.0"
},
"containerUrl": {
"type": "string"
},
"usage": {
"type": "object",
"properties": {
"ACTOR_COMPUTE_UNITS": {
"type": "integer",
"example": 0
},
"DATASET_READS": {
"type": "integer",
"example": 0
},
"DATASET_WRITES": {
"type": "integer",
"example": 0
},
"KEY_VALUE_STORE_READS": {
"type": "integer",
"example": 0
},
"KEY_VALUE_STORE_WRITES": {
"type": "integer",
"example": 1
},
"KEY_VALUE_STORE_LISTS": {
"type": "integer",
"example": 0
},
"REQUEST_QUEUE_READS": {
"type": "integer",
"example": 0
},
"REQUEST_QUEUE_WRITES": {
"type": "integer",
"example": 0
},
"DATA_TRANSFER_INTERNAL_GBYTES": {
"type": "integer",
"example": 0
},
"DATA_TRANSFER_EXTERNAL_GBYTES": {
"type": "integer",
"example": 0
},
"PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
"type": "integer",
"example": 0
},
"PROXY_SERPS": {
"type": "integer",
"example": 0
}
}
},
"usageTotalUsd": {
"type": "number",
"example": 0.00005
},
"usageUsd": {
"type": "object",
"properties": {
"ACTOR_COMPUTE_UNITS": {
"type": "integer",
"example": 0
},
"DATASET_READS": {
"type": "integer",
"example": 0
},
"DATASET_WRITES": {
"type": "integer",
"example": 0
},
"KEY_VALUE_STORE_READS": {
"type": "integer",
"example": 0
},
"KEY_VALUE_STORE_WRITES": {
"type": "number",
"example": 0.00005
},
"KEY_VALUE_STORE_LISTS": {
"type": "integer",
"example": 0
},
"REQUEST_QUEUE_READS": {
"type": "integer",
"example": 0
},
"REQUEST_QUEUE_WRITES": {
"type": "integer",
"example": 0
},
"DATA_TRANSFER_INTERNAL_GBYTES": {
"type": "integer",
"example": 0
},
"DATA_TRANSFER_EXTERNAL_GBYTES": {
"type": "integer",
"example": 0
},
"PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
"type": "integer",
"example": 0
},
"PROXY_SERPS": {
"type": "integer",
"example": 0
}
}
}
}
}
}
}
}
}
}
```