Tools HTTP API

Quick start

curl -X POST https://data-migration-tools.com/api/v1/tools/convert \
  -H "Content-Type: application/json" \
  -d '{"from":"csv","to":"json","input":"id,name\n1,Ada\n2,Grace"}'

{
  "ok": true,
  "output": {
    "text": "[\n  { \"id\": 1, \"name\": \"Ada\" },\n  { \"id\": 2, \"name\": \"Grace\" }\n]",
    "rows": 2,
    "steps": ["csvToJson"]
  },
  "meta": { "rows": 2, "format": "json" }
}

Endpoints

Every endpoint below accepts POST with a JSON body and returns a ToolResult. Click an endpoint to see its full parameter reference.

/api/v1/tools/convert

Convert text between CSV, JSON, XML, YAML, and SQL by pivoting through JSON when no direct converter exists.

Returns: The converted text, the row count from the last step that reported one, and the converter chain that ran.

Parameters

Examples

curl -X POST https://data-migration-tools.com/api/v1/tools/convert \
  -H "Content-Type: application/json" \
  -d '{"from":"csv","to":"json","input":"id,name\n1,Ada\n2,Grace"}'

CSV to PostgreSQL INSERT statements.

curl -X POST https://data-migration-tools.com/api/v1/tools/convert \
  -H "Content-Type: application/json" \
  -d '{"from":"csv","to":"sql","input":"id,name\n1,Ada","dialect":"postgres","table":"users"}'

JSON to XML with a custom root element.

curl -X POST https://data-migration-tools.com/api/v1/tools/convert \
  -H "Content-Type: application/json" \
  -d '{"from":"json","to":"xml","input":"{\"user\":{\"name\":\"Ada\"}}","rootElement":"user"}'

/api/v1/tools/base64

Encode a string to Base64 or decode Base64 back to text. Supports URL-safe (RFC 4648 §5) and PEM-style line-wrap on encode.

Returns: The encoded or decoded Base64 string, plus the byte count of the input.

Parameters

Examples

curl -X POST https://data-migration-tools.com/api/v1/tools/base64 \
  -H "Content-Type: application/json" \
  -d '{"action":"encode","input":"hello world","urlSafe":true}'

PEM-style wrapped output.

curl -X POST https://data-migration-tools.com/api/v1/tools/base64 \
  -H "Content-Type: application/json" \
  -d '{"action":"encode","input":"a long payload...","lineWrap":true,"lineWrapWidth":64}'

/api/v1/tools/jwt-decode

Decode a JWT header and payload, describe registered claims, and report expiry status. Optionally verify an HS256 signature.

Returns: The decoded header and payload, registered-claim descriptions, expiry status, and (when verified) the signature check result.

Parameters

Examples

curl -X POST https://data-migration-tools.com/api/v1/tools/jwt-decode \
  -H "Content-Type: application/json" \
  -d '{"token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkFkYSIsImlhdCI6MTUxNjIzOTAyMn0.SflKxwRJSMeKKF2QT4fwpMeJf36POk6yJV_adQssw5c"}'

Verify an HS256 signature against a shared secret.

curl -X POST https://data-migration-tools.com/api/v1/tools/jwt-decode \
  -H "Content-Type: application/json" \
  -d '{"token":"eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiIxIn0.SflKxwRJSMeKKF2QT4fwpMeJf36POk6yJV_adQssw5c","verify":{"secret":"shh"}}'

/api/v1/tools/cron

Parse a 5-field cron expression (or @-macro), describe it in English, and compute the next N run times.

Returns: A plain-English description of the schedule and the next run timestamps.

Parameters

Examples

curl -X POST https://data-migration-tools.com/api/v1/tools/cron \
  -H "Content-Type: application/json" \
  -d '{"expression":"0 9 * * 1-5","runs":5}'

Next runs from a fixed reference time.

curl -X POST https://data-migration-tools.com/api/v1/tools/cron \
  -H "Content-Type: application/json" \
  -d '{"expression":"@daily","from":"2026-01-01T00:00:00Z"}'

/api/v1/tools/regex-test

