Visit API Community

Schema Reference

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.

TABLE PARAMETERS
Table nameDescription
attachment_file
Detailed information about file attachments
audit_log
User's operations log
custom_field
–°ustom field definitions
group
User groups
group_to_user
Users membership in groups
recurrence
Information about recurrent tasks
timelog_category
Timelog categories
user
Users
work_assignee
Information about task assignees and project owners
work_attachment
Attaches for tasks, projects, folders
work_attachment_to_attachment_file
Versions of task/folder/project attachments
work_change_revision
Change revisions (status, title, description etc.) of tasks, projects, and folders
work_comment
Information about comments in tasks, projects and folders
work_comment_content
Comment contents in tasks, projects, and folders
work_comment_to_mention
Mentions of groups and users in comments
work_custom_field
Custom field values
work_custom_field_history
Change history of task custom fields values
work_description
Task/project/folder descriptions in HTML format
work_folder
Detailed information about folders
work_graph
Information about parent and child relationships of projects, folders and tasks
work_item
Base information for tasks, projects, and folders
work_project
Detailed information about projects
work_project_to_task
Relationships between projects and tasks (for any level of nesting)
work_space
Information about spaces
work_space_user
Information about users of spaces
work_task
Detailed information about tasks
work_task_dependency
Task dependencies
work_timelog
Time logged for tasks
work_timelog_comment
Comments for timelogs
work_workflow_stage_history
History of task status changes
workflow
Workflows
workflow_stage
Worklow statuses
work_task_flexible_effort
Flexible effort for task