Skip to main content

Transform JSON to CSV

Learning goals​

Compose parsing, projection and format conversion Beads.

Quick reference: Level 2; starter; output type csv; estimated cost: none.

Architecture​

Text alternative: The graph contains FlowBeads/input, JSON/JSON Parse, JSON/JSONata, Conversion/JSONToCSVNode, FlowBeads/output. It accepts public input and returns a public result.

Prerequisites​

None.

Connections​

None.

Secrets​

No paid secret is required.

Build and run​

  1. Run the fixture.
  2. Inspect the JSONata projection.
  3. Download or copy the CSV output.

Use this fixture in the Test panel:

People collection
{"items":[{"name":"Ada","role":"Engineer"},{"name":"Linus","role":"Maintainer"}]}

Expected result​

  • CSV contains a header
  • CSV contains two records

Open the persisted run and verify the node timeline. Browser sinks appear in the Inspector; public output appears in the run result when enabled.

Side effects and cost​

This Braid has no external side effect.

Cost: none. DataBraid stores summaries and structured errors, not secret values.

Extensions​

  • Change the fixture and compare the node-level timeline.
  • Add a Data Probe before the final output.
  • Save a known-good fixture for regression testing.