JDBC Driver for Salesloft

Build 24.0.9175

Opportunities

Lists multiple Opportunity records. Returns Opportunity records synced from the CRM and created via API. The records can be filtered, paged, and sorted using the parameters below and external ID parameters.

Columns

Name Type Description
Id [KEY] Integer ID of the Opportunity.
Name String The Opportunity Name.
Amount String The Estimated total sale amount.
StageName String The Stage name.
Probability String The Probability.
CrmId String The identifier for this record in the CRM.
CrmType String The CRM type.
AccountCrmId String The Account CRM id.
OwnerCrmId String The Owner CRM id.
AccountName String The Account Full Name.
CreatedByCrmId String The Created By CRM id.
OpportunityType String The OpportunityType.
OwnerCrmName String The Owner Crm Name.
CrmLastUpdatedDate Datetime The Datetime of when the Opportunity was most recently updated in CRM.
CloseDate Datetime The Date when the opportunity is expected to close.
IsClosed Boolean Whether the opportunity is closed.
IsWon Boolean Whether the opportunity is closed won.
CrmUrl Boolean CRM url, currently Salesforce.com only.
CreatedAt Datetime The Datetime of when the Opportunity was created.
UpdatedAt Datetime The Datetime of when the Opportunity was last updated.
CreatedDate Datetime The Datetime of when the Opportunity was created in CRM.
OpportunityWindowPersonId Integer ID of when the attributed person was created in Salesloft.
OpportunityWindowStartedAt Datetime Datetime of when the attributed person was created in Salesloft.
CustomFields String Custom fields are defined by the user's team. Only fields with values are presented in the API.
CurrencyIsoCode String Currency ISO Code.
Tags String All tags applied to this Opportunities.
MostRecentCadenceId Integer The most recent cadence associated with the Opportunity.
MostRecentStepId Integer The most recent step associated with the Opportunity.
MostRecentStepNumber Integer The most recent step number associated with the Opportunity.
MostRecentStepAccountId Integer The most recent step account id associated with the Opportunity.
OwnerId Integer The owner associated with the Opportunity.
CreatorId Integer The creator associated with the Opportunity.
AccountId Integer The account that this opportunity is associated to.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175