Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options questions only not deleted user 16540

All queries related to Upsert can be grouped under this Tag

14 votes
5 answers
38k views

Why does upsert cause a DUPLICATE_VALUE error?

When I upsert two records with identical Name/ID, but otherwise different values, in two separate upsert statement, one record results, as expected. … When I create a list, add these records to the list, and then upsert the list, I get a DUPLICATE_VALUE error. What gives? By definition, upsert should not do this, should it? …
Sander de Jong's user avatar
0 votes
1 answer
1k views

Workbench upsert: how to use an External id?

This is right before you start the actual upsert: But when I click "Confirm Upsert", all records are rejected: "CaseNumber Not Specified, MISSING_ARGUMENT" If I preview the CSV file, CaseNumber is filled …
Sander de Jong's user avatar