API Data Provider - Online Help
Teamgate Profile
Connecting to Teamgate
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
ActivityAttendees
ActivityCompanies
ActivityDeals
ActivityFiles
ActivityLeads
ActivityPeople
Companies
CompanyActivities
CompanyCustomFields
CompanyCustomerStatuses
CompanyDeals
CompanyFiles
CompanyIndustries
CompanyPeople
CompanyProspectStatuses
CompanySources
CompanyTags
CustomFields
DealCompanies
DealCustomFields
DealEvents
DealFiles
DealPeople
Deals
DealSources
DealStages
DealTags
Emails
FileDownloadUrl
Files
Industries
LeadActivities
LeadCustomFields
LeadIndustries
Leads
LeadSources
LeadStatuses
People
PersonActivities
PersonCustomFields
PersonCustomerStatuses
PersonDeals
PersonIndustries
PersonProspectStatuses
PersonSources
Pipelines
ProductActivities
ProductCustomFields
ProductDeals
Products
Resources
Sources
Tags
Teams
TeamUsers
Users
Pipelines
Retrieves a list of all pipelines.
Columns
Name
Type
References
Id [KEY]
Integer
Name
String
Stages
String