Test a JavaScript regex against a subject string. Returns all matches (capped at 10,000) with groups, named groups, and timing.

Returns: The match count, an array of matches with captured and named groups, and the elapsed time in milliseconds.

Parameters

Examples

curl -X POST https://data-migration-tools.com/api/v1/tools/regex-test \
  -H "Content-Type: application/json" \
  -d '{"pattern":"\\d+","flags":"g","input":"a1 b22 c333"}'

/api/v1/tools/pii-scan

Scan CSV, JSON, or plain text for PII (emails, phones, SSNs, cards, IPs, IBANs, passports, URLs, names) with GDPR/CCPA risk flags.

Returns: A roll-up of findings per entity/column, plus optionally the per-span detail array when detailed is true.

Parameters

Examples

curl -X POST https://data-migration-tools.com/api/v1/tools/pii-scan \
  -H "Content-Type: application/json" \
  -d '{"input":"contact: ada@example.com, +1 555-123-4567","format":"text"}'

CSV scan with per-span detail.

curl -X POST https://data-migration-tools.com/api/v1/tools/pii-scan \
  -H "Content-Type: application/json" \
  -d '{"input":"email,phone\nada@example.com,+15551234567","format":"csv","detailed":true}'

/api/v1/tools/pii-mask

Replace PII with shape-valid, deterministic fake values so masked exports still join and load. The real→fake mapping is returned separately.

Returns: The masked output, the real→fake entity mapping, and a count of masked values per entity.

Parameters

Examples

curl -X POST https://data-migration-tools.com/api/v1/tools/pii-mask \
  -H "Content-Type: application/json" \
  -d '{"input":"email,phone\nada@example.com,+15551234567","format":"csv","seed":"run-42"}'

/api/v1/tools/csv-validate

Validate CSV structure: duplicate headers, ragged rows, type inference, and per-column null/unique stats.

Returns: A validity flag, a list of structural issues, and per-column statistics (type, nulls, unique count).

Parameters

Examples

curl -X POST https://data-migration-tools.com/api/v1/tools/csv-validate \
  -H "Content-Type: application/json" \
  -d '{"input":"id,name\n1,Ada\n2,Grace\n3,"}'

/api/v1/tools/data-clean

Trim whitespace, drop empty rows and columns, normalize line endings, and rename duplicate headers in a CSV.

Returns: The cleaned CSV text and a summary of what was changed.

Parameters

Examples

curl -X POST https://data-migration-tools.com/api/v1/tools/data-clean \
  -H "Content-Type: application/json" \
  -d '{"input":"id,name\n1,Ada\n1,Ada\n2,"}'

Rename the duplicate header.

curl -X POST https://data-migration-tools.com/api/v1/tools/data-clean \
  -H "Content-Type: application/json" \
  -d '{"input":"id,id\n1,2","options":{"deduplicateHeaders":true}}'

/api/v1/tools/schema-map

Suggest field mappings between a source and target schema by name and type similarity.

Returns: An array of matches per source field: the target field, a 0-1 score, and the match method (exact/fuzzy/skip).

Parameters

Examples

curl -X POST https://data-migration-tools.com/api/v1/tools/schema-map \
  -H "Content-Type: application/json" \
  -d '{"sourceFields":[{"name":"email","type":"string"},{"name":"phone","type":"string"}],"targetFields":[{"name":"email_address","type":"text"},{"name":"mobile","type":"text"}]}'

/api/v1/tools/migration-validate

Reconcile source and target CSVs by a key column: matched count, only-in-source, only-in-target, and per-field diffs.

Returns: Matched/only-in-source/only-in-target counts, and a per-field diff of mismatched values.

Parameters

Examples

curl -X POST https://data-migration-tools.com/api/v1/tools/migration-validate \
  -H "Content-Type: application/json" \
  -d '{"source":"id,name\n1,Ada\n2,Grace","target":"id,name\n1,Ada\n3,Mary"}'

/api/v1/tools/vendor-evaluate

Score vendors against weighted criteria. Each category holds criteria scored 0-10 per vendor; the weighted sum is normalized to a 0-100 score with an A-F grade.

