Data Recipes

Learn how to handle real-world data scenarios using DataLensia's toolkit. Each recipe walks you through a specific task from start to finish.

🔄 Conversion Recipes

• Flatten Nested JSON: Convert hierarchical JSON into a flat, tabular structure for analysis or export.
• Convert JSON to SQL: Generate SQL INSERT statements from a JSON array to import data into relational databases.
• Convert JSON to YAML: Export JSON as human-readable YAML for config files, Kubernetes manifests, and more.
• Convert JSON to XML: Transform JSON data into well-formed XML for legacy systems and SOAP APIs.
• Working with NDJSON: Import and work with Newline-Delimited JSON for streaming data and log processing.
• Generate TypeScript Types: Automatically infer TypeScript interfaces from any JSON payload.

🛠️ Transformation Recipes

• Map API Responses: Normalize inconsistent third-party API data into a clean, consistent format.
• Custom Transform Scripts: Use JavaScript in the Transform Builder to handle complex transformation logic.
• Build a Transform Pipeline: Create multi-step data transformation workflows with rename, reshape, and enrichment operations.

✅ Validation & Analysis

• Validate Large Datasets: Strategies for validating and repairing JSON files over 50MB.
• Fix Invalid JSON with the Validator: Pinpoint exact syntax errors with line/column positions and intelligent fix suggestions.
• Generate a JSON Schema: Automatically infer a JSON Schema from sample data for validation and documentation.
• Explore & Filter Data: Browse, search, filter, and export subsets of large JSON arrays.
• Compare JSON Files: Visually diff two JSON structures to understand changes.

📊 Visualization Recipes

• Visualize JSON as Diagrams: Turn complex JSON into Mermaid diagrams, flow charts, and node graphs.
• Generate Mermaid Diagrams from JSON: Create flowcharts, Gantt charts, mind maps, and more — ready for GitHub, Notion, or any Markdown doc.

🔗 Sharing & API

• Share JSON via URL: Generate compressed, stateless links to share JSON data with colleagues.
• Fetch API Data into Your Workspace: Pull live JSON from REST or GraphQL APIs directly — no file download required.
• Generate a Mock API: Turn any JSON payload into a live REST endpoint for prototyping.
• API Documentation from JSON: Generate TypeScript types, OpenAPI specs, and mock endpoints from a single JSON sample.

⚡ Productivity

• Annotate Your Workspace with Notes: Write Markdown documentation alongside your data — auto-saved, downloadable, and always in context.
• Organize Workspaces with Folders: Group, move, import, and export workspaces using the folder-based Workspace Manager.
• Keyboard Shortcuts: Master keyboard shortcuts and power user tips across all DataLensia tools.