Teamgate 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.

Teamgate Tables


Name	Description
Activities	Retrieves a list of all activities.
ActivityAttendees	Retrieves all attendees for a specific activity.
ActivityCompanies	Retrieves all event companies.
ActivityDeals	Retrieves all deals for a specific activity.
ActivityFiles	Retrieves all files for a specific activity.
ActivityLeads	Retrieves all leads for a specific activity.
ActivityPeople	Retrieves all people from a specific event (activity).
Companies	Retrieves a list of all companies.
CompanyActivities	Retrieves all activities for a specific company.
CompanyCustomFields	Retrieves all custom fields for a specific company.
CompanyCustomerStatuses	Retrieves all customer statuses for a specific company.
CompanyDeals	Retrieves all deals for a specific company.
CompanyFiles	Retrieves all files for a specific company.
CompanyIndustries	Retrieves all industries for a specific company.
CompanyPeople	Retrieves all people for a specific company.
CompanyProspectStatuses	Retrieves all prospect statuses for a specific company.
CompanySources	Retrieves all sources for a specific company.
CompanyTags	Retrieves all tags for a specific company.
CustomFields	Retrieves a list of all custom fields.
DealCompanies	Retrieves all deal companies.
DealCustomFields	Retrieves all custom fields for a specific deal.
DealEvents	Retrieves all deal events.
DealFiles	Retrieves all files for a specific deal.
DealPeople	Retrieves all deal people.
Deals	Retrieves the collection of deals.
DealSources	Retrieves all sources for a specific company.
DealStages	Retrieves all stages for a specific deal.
DealTags	Retrieves all tags for a specific deal.
Emails	Retrieves a list of all emails.
FileDownloadUrl	Retrieves files download URL.
Files	Retrieves a list of all files.
Industries	Retrieves industries collection.
LeadActivities	Retrieves all activities for a specific lead.
LeadCustomFields	Retrieves all custom fields for a specific lead.
LeadIndustries	Retrieves all industries for a specific lead.
Leads	Retrieves the collection of leads.
LeadSources	Retrieves all sources for a specific lead.
LeadStatuses	Retrieves a list of lead status values.
People	Retrieves a list of all people.
PersonActivities	Retrieves a list of tasks, appointments or custom activities for a specific person.
PersonCustomFields	Retrieves all custom fields for a specific person.
PersonCustomerStatuses	Retrieves all customer statuses for a specific person.
PersonDeals	Retrieves the deals associated with a person.
PersonIndustries	Retrieves a list of assigned person industries.
PersonProspectStatuses	Retrieves all prospect statuses for a specific person.
PersonSources	Retrieves all sources for a specific person.
Pipelines	Retrieves a list of all pipelines.
ProductActivities	Retrieves all events attached to a specific product.
ProductCustomFields	Retrieves a set of product custom field values.
ProductDeals	Retrieves all deals for a specific product.
Products	Retrieves a list of all products.
Resources	Retrieves a list of all resources.
Sources	Retrieves a list of all sources.
Tags	Retrieves a list of all tags.
Teams	Retrieves the collection of teams.
TeamUsers	Retrieves all users for a specific team.
Users	Retrieves a list of all users.