API Data Provider - Online Help

Shortcut Tables

The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.

Shortcut Tables

Name Description
Categories Returns categories for organizing milestones and objectives.
CustomFields Returns custom fields in the workspace.
Documents Returns documents in the workspace.
EntityTemplates Returns entity templates in the workspace.
EpicComments Returns comments for a specific epic.
EpicHealth Returns the current health for a specific epic.
Epics Returns epics in the workspace.
Files Returns uploaded files in the workspace.
Groups Returns teams (groups) in the workspace.
Iterations Returns iterations (sprints) in the workspace.
Labels Returns labels in the workspace.
LinkedFiles Returns linked files in the workspace.
Milestones Returns milestones in the workspace.
Objectives Returns objectives in the workspace.
Projects DEPRECATED. Returns projects in the workspace.
Stories Returns a single story by ID.
StoryComments Returns comments for a specific story.
StoryLinks Returns a story link by ID.
StoryTasks Returns tasks for a specific story.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770.0