ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Where to find the API Attribute ID for the OOTB Object's Attributes in the Database.

book

Article ID: 213672

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Is there a table in DB where I can find the API attribute IDs for OOTB attributes of several objects?

Environment

Clarity Application

Resolution

You can find the API attribute ID in the column api_alias, for example on the status report attribute name = overall status, and the api attribute id = overallStatus.

For other you will be able to find in the tables below:

Clarity Schema Documentation:

ODF_CUSTOM_ATTRIBUTES
Added column:
API_ALIAS

ODF_OBJECTS
Added columns:
API_ALIAS
IS_API_ENABLED