Pipeliner 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.
Pipeliner Tables
| Name | Description |
| Account | Accounts.get |
| AccountDataExRelations | AccountDataExRelations.get |
| AccountKPIs | AccountKPIs.get |
| AccountSharingClientRelations | AccountSharingClientRelations.get |
| AccountSharingSalesUnitRelations | AccountSharingSalesUnitRelations.get |
| AccountSocialRelations | AccountSocialRelations.get |
| AccountTypes | AccountTypes.get |
| ActivityComments | ActivityComments.get |
| ActivityDataExRelations | ActivityDataExRelations.get |
| ActivityKPIs | ActivityKPIs.get |
| ActivityRelations | ActivityRelations.get |
| AllowedPipelines | AllowedPipelines.get |
| AppointmentClientInviteesRelations | AppointmentClientInviteesRelations.get |
| AppointmentContactInviteesRelations | AppointmentContactInviteesRelations.get |
| AppointmentReminders | AppointmentReminders.get |
| Appointments | Appointments.get |
| AppointmentTypes | AppointmentTypes.get |
| Client | Clients.get |
| ClientExcludedOppties | ClientExcludedOppties.get |
| ClientFavorites | ClientFavorites.get |
| ClientSettings | ClientSettings.get |
| ClientStoryReads | ClientStoryReads.get |
| Cloud | CloudObjects.get |
| CloudObjectRelations | CloudObjectRelations.get |
| CloudObjectStepRelations | CloudObjectStepRelations.get |
| Contact | Contacts.get |
| ContactAccountRelations | ContactAccountRelations.get |
| ContactDataExRelations | ContactDataExRelations.get |
| ContactKPIs | ContactKPIs.get |
| ContactSharingClientRelations | ContactSharingClientRelations.get |
| ContactSharingSalesUnitRelations | ContactSharingSalesUnitRelations.get |
| ContactSocialRelations | ContactSocialRelations.get |
| ContactTypes | ContactTypes.get |
| Currency | Currencies.get |
| CurrencyExchangeRates | CurrencyExchangeRates.get |
| CurrencyExchangeRatesLists | CurrencyExchangeRatesLists.get |
| Data | Data.get |
| DataRelations | DataRelations.get |
| Emails.get | |
| Entity | Entities.get |
| Field | Fields.get |
| FieldSequences | FieldSequences.get |
| Lead | Leads.get |
| LeadOpportunity | LeadOppties.get |
| LeadOpportunityAccountRelation | LeadOpptyAccountRelations.get |
| LeadOpportunityContactRelation | LeadOpptyContactRelations.get |
| LeadOpportunityContactRelationInfluenceLines | LeadOpptyContactRelationInfluenceLines.get |
| LeadOpportunityContactSalesRoleRelation | LeadOpptyContactSalesRoleRelations.get |
| LeadOpportunityDataExRelation | LeadOpptyDataExRelations.get |
| LeadOpportunityKPI | LeadOpptyKPIs.get |
| LeadOpportunitySharingClientRelation | LeadOpptySharingClientRelations.get |
| LeadOpportunitySharingSalesUnitRelation | LeadOpptySharingSalesUnitRelations.get |
| LeadOpportunityStepCheckListRelation | LeadOpptyStepCheckListRelations.get |
| LeadType | LeadTypes.get |
| MasterRight | MasterRights.get |
| Memo | Memos.get |
| MemoComments | MemoComments.get |
| MessageRelations | MessageRelations.get |
| MessageSharingClientRelations | MessageSharingClientRelations.get |
| MessageSharingSalesUnitRelations | MessageSharingSalesUnitRelations.get |
| Note | Notes.get |
| Opportunity | Opportunities.get |
| OpportunityProductRelation | OpptyProductRelations.get |
| OpportunityRecurrence | OpptyRecurrences.get |
| OpportunityType | OpportunityTypes.get |
| ParentAccountRelationTypes | ParentAccountRelationTypes.get |
| Pipeline | Pipelines.get |
| Product | Products.get |
| ProductCategories | ProductCategories.get |
| ProductPipelineRelations | ProductPipelineRelations.get |
| ProductPriceListPrices | ProductPriceListPrices.get |
| ProductPriceLists | ProductPriceLists.get |
| Profile | Profiles.get |
| ProfileSharingClientRelations | ProfileSharingClientRelations.get |
| ProfileSharingSalesUnitRelations | ProfileSharingSalesUnitRelations.get |
| Report | Reports.get |
| ReportFolders | ReportFolders.get |
| ReportSharingClientRelations | ReportSharingClientRelations.get |
| ReportSharingSalesUnitRelations | ReportSharingSalesUnitRelations.get |
| SalesRole | SalesRoles.get |
| SalesUnit | SalesUnits.get |
| SalesUnitClientRelations | SalesUnitClientRelations.get |
| Step | Steps.get |
| StepChecklistActivityTemplates | StepChecklistActivityTemplates.get |
| StepChecklistActivityTplSharingClientRelations | StepChecklistActivityTplSharingClientRelations.get |
| StepChecklistActivityTplSharingSalesUnitRelations | StepChecklistActivityTplSharingSalesUnitRelations.get |
| StepChecklists | StepChecklists.get |
| TaskRecurrences | TaskRecurrences.get |
| TaskReminders | TaskReminders.get |
| Tasks | Tasks.get |
| TaskSharingClientRelations | TaskSharingClientRelations.get |
| TaskSharingSalesUnitRelations | TaskSharingSalesUnitRelations.get |
| TaskTypes | TaskTypes.get |
| Timeframe | Timeframes.get |
| Type | Types.get |
| Webhook | Webhooks.get |
| WebhookEvents | WebhookEvents.get |
| Webresource | Webresources.get |