PRODUCTS
- Last Updated: July 30, 2025
- 1 minute read
- DataDirect Connectors
- ODBC
- Aha! 8.0
- Documentation
Endpoint
<hostname>/api/v1/products
Columns
The PRODUCTS table contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type |
|---|---|
| ID* | BigInt |
| CAPACITY_PLANNING_ENABLED | Boolean |
| CREATED_AT | Timestamp(9) |
| DEFAULT_CAPACITY_UNITS | Integer |
| DESCRIPTION_BODY | VarChar(1024) |
| DESCRIPTION_CREATED_AT | Timestamp(9) |
| DESCRIPTION_ID | BigInt |
| EPIC_WORKFLOW_ID | BigInt |
| EPIC_WORKFLOW_NAME | VarChar(64) |
| EPIC_WORKFLOW_STATUSABLE_TYPE | VarChar(64) |
| EPIC_WORKFLOW_WORKFLOW_TYPE | VarChar(64) |
| FEATURE_WORKFLOW_ID | BigInt |
| FEATURE_WORKFLOW_NAME | VarChar(64) |
| FEATURE_WORKFLOW_STATUSABLE_TYPE | VarChar(64) |
| FEATURE_WORKFLOW_WORKFLOW_TYPE | VarChar(64) |
| HAS_IDEAS | Boolean |
| HAS_MASTER_FEATURES | Boolean |
| IDEA_WORKFLOW_ID | BigInt |
| IDEA_WORKFLOW_NAME | VarChar(64) |
| IDEA_WORKFLOW_STATUSABLE_TYPE | VarChar(64) |
| IDEA_WORKFLOW_WORKFLOW_TYPE | VarChar(64) |
| INITIATIVE_WORKFLOW_ID | BigInt |
| INITIATIVE_WORKFLOW_NAME | VarChar(64) |
| INITIATIVE_WORKFLOW_STATUSABLE_TYPE | VarChar(64) |
| INITIATIVE_WORKFLOW_WORKFLOW_TYPE | VarChar(64) |
| KEY | VarChar(64) |
| NAME | VarChar(64) |
| PARENT_CREATED_AT | Timestamp(9) |
| PARENT_ID | BigInt |
| PARENT_NAME | VarChar(64) |
| PARENT_PRODUCT_LINE | Boolean |
| PARENT_REFERENCE_PREFIX | VarChar(64) |
| PRODUCT_LINE | Boolean |
| PRODUCT_LINE_TYPE | VarChar(64) |
| RELEASE_WORKFLOW_ID | BigInt |
| RELEASE_WORKFLOW_NAME | VarChar(64) |
| RELEASE_WORKFLOW_STATUSABLE_TYPE | VarChar(64) |
| RELEASE_WORKFLOW_WORKFLOW_TYPE | VarChar(64) |
| REQUIREMENT_WORKFLOW_ID | BigInt |
| REQUIREMENT_WORKFLOW_NAME | VarChar(64) |
| REQUIREMENT_WORKFLOW_STATUSABLE_TYPE | VarChar(64) |
| REQUIREMENT_WORKFLOW_WORKFLOW_TYPE | VarChar(64) |
| RESOURCE | VarChar(76) |
| STRATEGIC_IMPERATIVE_WORKFLOW_ID | BigInt |
| STRATEGIC_IMPERATIVE_WORKFLOW_NAME | VarChar(64) |
| STRATEGIC_IMPERATIVE_WORKFLOW_STATUSABLE_TYPE | VarChar(64) |
| STRATEGIC_IMPERATIVE_WORKFLOW_WORKFLOW_TYPE | VarChar(64) |
| UPDATED_AT | Timestamp(9) |
| URL | VarChar(76) |