Accelo Tables

The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.

Accelo Tables


Name	Description
Activities	Returns a list of activities on the Accelo deployment.
ActivityClasses	Returns a list of activity classes.
ActivityContactsInteractions	Returns an array of contact objects that have an interaction against the activity.
ActivityCountInteractions	Returns a count of the activity interactions listed against the activity identified.
ActivityStaffInteractions	Returns an array of staff objects that have an interaction against the activity.
ActivityThreads	Returns information on timed logged and the value charged against a collection of activities.
ActivityTimeAllocations	Returns information on timed logged and the value charged against a collection of activities.
Addresses	Returns the address information of companies and contacts on the Accelo deployment.
Affiliations	Returns a list of affiliation objects on the deployment.
AffiliationStatus	Returns the status of an affiliation specified by its AffiliationId.
AffiliationStatuses	Returns a list of affiliation statuses on the deployment.
Assets	Returns a list of assets on the Accelo deployment.
AssetTypes	Returns a list of asset types.
Companies	Returns a list of companies from the Accelo deployment.
CompanyAddresses	Returns the address information of a given company.
CompanyContacts	Returns a list of contacts for a company identified by its CompanyId.
CompanyMainContact	Returns the main contact of a company identified by its CompanyId. This is the contact associated with the company's default affiliation.
CompanyManagers	Returns a list of managers for a company identified by its CompanyId.
CompanySegmentations	Returns a list of company segmentations for a company identified by its CompanyId.
CompanyStatus	Returns the status of a company specified by its CompanyId.
CompanyStatuses	Returns a list of company statuses on the deployment.
ContactAddresses	Returns the address information of a given contact.
Contacts	Returns a list of contacts from the Accelo deployment.
ContactSegmentations	Returns a list of contact segmentations for a contact identified by its ContactId.
ContactStatus	Returns the status of a contact specified by its ContactId.
ContactStatuses	Returns a list of contact statuses on the deployment.
ContractPeriod	Returns a single contract period object from the Accelo deployment.
ContractPeriods	Returns a list of contract periods for a contract, specified by its ContractId.
Contracts	Returns a list of contracts from the Accelo deployment.
ContractStatuses	Returns a list of contract statuses on the deployment.
ContractTypes	Returns a list of contract types on the Accelo deployment.
Contributors	Returns a list of contributors from the Accelo deployment.
ContributorTypes	Returns a list of contributor types on the deployment.
CountActivityClasses	Returns a count of the number of activity classes listed.
CountActivityThreads	Returns a count of the number of activity threads listed.
CountAddresses	Returns a count of the addresses listed.
CountAffiliations	Returns a count of the affiliations listed.
Expenses	Returns a list of expenses from the Accelo deployment.
ExpenseTypes	Returns a list of expense types on the deployment.
Filters	Returns a list of saved filters on the Accelo deployment. This list will not include any filters created by other users which have not been shared.
Invoices	Returns a list of invoices from the Accelo deployment.
IssueClasses	Returns a list of issue classes on the deployment.
IssuePriorities	Returns a list of issue priorities.
IssueResolutions	Returns a list of issue resolutions.
Issues	Returns a list of issues from the Accelo deployment.
IssueStatuses	Returns a list of issue statuses on the deployment.
IssueTypes	Returns a list of issue types.
JobCollections	Returns a list of collections of a job, specified by its JobId
JobMilestones	Returns a list of milestones of a job, specified by its JobId
Jobs	Returns a list of jobs (projects) from the Accelo deployment.
JobStatuses	Returns a list of job statuses on the deployment.
JobTypes	Returns a list of job types.
LatestModifiedCompanies	Returns the most recently changed companies on the Accelo deployment.
LatestModifiedContacts	Returns a list of contacts on the Accelo deployment sorted by the most recently modified.
LatestModifiedJobs	Returns a list of job on the deployment, sorted by the most recently modified, that is in descending order of DateModified.
Milestones	Returns a list of milestones from the Accelo deployment.
MilestoneStatuses	Returns a list of milestone statuses on the deployment.
ObjectBudgets	Returns a list of object budget from the Accelo deployment.
ObjectBudgetsMaterials	Returns a list of materials on the deployment.
ObjectBudgetsServices	Returns a list of services on the deployment.
ObjectBudgetsTemplates	Returns a list of item templates on the deployment.
ProspectProbabilities	Returns a list of all probabilities on the deployment.
Prospects	Returns a list of prospects on deployment.
ProspectStatus	Returns the prospect status of a prospect, identified by its ProspectId.
ProspectStatuses	Returns a list of prospect statuses on the deployment.
ProspectTypes	Returns a list of prospect types on the deployment.
Purchases	Returns a list of purchases on deployment.
QuoteCollections	Returns a list of collections against an quote, specified by its QuoteId
Quotes	Returns a list of quotes on deployment.
QuoteStatuses	Returns a list of quote statuses on the deployment.
Rates	Returns a list of rates on deployment.
RecentCompanies	Returns the most recently created companies on the Accelo deployment
RecentContacts	Returns a list of contacts on the Accelo deployment sorted by the most recently created.
RecentIssues	a list of issues on the deployment sorted by most recently submitted, that is, in descending order of DateSubmitted.
RecentJobs	Returns a list of job on the deployment, sorted by the most recently created, that is in descending order of DateCreated.
Referrals	Returns a list of referrals on deployment.
Requests	Returns a list of requests on deployment.
RequestThreads	Returns a list of request threads on the deployment.
Resources	Returns a list of resources on deployment.
Segmentations	Returns a list of segmentations for the deployment.
SignOffs	Returns a list of signoffs for the deployment.
SignoffsAttachments	Returns a list of attachments for the deployment.
SignoffsRecipients	Returns a list of all recipients for the deployment.
Skills	Returns a list of skills on deployment.
Staff	Returns a list of staff members on deployment.
StaffMemberships	Returns a list of staff memberships for the deployment.
Tags	Returns a list of tags on deployment.
Tasks	Returns a list of tasks on deployment.
TaskStatuses	Returns a list of task statuses on the deployment.
ThreadActivities	Returns a count of the activity interactions listed against the activity identified.
TimeExternals	Returns a list of time externals on deployment.
Timers	Returns a list of timers on deployment.
User	Returns current user information.