All Questions
Tagged with externalid upsert
30 questions
0
votes
0
answers
37
views
CumulusCI keyword for Upserting Data in case of External ID
Do we have any CumulusCI keyword for Upserting Data in case of External ID like we have for Insert, Get update and delete in CumulusCI Robot Framework Keywords
Can we use existing keyword for ...
- 187
0
votes
1
answer
1k
views
Duplicate Error on Upsert
I have created an operation in Jitterbit to run an upsert on two custom objects and one standard object: Lead, Project_c and ProjectLead_c
The ProjectLead object is just a junction object that relates ...
2
votes
1
answer
4k
views
Update (never insert) a record by External Id using REST API
Salesforce offers a way to upsert a record by a given External Id:
curl https://na1.salesforce.com/services/data/v20.0/sobjects/Account/customExtIdField__c/11999 -H "Authorization: Bearer token&...
- 689
3
votes
0
answers
199
views
UPSERT REST Api creates new record because of space(%20) urlencoding
I'm currently trying to use the salesforce UPSERT endpoint.
The ExternalId that I'm using contains a space, like so:
North America_12345
so my URL looks like:
/services/data/v49.0/sobjects/...
- 31
0
votes
1
answer
450
views
Upsert not working in apex class
I have two object temp__c and NFSave___c. I am dumping all the data in temp object through data loader in rich text area field(Section__c). Then I am sending the data with apex class from Section ...
-2
votes
1
answer
46
views
Check if upsert necessary
I am using external id and rest callout to another org, but is there a way to check if i need to make callout? Cause callout called even if all fields are the same. I can compare all fields, but its a ...
- 11
0
votes
1
answer
1k
views
Workbench upsert: how to use an External id?
I want to update a number of Cases using a CSV file that contains two fields: case number (NOT technical id, but the automatically generated human readable id/name) and a textual complaint.
Data ...
- 4,453
0
votes
2
answers
359
views
Update both Pricebook2 and PricebookEntry objects using just one for loop
Having the next code:
for (WrapperTest pb : pbs_lst) {
Pricebook2 newPB2 = new Pricebook2();
PricebookEntry newPBE = ...
- 365
0
votes
1
answer
1k
views
Upsert without an external Id
We have external system that is pushing an event using Platform events saying that an asset is changed. I have created a Platform event object and a trigger on it, make a webservice callout to get ...
- 565
0
votes
0
answers
159
views
Dealing with failed records in an Upsert operation
With the help of responses to my previous posts I was finally successful in Upserting Contacts in Salesforce via Jitterbit using External Id. However two records failed. I am thinking these failed ...
- 871
1
vote
1
answer
733
views
Check if Parent record exists using parent's External Id before inserting child
I have a child__c object that has a lookup relationship to Parent__c. Each have an ExternalId__c field in them.
I am trying to create this relationship when inserting a child record.
List<...
- 4,839
6
votes
2
answers
7k
views
How to use sfdx force:data:bulk:upsert on an object without an external ID?
I have a custom object (CustomObject__c) which is a child of another custom object. I want to import some records (CSV files) of CustomObject__c via SFDX (force:data:bulk:upsert).
These are the ...
- 361
0
votes
1
answer
334
views
How do I continue to upsert with a SOAP call that has lookups that can't find a record via external id?
I have a SOAP request that sets the lookup fields using the lookup object's external IDs. However, for one particular lookup, I can't guarantee that it will find a matching Salesforce record. If that'...
- 249
0
votes
1
answer
3k
views
External Id upsert
I know that with External Id, I can upsert a record and that will Insert or Update the record base on the External Id (update if exists or insert if not) instead of the regular Id.
Is there is a way ...
- 1,209
1
vote
0
answers
727
views
Record with duplicate external id was inserted through bulk API upsert
I have Account with user id as external id.
I have a record of Account with user id 123 created 2 months ago.
I have an upsert job created through bulk API yesterday with user id as ...
- 73
8
votes
2
answers
35k
views
updating a records using external Id in Apex
I copied the product data to another object named foo. I used only the name and externalId of product to copy it to Foo object. Foo's external id matches with product's external Id.
Some of my ...
- 4,839
1
vote
0
answers
865
views
Will not upsert on external ID (claims a MISSING_ARGUMENT)
I am upserting a list a list and it claims the external ID is missing. It is not missing as shown below.
I have broken my big upsert into a for loop to track the problem. I have played around with a ...
- 184
0
votes
2
answers
2k
views
Salesforce REST upsert for externalId cause DUPLICATE_VALUE error
I send next upsert request to Salesforce:
PATCH /services/data/v41.0/sobjects/Task/uuid__c/a22ac4d6-e2c0-4e53-898d-ea1d0c807775 HTTP/1.1
Host: **********.my.salesforce.com
Content-Type: application/...
- 161
1
vote
1
answer
969
views
Issue with External Id while upserting from external system using Salesforce SOAP API
We are facing some issue during upsert, please find details below:
We have following objects:
and sample data for the above objects:
The external system is trying to upsert TankRead__c with the ...
- 171
1
vote
2
answers
2k
views
updating the child record and linking it to parent
I have scnerio where I am loading the child record from an external system and I want to connect it with the parent record. But I do not have the sfdc id
of the parent record that I can put in the ...
- 4,839
2
votes
1
answer
2k
views
Add dynamic lookup on Contact to sObject with external Id
I'm trying to make something that reads csv's and imports the data for our users, but SF ids for the lookups on the Contact are cumbersome for them as they already know the External Ids of the object ...
3
votes
1
answer
3k
views
Upserting Data using Data Loader with External ID
I'm using Data Loader in order to Upsert some data within my Org.
I know, that if I will Upsert a record within my CSV that has duplicate External Id value with another record in the file, It will ...
- 85
0
votes
1
answer
2k
views
Using the DataLoader to upsert child records with a parent external id
Well, I just figured it out, but since I wrote it up already, I figured I'd post it here anyways in case anyone else has the same issue.
I have two custom objects Case__c and CaseActivity__c that ...
- 12.7k
0
votes
1
answer
324
views
Calculating the externalId field value using Dataloader CLI
I have a dataloader CLI process setup to import a csv file from a share folder. I am upserting to an object in Salesforce. This object is a junction object called employee training.
The junction has ...
- 4,839
2
votes
1
answer
2k
views
How do i Upsert record in Parent- child relationship from custom to custom object Using External ID
We have data integration Job for SQL SERVER - SFDC using Talend data integration tool.
SFDC environment:
Full sandbox Account
We have two custom object.
In that, Master-Detail relationship from ...
- 167
1
vote
1
answer
299
views
Conditionally using External ID in upsert function
I want to use external id to reference a parent record on a lookup field. The problem is if this external id can't target that record, I just want to leave that lookup field a null.
Contact ct = new ...
- 11
1
vote
1
answer
2k
views
How Does Upsert Work When No External Id Is Specified?
I have looked at the documentation on Database Methods. What I do not understand is, what happens when an upsert is performed without specifying an external id field? Is it just based on whether or ...
- 151k
1
vote
1
answer
623
views
Why does upsert check lookup to determine duplicates rather than ID?
In a salesforce project, I have an object called Project__c which I want to upsert.
I have recently added a lookup to the Project__c object and now when I do an upsert project, the following error ...
- 480
0
votes
2
answers
4k
views
How to insert (upsert) an object that has no external id?
According to this documentation, you need to know the external ID field of an object to inset new records. For some of my custom objects, I'm not seeing any fields in the object description that have ...
- 1,069
2
votes
1
answer
1k
views
Order of Bulk API result rows
I am performing multiple batch upserts using the Bulk API using an external ID field from my system. In order to determine which record ids from my system failed, I'd need the results rows to ...
- 149