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.
CategoryMilestones Returns milestones for a specific category.
CategoryObjectives Returns objectives for a specific category.
CurrentMember Returns the currently authenticated member.
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.
EpicHealthHistory Returns the health history for a specific epic.
Epics Returns epics in the workspace.
EpicStories Returns stories for a specific epic.
EpicWorkflow Returns the epic workflow for the workspace.
ExternalLinkStories Returns stories by external link URL.
Files Returns uploaded files in the workspace.
Groups Returns teams (groups) in the workspace.
GroupStories Returns stories for a specific group.
Integrations Returns a webhook integration by ID.
Iterations Returns iterations (sprints) in the workspace.
IterationStories Returns stories for a specific iteration.
KeyResults Returns a key result by ID.
LabelEpics Returns epics for a specific label.
Labels Returns labels in the workspace.
LabelStories Returns stories for a specific label.
LinkedFiles Returns linked files in the workspace.
Members Returns workspace members.
MilestoneEpics Returns epics for a specific milestone.
Milestones Returns milestones in the workspace.
Objectives Returns objectives in the workspace.
Projects Returns projects in the workspace.
ProjectStories Returns stories for a specific project.
Repositories Returns linked repositories.
Stories Returns a single story by ID.
StoryComments Returns comments for a specific story.
StoryHistory Returns the history for a specific story.
StoryLinks Returns a story link by ID.
StorySubTasks Returns a list of all Sub-task Stories for a given parent Story.
StoryTasks Returns tasks for a specific story.
Workflows Returns workflows in the workspace.

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