CRM

List opportunities

Lists opportunities with filters by pipeline, stage, status, owner, contact, source and amount.

Action
crm.opportunities.findMany
PropertyValue
Domaincrm
Group in the editorCRM › Opportunities
Runs asThe owner of the workflow, with their permissions
PermissionView access to CRM. Administrators always pass; a module outside the plan blocks everyone.
Add-onCRM
DestructiveNot declared

Inputs

pipelineIdstring

pipelineIdsstring[]

Filter by one or more pipelines. Accepts up to 50 values and returns whatever matches any of them.

stageIdsstring[]

Filter by one or more stages within the pipeline.

Limits: advanced

statusenum<string>

Available options: open, won, lost, all

statusesstring[]

Filter by one or more statuses. Accepts up to 50 values and returns whatever matches any of them.

Available options: open, won, lost, all

ownerStaffIdstring

ownerStaffIdsstring[]

Filter by one or more owners (staff ID). Accepts up to 50 values and returns whatever matches any of them.

contactIdstring

Limits: advanced

contactIdsstring[]

Filter by one or more contacts. Accepts up to 50 values and returns whatever matches any of them.

Limits: advanced

companyIdstring

Limits: advanced

companyIdsstring[]

Filter by one or more companies. Accepts up to 50 values and returns whatever matches any of them.

Limits: advanced

sourceenum<string>

Available options: inbound_email, website_form, referral, cold_outreach, event, social, existing_customer, partner, other

Limits: advanced

sourcesstring[]

Filter by one or more source channels. Accepts up to 50 values and returns whatever matches any of them.

Available options: inbound_email, website_form, referral, cold_outreach, event, social, existing_customer, partner, other

Limits: advanced

amountMinstring

Limits: advanced

amountMaxstring

Limits: advanced

amountEqualsstring

Limits: advanced

amountAbovestring

Limits: advanced

amountBelowstring

Limits: advanced

expectedCloseOnstring

Limits: advanced

expectedCloseAfterstring

Limits: advanced

expectedCloseBeforestring

Limits: advanced

expectedCloseFromstring

Limits: advanced

expectedCloseTostring

Limits: advanced

limitnumberdefault:100

Limits: min 1, max 500

Outputs

itemsobject[]

Show child attributes
items.opportunityIdstring

items.identifierstring

items.namestring

items.statusenum<string>

Available options: open, won, lost

items.amountstring

items.currencystring

items.pipelineIdstring

items.pipelineNamestring

items.stageIdstring

items.stageNamestring

items.stageTypeenum<string>

Available options: open, won, lost

items.effectiveProbabilitynumber

items.weightedAmountstring

items.daysInStagenumber

items.expectedCloseDatestring | null

items.contactNamestring | null

items.companyNamestring | null

items.ownerNamestring | null

items.sourceenum<string> | null

Available options: inbound_email, website_form, referral, cold_outreach, event, social, existing_customer, partner, other

items.createdAtstring

items.updatedAtstring

nextCursorstring | null

totalnumber