Public capability proof · synthetic data

Nested JSON in. Reconciled CSV out.

Four synthetic order records are flattened through six declarative mapping rules. The checked-in output preserves Unicode, escapes embedded commas, and accounts for every input row.

4 → 4input / output rows

6explicitly mapped columns

0unaccounted rows

6/6deterministic tests passing

Nested source record

{
  "order": {"id": "o-1004", "total": 8.75},
  "customer": {"name": "Smith, Alice"},
  "tags": ["gift", "follow-up"]
}

Declarative mapping

order.id      → order_id
customer.name → customer_name
order.total   → total_usd / decimal_2
tags          → tags / join_pipe

Generated UTF-8 CSV

order_id	customer_name	customer_email	total_usd	paid	tags
o-1001	Ada Lovelace	ada@example.com	19.50	true	new\|priority
o-1002	Bob Stone		0.00	false
o-1003	Chloë de Vries	chloe@example.com	125.00	true	renewal
o-1004	Smith, Alice	alice.smith@example.com	8.75	true	gift\|follow-up

Input JSON Mapping rules Output CSV Reconciliation Converter source Order for $15 on Contra →

The manifest records three SHA-256 checksums, two intentionally empty output cells, and zero unaccounted rows. This is owned synthetic portfolio work—not client data, a testimonial, or a revenue claim.