In Salesforce Data Loader, what is the difference between Insert and Upsert operations?

Salesforce Admin Hard

Salesforce Admin — Hard

In Salesforce Data Loader, what is the difference between Insert and Upsert operations?

Key points

  • Insert and Upsert have distinct use cases based on record existence.
  • Matching IDs drive Upsert's update functionality.
  • Insert does not update existing records.
  • Upsert supports both creation and updates.
  • External IDs and Salesforce IDs are used for matching.

Ready to go further?

Related questions