Overview
TBIJSON imports and exports JSON data to and from TeeBI data structures. Supports both standard JSON objects and JSON array formats.
Location: BI.JSON.pas:40
Constructor
Properties
Format
Normal: Standard JSON object formatArray: MongoDB-style format (one object per line)
EngineClass
Methods
Import from File
Import from Text
Import from Strings
FromFile (Class Method)
Supported File Types
.json
Usage Example
TBIJSONExport
Location:BI.JSON.pas:72
Export class for creating JSON files.
Properties
AsString (Class Method)
Usage Example
JSON Structure
TeeBI converts JSON data types automatically:- JSON numbers → Int32, Int64, or Double
- JSON strings → Text
- JSON booleans → Boolean
- JSON objects → Nested TDataItem tables
- JSON arrays → Detail data with master-detail relationships
- JSON null → Missing values
