API Data Provider - Online Help
Accelo Profile
Connecting to Accelo
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
Activities
ActivityClasses
ActivityContactsInteractions
ActivityCountInteractions
ActivityStaffInteractions
ActivityThreads
ActivityTimeAllocations
Addresses
Affiliations
AffiliationStatus
AffiliationStatuses
Assets
AssetTypes
Companies
CompanyAddresses
CompanyContacts
CompanyMainContact
CompanyManagers
CompanySegmentations
CompanyStatus
CompanyStatuses
ContactAddresses
Contacts
ContactSegmentations
ContactStatus
ContactStatuses
ContractPeriod
ContractPeriods
Contracts
ContractStatuses
ContractTypes
Contributors
ContributorTypes
CountActivityClasses
CountActivityThreads
CountAddresses
CountAffiliations
Expenses
ExpenseTypes
Filters
Invoices
IssueClasses
IssuePriorities
IssueResolutions
Issues
IssueStatuses
IssueTypes
JobCollections
JobMilestones
Jobs
JobStatuses
JobTypes
LatestModifiedCompanies
LatestModifiedContacts
LatestModifiedJobs
Milestones
MilestoneStatuses
ObjectBudgets
ObjectBudgetsMaterials
ObjectBudgetsServices
ObjectBudgetsTemplates
ProspectProbabilities
Prospects
ProspectStatus
ProspectStatuses
ProspectTypes
Purchases
QuoteCollections
Quotes
QuoteStatuses
Rates
RecentCompanies
RecentContacts
RecentIssues
RecentJobs
Referrals
Requests
RequestThreads
Resources
Segmentations
SignOffs
SignoffsAttachments
SignoffsRecipients
Skills
Staff
StaffMemberships
Tags
Tasks
TaskStatuses
ThreadActivities
TimeExternals
Timers
User
CountAffiliations
Returns a count of the affiliations listed.
Columns
Name
Type
References
Count [KEY]
String