Returns: Per-vendor final score and grade, plus per-category averages for breakdown charts.

Parameters

Examples

curl -X POST https://data-migration-tools.com/api/v1/tools/vendor-evaluate \
  -H "Content-Type: application/json" \
  -d '{"vendors":[{"id":"v1","name":"Global IT"},{"id":"v2","name":"SaaS Co"}],"categories":[{"id":"security","name":"Security","weight":1.3,"criteria":[{"id":"enc","name":"Encryption","scores":{"v1":8,"v2":9}},{"id":"soc","name":"SOC 2","scores":{"v1":7,"v2":9}}]}]}'

/api/v1/tools/roi-calculate

Compute a 36-month cost-of-inaction vs migration NPV. Compares keeping the legacy stack (license + labor + data-error risk) against migrating to a new SaaS, with an overlap period and retained legacy cost.

Returns: Per-month cumulative cost arrays for legacy and migration curves, NPV of each, net savings NPV, breakeven month, and cost composition percentages.

Parameters

Examples

curl -X POST https://data-migration-tools.com/api/v1/tools/roi-calculate \
  -H "Content-Type: application/json" \
  -d '{"rev":5000000,"leg":4000,"hours":20,"rate":75,"err":1,"mig":25000,"newSaaS":1500,"dur":3,"growth":15,"eff":85}'

/api/v1/tools/data-profile

Profile CSV or JSON data: per-column type inference (Numeric/Date/Text/Mixed/Empty), unique and missing counts, and top 50 values.

Returns: Per-column metadata (type, unique count, missing count, top values) and the total row count.

Parameters

Examples

curl -X POST https://data-migration-tools.com/api/v1/tools/data-profile \
  -H "Content-Type: application/json" \
  -d '{"input":"id,name,email\n1,Ada,ada@example.com\n2,Grace,grace@example.com","format":"csv"}'

curl -X POST https://data-migration-tools.com/api/v1/tools/data-profile \
  -H "Content-Type: application/json" \
  -d '{"input":"[{\"id\":1,\"name\":\"Ada\"},{\"id\":2,\"name\":\"Grace\"}]","format":"json"}'

/api/v1/tools/helpdesk-evaluate

Rank 23 helpdesk plans against required features. Returns a match score (0-100), missing features, annual cost, and per-category coverage for each plan.

Returns: An array of scored plans (match score, missing features, annual cost, category scores) and the total count.

Parameters

Examples

Find plans that support email, generative drafts, and SSO.

curl -X POST https://data-migration-tools.com/api/v1/tools/helpdesk-evaluate \
  -H "Content-Type: application/json" \
  -d '{"filters":{"email":true,"ai_gen":true,"sec_sso":true},"teamSize":10,"sort":"match_desc"}'

/api/v1/tools/helpdesk-plan

Estimate a helpdesk migration timeline: split entities into API vs manual tasks, compute throughput based on platform rate limits, and assess risk.

Returns: Total/min/max duration in hours, a breakdown (foundation/core data/attachments), per-entity hours, the bottleneck platform, risk level, and API vs manual task lists.

Parameters

Examples

curl -X POST https://data-migration-tools.com/api/v1/tools/helpdesk-plan \
  -H "Content-Type: application/json" \
  -d '{"source":"zendesk","sourcePlan":"suite_growth","destination":"freshdesk","destPlan":"pro","selectedEntities":["tickets","users","organizations"],"volumes":{"tickets":50000,"users":10000},"avgAttachmentsPerTicket":2,"avgAttachmentSizeMB":0.5}'

Error codes

A failed request returns a non-2xx status with the same ToolResult shape. The code field is the stable way to branch on the failure reason.

Rate limiting & headers

Every response includes X-RateLimit-Limit, X-RateLimit-Remaining, X-RateLimit-Reset (Unix seconds), and X-Request-Id for log correlation. A 429 response also includes Retry-After (seconds until the window resets).

Limits & pricing

The API is free and runs on the Cloudflare Workers free tier. There is no paid subscription required to use it. The per-IP rate limit (30 req/min) and 2 MB body cap are the only ceilings. If you need higher limits for production use, contact us.