Opportunities

Opportunity records from Copper CRM with filtering

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		Primary identifier for opportunity record
Name	String	False		Opportunity name
AssigneeId	Integer	False		User ID assigned to this opportunity
CloseDate	Date	False		Expected close date
CompanyId	Integer	False		Associated company ID
CompanyName	String	True		Associated company name
CustomerSourceId	Integer	False		Source of the opportunity
DateCreated	Datetime	True		Unix timestamp of creation
DateModified	Datetime	True		Unix timestamp of last modification
Details	String	False		Additional opportunity details
LossReasonId	Integer	False		Reason for lost opportunity
MonetaryUnit	String	False		Currency unit for the opportunity value
MonetaryValue	Integer	False		Opportunity value
ConvertedUnit	String	True		Converted currency unit
ConvertedValue	Integer	True		Converted opportunity value
PipelineId	Integer	False		Sales pipeline identifier
PipelineIsRevenue	Boolean	True		Whether this pipeline tracks revenue
PipelineStageId	Integer	False		Current pipeline stage
PipelineType	String	True		Type of pipeline (opportunity, etc.)
PrimaryContactId	Integer	False		Primary contact person ID for this opportunity
Priority	String	False		Opportunity priority level
Status	String	False		Opportunity status
Tags	String	False		Array of tag strings
InteractionCount	Integer	True		Number of interactions recorded
CustomFields	String	False		Array of custom field objects with custom_field_definition_id and value fields
WinProbability	Integer	False		Probability of winning (0-100)
DateStageChanged	Datetime	True		Unix timestamp when pipeline stage was last changed
DateLastContacted	Datetime	True		Unix timestamp of last contact
LeadsConvertedFrom	String	True		Array of lead IDs that were converted to this opportunity
DateLeadCreated	Datetime	True		Unix timestamp when the original lead was created