Many API endpoints allow you to submit the Primary Key ID for a record. The Primary Key ID is a unique, system-generated identifier for every record in a table.
By default, the Primary Key ID is an "Inactive" field, meaning it's not displayed within the Record Lookup screen. Before you can look up the value in this field, you first need to make sure that the field is "Active."
Navigate to the Table screen for the desired table.
Expand the "Inactive Fields" section to see if the Primary Key ID is listed there. The default name of the field is "pk_<tablename>_id." If the Primary Key ID field is displayed within this section, click the change button ("X" icon) to the right of the field name. The system moves this field from the "Inactive Fields" section up to the "Active Fields" section.
In the Tool Ribbon, click Edit > Actions > Save.
Now that the Primary Key ID is an "Active Field," you'll be able to see it on the Record Lookup screen.
Navigate to the Record Lookup screen, and search for the desired record.
Within the search results, click "Edit" next to the desired record. The system opens a new "Database Record" tab within the Top Navigation Panel. By default, the "Record Details" tab is selected. The Primary Key ID field will now be displayed on this screen.
You can also look up the Primary Key ID for a record using the Search Record API. Within the response message, the Primary Key ID is displayed within the "id" parameter. For example:
{
"id": 2311113,
"properties": [
{
"propName": "email",
"value": "john.smith@cheetahdigital.com"
}
]
}