Accelo: Most-used fields#
The table below gives information about most-used fields that you can import from Accelo. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
API name |
Adverity UI name |
Description |
Use in Adverity |
|---|---|---|---|
activity_class.id |
activity_class.id |
The unique identifier for the activity class, which categorizes activities. |
metric |
activity_class.status |
activity_class.status |
The status of the activity class, indicating if it is ‘active’ or ‘inactive’. |
dimension |
activity_class.title |
activity_class.title |
The name of the activity class, categorizing the activity (e.g., ‘Client Work’, ‘Sales’, ‘Internal’). |
dimension |
activity_priority.level |
activity_priority.level |
A numerical representation of the urgency of the activity priority, where 1 is ‘extreme’ and 5 is ‘none’. |
metric |
body |
body |
The main plaintext content of the activity. |
dimension |
comments |
comments |
Any comments or notes made against the object (e.g., company, contact, or prospect). |
dimension |
company_status.id |
company_status.id |
The unique identifier for the company’s status, indicating its current state. |
metric |
company_status.title |
company_status.title |
The name of the company’s status (e.g., ‘Active’, ‘Inactive’). |
dimension |
contract_status.id |
contract_status.id |
The unique identifier for the contract’s status, indicating its current state. |
metric |
contract_status.title |
contract_status.title |
The name of the contract’s status (e.g., ‘Active’, ‘Cancelled’). |
dimension |
contract_type.id |
contract_type.id |
The unique identifier for the contract type, which categorizes the contract. |
metric |
contract_type.title |
contract_type.title |
The name of the contract type (e.g., ‘Default’). |
dimension |
custom_id |
custom_id |
This field stores a user-defined custom identifier for entities such as companies, jobs (projects), or issues (tickets). Its availability is dependent on whether custom IDs are enabled for the specific entity type in the Accelo web application. |
dimension |
date_created |
date_created |
The date and time (Unix timestamp) when the object was created. |
dimension |
date_ended |
date_ended |
For meetings, the scheduled end date of the meeting (Unix timestamp). Returns null otherwise. |
dimension |
date_last_interacted |
date_last_interacted |
This field indicates the most recent date and time, in Unix timestamp format, when an interaction occurred with the associated record, such as a company, contact, affiliation, or job (project). |
dimension |
date_logged |
date_logged |
The date and time (Unix timestamp) when time was logged for the activity. Read-only, takes the value of date_started or date_created if date_started is not set. |
dimension |
date_modified |
date_modified |
The date and time (Unix timestamp) when the object was last modified. |
dimension |
date_started |
date_started |
The date and time (Unix timestamp) when the activity or project is scheduled to start, or when time was logged. |
dimension |
id |
id |
The unique identifier for the object. |
dimension |
job.date_created |
job.date_created |
The date and time (Unix timestamp) when the job (project) was created. |
dimension |
job.id |
job.id |
The unique identifier for the job (project). |
dimension |
job.job_status.id |
job.job_status.id |
The unique identifier for the job’s status, indicating its current state. |
dimension |
job.job_status.title |
job.job_status.title |
The name of the job’s status (e.g., ‘Active’, ‘Completed’). |
dimension |
job.job_type.id |
job.job_type.id |
The unique identifier for the job type, which categorizes the job. |
dimension |
job.job_type.title |
job.job_type.title |
The name of the job type. |
dimension |
job.title |
job.title |
The name or title of the job (project). |
dimension |
job_status.id |
job_status.id |
The unique identifier for the job’s status, indicating its current state. |
metric |
job_status.title |
job_status.title |
The name of the job’s status (e.g., ‘Active’, ‘Completed’). |
dimension |
job_type.id |
job_type.id |
The unique identifier for the job type, which categorizes the job. |
metric |
job_type.title |
job_type.title |
The name of the job type. |
dimension |
manager.firstname |
manager.firstname |
The first name of the staff member assigned as a manager for an object (e.g., company, contract, or job). |
dimension |
manager.id |
manager.id |
The unique identifier for the staff member assigned as a manager for an object (e.g., company, contract, or job). |
metric |
manager.surname |
manager.surname |
The surname of the staff member assigned as a manager for an object (e.g., company, contract, or job). |
dimension |
manager.title |
manager.title |
The title of the staff member assigned as a manager (e.g., ‘Mr’, ‘Ms’). |
dimension |
medium |
medium |
The activity medium, describing the type of communication (e.g., Note, Email, Meeting, Call, Postal). |
dimension |
name |
name |
The name of the company. |
dimension |
owner |
owner |
The API URI of the object representing the owner of the activity (e.g., ‘staff/14’). |
dimension |
owner_id |
owner_id |
The unique identifier of the owner object for the activity. |
dimension |
owner_type |
owner_type |
The type of the owner object for the activity (e.g., ‘staff’ or ‘affiliation’). |
dimension |
phone |
phone |
A contact phone number for the entity (e.g., company, affiliation, or staff member). |
dimension |
postal_address.city |
postal_address.city |
The city of the postal address associated with the company. |
dimension |
staff.firstname |
staff.firstname |
The first name of the staff member. |
dimension |
staff.id |
staff.id |
The unique identifier for the staff member. |
metric |
staff.surname |
staff.surname |
The surname of the staff member. |
dimension |
staff.username |
staff.username |
The username of the staff member on the Accelo deployment. |
dimension |
standing |
standing |
A string describing the current standing or status of the object (e.g., ‘active’, ‘unapproved’, ‘closed’). |
dimension |
subject |
subject |
A string describing the content or title of the activity. |
dimension |
thread |
thread |
If the activity is part of a response set, this string describes the original activity in the thread (e.g., ‘activity/346’). |
dimension |
title |
title |
The name or title of the object (e.g., contract, job, or task). |
dimension |
website |
website |
The website URL for the company. |
dimension |