BI Export lets you export account data for future import to the analytics tools. The data is stored in tables, which are connected using foreign key identifiers (like in a relational database). The following page describes the tables that are present in the export and their columns.
Please note: The audit_log file in BI Data Export is limited to a maximum of 10,000,000 rows for the previous 180 days.
Schema Reference
TABLE PARAMETERS
| Table name | Description |
|---|---|
Detailed information about file attachments | |
User's operations log | |
Сustom field definitions | |
User groups | |
Users membership in groups | |
Information about recurrent tasks | |
Timelog categories | |
Users | |
Information about task assignees and project owners | |
Attaches for tasks, projects, folders | |
Versions of task/folder/project attachments | |
Change revisions (status, title, description etc.) of tasks, projects, and folders | |
Information about comments in tasks, projects and folders | |
Comment contents in tasks, projects, and folders | |
Mentions of groups and users in comments | |
Custom field values | |
Change history of task custom fields values | |
Task/project/folder descriptions in HTML format | |
Detailed information about folders | |
Information about parent and child relationships of projects, folders and tasks | |
Base information for tasks, projects, and folders | |
Detailed information about projects | |
Relationships between projects and tasks (for any level of nesting) | |
Information about spaces | |
Information about users of spaces | |
Detailed information about tasks | |
Task dependencies | |
Time logged for tasks | |
Comments for timelogs | |
History of task status changes | |
Workflows | |
Worklow statuses | |
Flexible effort for task |