JSON
JSON files can be imported in the same way as Excel, CSV and XML files: the system reads the records, detects the fields and maps them to the columns of your target table.
Last updated
⌘Ctrlk
JSON files can be imported in the same way as Excel, CSV and XML files: the system reads the records, detects the fields and maps them to the columns of your target table.
If your data structure is nested, specify the dot path to the array of records:
Example: For {"data": {"items": [...]}} set the path to data.items.
Leave this field empty if the root element is the array directly.
Nested JSON objects are “flattened”: Keys from deeper levels are converted into column names for example using dot notation.
All standard functions are available:
Column mapping
Virtual columns
Import preview
Log
Quick import.
Quick Import: JSON is fully supported. The app matches field names from the file with your saved mapping templates.
Check the structure of your JSON file in a text editor or with an online JSON viewer before importing. This will help you find the correct record path more quickly.
Last updated