2024 is the year of the connector - vote here

Explore the Accelo API data model

See how the various Accelo endpoints relate to each other, using our handy Entity Relationship Diagram

Try our interactive ERD Or, read the docs below

Pulling data from the Accelo API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only sync your Accelo API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Endpoints

Address

Documentation: https://api.accelo.com/docs/#addresses

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Full string - -
CustomID string - -
Title string - -
Street1 string - -
Street2 string - -
City string - -
StateID long State → ID -
CountryID long Country → ID -
Postal string - -
Physical string - -

Affiliation

Documentation: https://api.accelo.com/docs/#affiliations

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Mobile string - -
Email string - -
Fax string - -
Position string - -
Phone string - -
PostalAddress long - -
PhysicalAddress long - -
Company long Company → ID -
Contact long Contact → ID -
StatusID long AffiliationStatus → ID -
DateLastInteracted long - -
StaffBookmarked boolean - -
PortalAccess string - -
InvoiceMethod string - -
Standing string - -
DateCreated long - -
DateModified long - -

Asset

Documentation: https://api.accelo.com/docs/#assets

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
LatestAssetLink string - -
Fax string - -
DateCreated long - -
AgainstType string - -
AgainstID long - -
AssetTypeID long - -
Affiliation long Affiliation → ID -
AffiliationID long - -
ManagerID long Staff → ID -
AddressID long Address → ID -
Standing string - -

Company

Documentation: https://api.accelo.com/docs/#companies

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
CustomID string - -
Website string - -
Phone string - -
Fax string - -
DateLastInteracted long - -
Comments string - -
WhenLastInteracted datetime - -
PostalAddress long - -
CompanyStatusID long CompanyStatus → ID -
StaffBookmarked boolean - -
DefaultAffiliation long Affiliation → ID -
Standing string - -
DateCreated long - -
DateModified long - -

Contact

Documentation: https://api.accelo.com/docs/#contacts

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Firstname string - -
Lastname string - -
Username string - -
Middlename string - -
Title string - -
Timezone string - -
DateLastInteracted long - -
Comments string - -
WhenLastInteracted datetime - -
DefaultAffiliation long Affiliation → ID -
Standing string - -
DateCreated long - -
DateModified long - -

Invoice

Documentation: https://api.accelo.com/docs/#invoices

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Amount decimal - -
Subject string - -
AgainstType string - -
AgainstID long - -
CompanyID long Company → ID -
JobID long Job → ID -
Notes string - -
InvoiceNumber string -
  • 1 Feb 2024 The Accelo docs say that this is an integer, however it also says that it is the representation of the external identifier from (e.g.) Xero, MYOB etc. These are not necessarily integers (e.g. Xero is a GUID) so we will hedge here and make it a string
CurrencyID long - -
Tax decimal - -
Outstanding decimal - -
OwnerID long Staff → ID -
ModifiedBy long Staff → ID -
DateRaised long - -
DateModified long - -
DateDue long - -
AffiliationContact long Contact → ID -
Affiliation long Affiliation → ID -
AffiliationID long Affiliation → ID -
CreatorID long Staff → ID -
Standing string - -

InvoiceItem

Documentation: https://api.accelo.com/docs/#invoices

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
Type string - -
Quantity decimal - -
Rate decimal - -
Total decimal - -
Tax decimal - -
InvoiceID long Invoice → ID -
LedgerID long - -
TaxID long - -
Ordering long - -
LineItemLedger long - -
LineItemTax decimal - -

Issue

Documentation: https://api.accelo.com/docs/#issues-tickets

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
Title string - -
CustomID string - -
AgainstType string - -
AgainstID long - -
CompanyID long Company → ID -
DateLastInteracted long - -
DateDue long - -
WhenLastInteracted datetime - -
WhenDue datetime - -
IssueType long - -
Class long - -
IssuePriority long - -
Resolution long - -
ResolutionDetail string - -
Affiliation long Affiliation → ID -
StatusID long IssueStatus → ID -
DateSubmitted long - -
WhenSubmitted datetime - -
SubmittedBy long Staff → ID -
DateOpened long - -
WhenOpened datetime - -
OpenedBy long Staff → ID -
DateResolved long - -
WhenResolved datetime - -
ResolvedBy long Staff → ID -
DateClosed long - -
WhenClosed datetime - -
ClosedBy long Staff → ID -
ReferrerID long - -
ReferrerType string - -
StaffBookmarked boolean - -
BillableSeconds long - -
Company long Company → ID -
Assignee long Staff → ID -
Contract long - -
IssueObjectBudget long - -
Standing string - -
DateCreated long - -
DateModified long - -

Job

