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.
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 | - | - |
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 | - | - |
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 | - | - |
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 | - | - |
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 | - | - |
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 | - | - |
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 | - |
|
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 | - | - |
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 | - | - |
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 | - | - |
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 | - | - |
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 | - | - |
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 | - | - |
Documentation: https://api.accelo.com/docs/#rates
Documentation: https://api.accelo.com/docs/#staff
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 | - | - |
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 | - | - |
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 | - | - |
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 | - | - |
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 | - | - |
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 | - | - |
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 | - | - |
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 | - | - |
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 | - |
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 | - | - |
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 | - | - |
SyncHub lives and breathes APIs and data. Keep exploring using the links below.