opportunity/getAll

Query and retrieve multiple Opportunity records with an optional filter and limit.

When to Use

Pull all open opportunities closing this month for a weekly pipeline report.
List all opportunities in a specific stage that have been stalled for over 14 days.
Retrieve all opportunities for an account as part of a renewal analysis.
Generate a daily digest of high-value deals above a revenue threshold.

Configuration

Connection

Field	Type	Required	Description
`InstanceUrl`	string	required	Salesforce org URL.
`AccessToken`	string	required	Valid OAuth2 access token.

Operation Fields

Field	Type	Required	Description
`Query`	string	optional	SOQL WHERE clause filter, e.g. `IsClosed = false AND CloseDate = THIS_MONTH`.
`Limit`	int	optional	Maximum number of records to return.

Sample Configuration

{
  "Resource": "opportunity",
  "Operation": "getAll",
  "InstanceUrl": "https://myorg.my.salesforce.com",
  "AccessToken": "{{credentials.salesforce.accessToken}}",
  "Query": "IsClosed = false AND CloseDate = THIS_MONTH AND Amount > 50000",
  "Limit": 100
}

Validation Errors

Error Code	Condition
`CFG_MISSING_INSTANCE`	`InstanceUrl` is missing.
`CFG_MISSING_TOKEN`	`AccessToken` is missing.
`UNEXPECTED_ERROR`	Unexpected exception.

Output

Success Port

Field	Type	Description
`records`	array	Array of Opportunity objects.
`totalSize`	int	Number of records returned.
`resource`	string	Always `opportunity`.
`operation`	string	Always `getAll`.

Error Port

Field	Type	Description
`errorCode`	string	Machine-readable error code.
`message`	string	Error description.

Sample Output

{
  "records": [
    { "Id": "0065g000005RstUVW", "Name": "Acme Corp — Enterprise Q3", "Amount": 120000, "StageName": "Proposal/Price Quote", "CloseDate": "2026-09-30" },
    { "Id": "0065g000005AbcXYZ", "Name": "Beta Ltd — Platform Upgrade", "Amount": 75000, "StageName": "Negotiation/Review", "CloseDate": "2026-09-15" }
  ],
  "totalSize": 2,
  "resource": "opportunity",
  "operation": "getAll"
}

Expression Reference

Expression	Description
`{{nodes.GetAllOpps.records}}`	Array of Opportunity records.
`{{nodes.GetAllOpps.totalSize}}`	Count of records returned.
`{{nodes.GetAllOpps.records[0].Amount}}`	Amount of the first opportunity.

Node Policies & GuardRails

Policy	Detail
Credential storage	Store `AccessToken` in BizFirst Credentials Manager.
Query filter safety	Never interpolate unsanitized input into `Query`.
Limit enforcement	Always set a `Limit` to control result set size.
Error port wiring	Always wire the error port.
Sandbox testing	Test in sandbox before production.

Examples

Monthly Pipeline Report

{ "Query": "IsClosed = false AND CloseDate = THIS_MONTH", "Limit": 200 }
// Pass to report generator or email digest node

Stalled Deal Alert

{ "Query": "StageName = 'Proposal/Price Quote' AND LastModifiedDate < LAST_14_DAYS AND IsClosed = false", "Limit": 100 }

High-Value Deal Digest

{ "Query": "Amount >= 100000 AND IsClosed = false", "Limit": 50 }
// Send Slack summary to VP of Sales