Documentation: https://api.accelo.com/docs/#jobs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
AgainstType string - -
AgainstID int - -
CustomID string - -
Paused int - -
StaffBookmarked boolean - -
DateLastInteracted long - -
DateStarted long - -
DateCommenced long - -
DateDue long - -
DateCompleted long - -
Type int - -
Manager long Staff → ID -
ModifiedBy long Staff → ID -
Rate long Rate → ID -
Company long Company → ID -
JobObjectBudget long - -
JobContract long - -
JobObjectSchedule long - -
Affiliation long - -
StatusID long JobStatus → ID -
JobTypeID long JobType → ID -
Standing string - -
DateCreated long - -
DateModified long - -

JobType

Documentation: https://api.accelo.com/docs/#jobs

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Standing string - -
Ordering int - -

Prospect

Documentation: https://api.accelo.com/docs/#prospects-sales

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
DateActioned long - -
WhenActioned datetime - -
DateDue long - -
WhenDue datetime - -
DateLastInteracted long - -
WhenLastInteracted datetime - -
Value decimal - -
Success boolean - -
Comments string - -
Progress decimal - -
ValueWeighted long - -
StaffBookmarked boolean - -
WonByID long Staff → ID -
CancelledByID long Staff → ID -
AbandonedByID long Staff → ID -
Manager long Staff → ID -
StatusID long ProspectStatus → ID -
Affiliation long Affiliation → ID -
ProspectTypeID long - -
ProspectProbabilityID long - -
Weighting long - -
Standing string - -
DateCreated long - -
DateModified long - -

Rate

Documentation: https://api.accelo.com/docs/#rates

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Object string - -
Charged decimal - -
Standing string - -

Staff

Documentation: https://api.accelo.com/docs/#staff

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Firtname string - -
Surname string - -
FinancialLevel string - -
Title string - -
Email string - -
Mobile string - -
Phone string - -
Fax string - -
Position string - -
Username string - -
Timezone string - -
StaffRate decimal - -
StaffCostRate decimal - -
Standing string - -

AffiliationStatus

Documentation: https://api.accelo.com/docs/#statuses

Column Type Relates to Notes
RemoteID string - -
AffiliationRemoteID string Affiliation → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Color string - -
Ordering long - -
Standing string - -

CompanyStatus

Documentation: https://api.accelo.com/docs/#statuses

Column Type Relates to Notes
RemoteID string - -
CompanyRemoteID string Company → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Color string - -
Ordering long - -
Standing string - -

IssueStatus

Documentation: https://api.accelo.com/docs/#statuses

Column Type Relates to Notes
RemoteID string - -
IssueRemoteID string Issue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Color string - -
Ordering long - -
Standing string - -

JobStatus

Documentation: https://api.accelo.com/docs/#statuses

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Color string - -
Ordering long - -
Standing string - -

ProspectStatus

Documentation: https://api.accelo.com/docs/#statuses

Column Type Relates to Notes
RemoteID string - -
ProspectRemoteID string Prospect → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Color string - -
Ordering long - -
Standing string - -

TaskStatus

Documentation: https://api.accelo.com/docs/#statuses

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Color string - -
Ordering long - -
Standing string - -

Task

Documentation: https://api.accelo.com/docs/#tasks

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
Title string - -
Billable int - -
Nonbillable int - -
Logged int - -
Budgeted int - -
Remaining int - -
StaffBookmarked boolean - -
DateCommenced long - -
DateAccepted long - -
DateDue long - -
DateCompleted long - -
AgainstID long - -
AgainstType string - -
CreatorType string - -
Creator long Staff → ID -
TaskTitle string - -
TaskStanding string - -
TaskOrdering long - -
Manager long Staff → ID -
Contact long Contact → ID -
Affiliation long Affiliation → ID -
StatusID long TaskStatus → ID -
Company long Company → ID -
Issue long Issue → ID -
TaskJob long Job → ID -
TastObjectSchedule long - -
TastObjectScheduleID long - -
RateID long Rate → ID -
RateCharged decimal - -
Ordering long - -
Standing string - -
DateCreated long - -
DateModified long - -

Country

Documentation: https://api.accelo.com/docs/#addresses

Column Type Relates to Notes
RemoteID string - -
AddressRemoteID string Address → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Prefix string - -
Suffix string - -
PostcodeName string - -
StateName string - -
PostcodeRequired string - -
StateRequired string - -

State

Documentation: https://api.accelo.com/docs/#addresses

Column Type Relates to Notes
RemoteID string - -
AddressRemoteID string Address → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Timezone string - -
Abbreviation string - -
Ordering int - -
CountryID long Country → ID -

ProspectType

Documentation: https://api.accelo.com/docs/#prospects-sales

Column Type Relates to Notes
RemoteID string - -
ProspectRemoteID string Prospect → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Parent long - -
Title string - -
Standing string - -
Ordering long - -

ProspectProbability

Documentation: https://api.accelo.com/docs/#prospects-sales

Column Type Relates to Notes
RemoteID string - -
ProspectRemoteID string Prospect → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Value long - -
Title string - -
Ordering long - -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Accelo data Interactive ERD Querying Accelo using regular SQL