# \#upsert

**URL:** https://community.cdata.com/tag/upsert/191.md

[Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md)

---

## [How to Use an External ID to Perform an UPSERT Operation against Salesforce](https://community.cdata.com/t/how-to-use-an-external-id-to-perform-an-upsert-operation-against-salesforce/1252)

<div class="topic-metadata">

**Author:** [@Somya](https://community.cdata.com/u/Somya)\
**Replies:** 0\
**Last updated:** [December 11, 2025, 4:57am UTC](https://community.cdata.com/t/how-to-use-an-external-id-to-perform-an-upsert-operation-against-salesforce/1252 "2025-12-11T04:57:09Z")

</div>

The CData Salesforce connectivity solutions make it easy to synchronize data with Salesforce by enabling seamless UPSERT operations using External IDs. An External ID allows you to match records from your source system w…

---

## [How to use the UPSERT query?](https://community.cdata.com/t/how-to-use-the-upsert-query/242)

<div class="topic-metadata">

**Author:** [@russell-jerseypost](https://community.cdata.com/u/russell-jerseypost)\
**Replies:** 4\
**Last updated:** [September 11, 2023, 4:40pm UTC](https://community.cdata.com/t/how-to-use-the-upsert-query/242 "2023-09-11T16:40:51Z")

</div>

What should I put in the “”Perform this query to select the UPSERT key” box?