Custom Data Export Tool
Import JSON data and define custom export columns using object paths
1. Input Data (JSON Format)
2. Define Export Columns
Use dot notation to access nested properties (e.g., "user.name", "user.profile.age", "order.items"). For arrays of objects, specify which property to extract (e.g., path: "order.items", property: "name" → extracts all item names).
Extract dynamic columns from array of key-value objects
Leave empty for simple arrays
How to join array values
Examples:
Regular Mode:
- Simple property: Path: "user.name" → Column: "User Name"
- Array of strings: Path: "tags" → Column: "Tags" (joins with separator)
- Array of objects - extract names: Path: "order.items", Array Property: "name" → Column: "Item Names"
- Array of objects - extract IDs: Path: "order.items", Array Property: "id" → Column: "Item IDs"
Key-Value Mode:
- Questions & Answers: Path: "questions", Key Property: "question", Value Property: "answer" → Creates columns like "Họ và tên bé", "Biệt danh của bé", etc.
- Settings: Path: "settings", Key Property: "name", Value Property: "value" → Dynamic columns based on setting names
- Attributes: Path: "attributes", Key Property: "key", Value Property: "val" → Dynamic columns for each attribute