--- name: rest-api-patterns description: "Use when designing, implementing, or reviewing Salesforce REST API integration — covering CRUD operations on sObjects, SOQL-based queries, paginated result sets, Composite requests, Composite Batch, and sObject Tree. Triggers: 'Salesforce REST API', 'composite API', 'nextRecordsUrl', 'sObject Tree', 'REST CRUD', 'REST pagination', 'API limits', 'OAuth Bearer token'. NOT for GraphQL API queries, Bulk API 2.0 large-data-load jobs, Metadata API deployments, or custom Apex REST endpoints." category: integration salesforce-version: "Spring '25+" well-architected-pillars: - Reliability - Scalability tags: - rest-api - composite - soql - pagination - oauth - api-limits triggers: - "how do I call the Salesforce REST API to create or update a record" - "which composite resource should I use for related record creation" - "how do I handle nextRecordsUrl when my SOQL query returns more than 2000 records" - "what is the difference between composite batch and composite requests in Salesforce" - "how do I stay within Salesforce API rate limits in an integration" - "how do I pass an OAuth Bearer token to the Salesforce REST API" inputs: - "operation type: CRUD on single record, batch of independent requests, parent-child insert, or paginated query" - "authentication context: OAuth 2.0 access token availability and Connected App configuration" - "org edition and API version to determine daily API limit and feature availability" - "record volume per call to choose between REST Composite, sObject Tree, or Bulk API" outputs: - "REST endpoint selection with correct base URL and HTTP verb" - "composite or sObject Tree request structure with referenceId wiring" - "pagination loop design using nextRecordsUrl" - "error handling strategy for 4xx/5xx and partial-failure responses" - "review findings for an existing REST integration" dependencies: [] version: 1.0.0 author: Pranav Nagrecha updated: 2026-04-04 --- # REST API Patterns Use this skill when the integration task involves calling the Salesforce REST API to read, create, update, or delete records, or when you need to compose multiple REST operations efficiently. This skill covers the standard sObject resources, SOQL query resources, the Composite family of resources, and the pagination and error handling patterns that hold an integration together in production. --- ## Before Starting Gather this context before working on anything in this domain: - What OAuth 2.0 flow is in use and is a valid access token available? Every REST call requires `Authorization: Bearer `. - What Salesforce edition is the target org? API limits (24-hour rolling limit) differ by edition — Developer Edition is 15,000 per day; Enterprise Edition is 1,000 per Salesforce license per day with a minimum of 1,000. - What API version should be used? Always use a recent version (Spring '25 = v63.0). Old versions are eventually deprecated and unsupported. The base URL is `/services/data/vXX.0/`. - What is the record volume per call? Use REST Composite (≤ 25 subrequests), sObject Tree (≤ 200 records), or Bulk API 2.0 (> 2,000 records) accordingly. --- ## Core Concepts ### Base URL and Versioning All REST API resources are relative to the instance base URL and include the API version: ``` https://.salesforce.com/services/data/v63.0/ ``` Always pin the version explicitly. Unversioned or pinned-to-old-version calls risk hitting deprecated behavior after a Salesforce release upgrade. ### Authentication: OAuth Bearer Token Every REST request must include the access token in the HTTP `Authorization` header: ``` Authorization: Bearer ``` The token is obtained via an OAuth 2.0 flow (Username-Password, JWT Bearer, Web Server, or Device). The Connected App must be configured with the appropriate OAuth scope (`api`, `full`, or a more targeted scope). Tokens expire; integrations must handle 401 responses and refresh or re-authenticate. ### sObject CRUD Resources Standard create/read/update/delete operations target the `/sobjects/` resource family: | Operation | HTTP Verb | Endpoint | |---|---|---| | Describe an sObject | GET | `/services/data/v63.0/sobjects/{SObject}/` | | Read by ID | GET | `/services/data/v63.0/sobjects/{SObject}/{id}` | | Read by External ID | GET | `/services/data/v63.0/sobjects/{SObject}/{ExternalIdField}/{value}` | | Create | POST | `/services/data/v63.0/sobjects/{SObject}/` | | Update | PATCH | `/services/data/v63.0/sobjects/{SObject}/{id}` | | Upsert by External ID | PATCH | `/services/data/v63.0/sobjects/{SObject}/{ExternalIdField}/{value}` | | Delete | DELETE | `/services/data/v63.0/sobjects/{SObject}/{id}` | A successful create returns HTTP 201 with a JSON body containing `{"id": "...", "success": true, "errors": []}`. A successful update or delete returns HTTP 204 with no body. ### SOQL Query Resource and Pagination Execute SOQL via the `/query/` resource: ``` GET /services/data/v63.0/query/?q=SELECT+Id%2CName+FROM+Account+LIMIT+200 ``` If the result set is larger than the batch size (default 2,000 records), the response includes `"done": false` and a `"nextRecordsUrl"` field: ```json { "totalSize": 5800, "done": false, "nextRecordsUrl": "/services/data/v63.0/query/01gXXXXXXXXXXXX-2000", "records": [...] } ``` Fetch subsequent pages by making a GET request to the absolute path given in `nextRecordsUrl` (prepend the instance host). Continue until `"done": true`. Do not attempt to reconstruct the query locator URL manually — use the value exactly as returned. ### Composite Resource The `/composite/` resource executes up to 25 subrequests in a single HTTP round trip. Subrequests are ordered and results from earlier subrequests can be referenced in later subrequests using `@{referenceId.fieldName}` syntax. ```json { "allOrNone": true, "compositeRequest": [ { "method": "POST", "url": "/services/data/v63.0/sobjects/Account/", "referenceId": "NewAccount", "body": { "Name": "Acme Corp" } }, { "method": "POST", "url": "/services/data/v63.0/sobjects/Contact/", "referenceId": "NewContact", "body": { "LastName": "Smith", "AccountId": "@{NewAccount.id}" } } ] } ``` When `allOrNone` is `true`, any single subrequest failure rolls back all subrequests in the call. When `false`, each subrequest result is independent. ### Composite Batch Resource The `/composite/batch/` resource executes up to 25 independent subrequests. Unlike `/composite/`, subrequests cannot reference each other's results. Each subrequest result is independent regardless of the `haltOnError` flag. Use Composite Batch when: - Requests are logically independent (no parent-child ID wiring) - You want to reduce HTTP round trips for unrelated operations ### sObject Tree Resource The `/composite/tree/{SObject}/` resource inserts up to 200 records in a single call, including parent-child related record trees: ``` POST /services/data/v63.0/composite/tree/Account/ ``` Up to 5 levels of nesting are supported. All records in the tree are committed atomically — partial success is not available. Records across the tree count toward the total 200-record limit. ### Error Response Format When a request fails, Salesforce returns an array of error objects: ```json [ { "message": "Required fields are missing: [Name]", "errorCode": "REQUIRED_FIELD_MISSING", "fields": ["Name"] } ] ``` Composite responses embed a `httpStatusCode` per subrequest alongside the error array. Always inspect individual subrequest bodies when using Composite or Composite Batch — an HTTP 200 outer response does not mean all subrequests succeeded. --- ## Common Patterns ### Composite Insert: Account with Related Contact **When to use:** You need to create a parent Account and a child Contact in the same transaction without two round trips and without knowing the Account ID in advance. **How it works:** Use `/composite/` with `allOrNone: true`. Set a `referenceId` on the Account subrequest and reference it in the Contact subrequest using `@{refId.id}`. The platform resolves the reference server-side before executing the Contact insert. **Why not the alternative:** Two separate REST calls require the caller to persist the Account ID between calls and handle partial failure (Account created, Contact failed) with compensating logic. The composite approach keeps both in a single atomic transaction. ### Paginated SOQL Query Loop **When to use:** Any query against a large data set where the result count may exceed 2,000 records. **How it works:** Issue the initial `/query/` request. If `done` is `false`, read `nextRecordsUrl` from the response and issue a GET to that URL (prefixed with the instance hostname). Repeat until `done` is `true`. Buffer or stream records per page — do not assume all records fit in memory. **Why not the alternative:** Setting an arbitrarily large `LIMIT` in SOQL does not bypass the batch size; the API still paginates. Ignoring `nextRecordsUrl` silently drops records — a hard-to-detect data integrity problem. ### Upsert by External ID **When to use:** An external system owns a record identifier and you want to create-or-update without first querying for the Salesforce ID. **How it works:** PATCH to `/sobjects/{SObject}/{ExternalIdField}/{value}`. If no record with that external ID exists, Salesforce creates it (HTTP 201). If one exists, Salesforce updates it (HTTP 200). The External ID field must be defined on the object and indexed. **Why not the alternative:** A query-then-insert-or-update pattern doubles round trips and introduces a race condition between the read and the write. --- ## Decision Guidance | Situation | Recommended Approach | Reason | |---|---|---| | Single record CRUD | `/sobjects/{SObject}/` | Simplest, no overhead | | Create parent + children with ID wiring | `/composite/` with `allOrNone: true` | Atomic, cross-reference support | | Multiple independent updates in one call | `/composite/batch/` | Reduces round trips without requiring ordering | | Bulk parent-child tree insert (≤ 200 records) | `/composite/tree/{SObject}/` | Atomic tree, fewer API calls | | > 2,000 record inserts or bulk queries | Bulk API 2.0 | REST API is not designed for large-volume jobs | | Query result set larger than 2,000 records | SOQL + `nextRecordsUrl` loop | Platform-managed pagination, no manual cursor math | | Create-or-update with external system key | Upsert via External ID PATCH | No pre-query needed, atomic | --- ## Recommended Workflow Step-by-step instructions for an AI agent or practitioner activating this skill: 1. Gather context — confirm the org edition, relevant objects, and current configuration state 2. Review official sources — check the references in this skill's well-architected.md before making changes 3. Implement or advise — apply the patterns from Core Concepts and Common Patterns sections above 4. Validate — run the skill's checker script and verify against the Review Checklist below 5. Document — record any deviations from standard patterns and update the template if needed --- ## Review Checklist Run through these before marking work in this area complete: - [ ] API version is pinned to a recent version (v60.0+) in all endpoint URLs. - [ ] `Authorization: Bearer ` is present on every request; 401 is handled with refresh logic. - [ ] Paginated queries check `done` flag and follow `nextRecordsUrl` until `true`. - [ ] Composite requests inspect per-subrequest `httpStatusCode` — outer HTTP 200 is not sufficient. - [ ] `allOrNone` setting on Composite requests is an explicit architectural choice, not a default. - [ ] Record volume per call is within limits: ≤ 25 subrequests for Composite/Batch, ≤ 200 records for sObject Tree. - [ ] Daily API limit is estimated against the org edition and load tested before go-live. - [ ] Error responses parse the `[{message, errorCode, fields}]` array; generic string matching on HTTP status is not enough. - [ ] External ID fields used for upserts are defined, indexed, and not shared across integration systems. --- ## Salesforce-Specific Gotchas Non-obvious platform behaviors that cause real production problems: 1. **HTTP 200 outer response masks subrequest failures in Composite** — When using `/composite/` or `/composite/batch/`, the outer HTTP response code is 200 even if individual subrequests return 4xx. Integrations that only check the outer status silently discard errors. 2. **`nextRecordsUrl` is not a full URL — it is a path** — The value returned in `nextRecordsUrl` is a relative path like `/services/data/v63.0/query/01gXXX-2000`. You must prepend the instance hostname. Treating it as a complete URL or re-constructing it from the query locator ID causes 404s or incorrect page fetches. 3. **API version deprecation is gradual but permanent** — Salesforce deprecates old REST API versions approximately every three years. Integrations pinned to old versions (e.g., v20.0–v40.0) stop working when the version is retired, with no runtime warning. Always pin to a version within the last four releases. 4. **Concurrent API request limits are separate from daily limits** — Salesforce enforces a limit on concurrent long-running API requests (default 25 per org for calls exceeding 20 seconds). Polling integrations and batch scripts that hold long-running REST calls open can hit this ceiling independently of the daily limit. 5. **sObject Tree is all-or-nothing at 200 records** — Unlike Composite with `allOrNone: false`, the sObject Tree resource does not support partial success. One invalid record in the tree rolls back the entire payload. Validate records client-side before sending large trees. --- ## Output Artifacts | Artifact | Description | |---|---| | Endpoint selection guide | Correct REST resource URL, HTTP verb, and request body shape for the requested operation | | Composite request scaffold | JSON request body with subrequests, referenceIds, and `allOrNone` setting | | Pagination loop design | Logic for following `nextRecordsUrl` until `done: true` with record buffering | | Error handling strategy | Per-subrequest error inspection pattern and 401 refresh logic | | API limit estimate | Daily and concurrent limit projection based on org edition and call volume | --- ## Related Skills - `integration/graphql-api-patterns` — use when the consumer needs flexible field selection from a single endpoint rather than fixed CRUD resources. - `integration/oauth-flows-and-connected-apps` — use when the authentication setup, Connected App scoping, or token refresh flow is the actual blocker. - `apex/apex-rest-services` — use when the org needs a custom command API exposed over REST, not a caller consuming the standard REST API. - `data/bulk-api-and-large-data-loads` — use when record volumes exceed 2,000 per operation and Bulk API 2.0 async job patterns are needed.