---
schema_version: "1"
id: a5b7c86aaa1db49275348b34e3dec0a10e4d7922eb6c4a1b4f8840d06431feaf
title: sObject Rows by External ID
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform/api-rest/guides/resources/resources-sobject-upsert.md
canonical_url: https://developer.salesforce.com/docs/platform/api-rest/guide/resources-sobject-upsert.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 59286d53634a19c194bf08464d0b4a7450f8dd5fba4eba6c647907a28bc7346b
products:
  - REST API Developer Guide
  - Platform Developer Content
---

# sObject Rows by External ID

Creates, retrieves, upserts, or deletes records based on the value of a specified external ID field. By using the PATCH method with this resource, you can send upsert requests to Salesforce.

-   **[Get Records Using sObject Rows by External ID](https://developer.salesforce.com/docs/platform/api-rest/guide/resources-sobject-upsert-get.md)**  


    Retrieves a record based on the value of the specified external ID field.

-   **[Create Records Using sObject Rows by External ID](https://developer.salesforce.com/docs/platform/api-rest/guide/resources-sobject-upsert-post.md)**  


    Creates a new record based on the field values included in the request body. This resource does not require the use of an external ID field.

-   **[Upsert Records Using sObject Rows by External ID](https://developer.salesforce.com/docs/platform/api-rest/guide/resources-sobject-upsert-patch.md)**  


    Upserts a record based on the value of the specified external ID field. Based on whether the value of the external ID exists, the request either creates a record or updates an existing one.

-   **[Delete Records Using sObject Rows by External ID](https://developer.salesforce.com/docs/platform/api-rest/guide/resources-sobject-upsert-delete.md)**  


    Deletes a record based on the value of the specified external ID field.

-   **[Return Headers Using sObject Rows by External ID](https://developer.salesforce.com/docs/platform/api-rest/guide/resources-sobject-upsert-head.md)**  


    Returns only the headers that are returned by sending a GET request to the sObject Rows by External ID resource. This gives you a chance to see returned header values of the GET request before retrieving the content itself.