Portal Community

account/getAll

Query and retrieve multiple Account records from Salesforce with an optional filter and limit.

When to Use

Configuration

Connection

FieldTypeRequiredDescription
InstanceUrlstringrequiredSalesforce org URL.
AccessTokenstringrequiredValid OAuth2 access token.

Operation Fields

FieldTypeRequiredDescription
QuerystringoptionalSOQL-style WHERE clause, e.g. Type = 'Customer' AND Industry = 'Technology'.
LimitintoptionalMaximum number of records to return.

Sample Configuration

{
  "Resource": "account",
  "Operation": "getAll",
  "InstanceUrl": "https://myorg.my.salesforce.com",
  "AccessToken": "{{credentials.salesforce.accessToken}}",
  "Query": "Type = 'Customer' AND Industry = 'Technology'",
  "Limit": 200
}

Validation Errors

Error CodeCondition
CFG_MISSING_INSTANCEInstanceUrl is missing.
CFG_MISSING_TOKENAccessToken is missing.
UNEXPECTED_ERRORUnexpected exception during execution.

Output

Success Port

FieldTypeDescription
recordsarrayArray of Account objects with full field sets.
totalSizeintNumber of records returned.
resourcestringAlways account.
operationstringAlways getAll.

Error Port

FieldTypeDescription
errorCodestringMachine-readable error code.
messagestringHuman-readable error description.

Sample Output

{
  "records": [
    {
      "Id": "0015g000007HijKAB",
      "Name": "Acme Corporation",
      "Type": "Customer",
      "Industry": "Technology",
      "AnnualRevenue": 50000000
    },
    {
      "Id": "0015g000007JklLMN",
      "Name": "Beta Systems",
      "Type": "Customer",
      "Industry": "Technology",
      "AnnualRevenue": 12000000
    }
  ],
  "totalSize": 2,
  "resource": "account",
  "operation": "getAll"
}

Expression Reference

ExpressionDescription
{{nodes.GetAllAccounts.records}}Full array of Account records.
{{nodes.GetAllAccounts.records[0].Id}}First account's Salesforce ID.
{{nodes.GetAllAccounts.totalSize}}Count of records returned.

Node Policies & GuardRails

PolicyDetail
Credential storageStore AccessToken in BizFirst Credentials Manager.
Query filter safetyNever interpolate unsanitized user input into Query.
Limit enforcementAlways set a Limit to prevent large unintended result sets.
Large datasetsFor full account exports, use soql/executeWithPagination.
Error port wiringAlways wire the error port.

Examples

Monthly Customer Account Report

{ "Query": "Type = 'Customer'", "Limit": 500 }
// Pass records to a reporting or email node

Technology Industry Campaign

{ "Query": "Industry = 'Technology' AND CreatedDate = THIS_YEAR", "Limit": 300 }

Territory Reassignment

{ "Query": "OwnerId = '{{variables.departingRepId}}'", "Limit": 500 }
// Loop: account/update each with new OwnerId