Questions tagged [upsert]
All queries related to Upsert can be grouped under this Tag
225 questions
1 vote
1 answer
470 views
Can I Use External ID for Upsert in REST API for a Hierarchy field?
I am using the REST API to upsert records, using external IDs. It's working perfectly for standard fields, as well as lookup fields using the following structure (as shown here): { "...
0 votes
0 answers
95 views
Upserting Salesforce records from a CRMA recipe not working
My attempts to do this are failing, and I haven't had any luck searching for answers. The goal: Read data from an external source Apply some transformations Upsert: match on an external id to records ...
0 votes
1 answer
150 views
Standard Name field allows Upsert and parent-linking in DML like External ID
I was playing around with a two Custom Objects, connected by Lookup relationships, and noticed that system allows to insert the children object with valid link to parent using just a standard Name ...
0 votes
1 answer
61 views
Getting NOT_FOUND: The requested resource does not exist error from gcp cloud run
I am getting the below error in the GCP cloud run when trying to upsert a case into salesforce via an external id: NOT_FOUND: The requested resource does not exist. I have googled this error and all ...
-1 votes
1 answer
81 views
Upsert without ExternalId using Database.upsert(sObjectToUpsert, false);?
Apex allows me to do an upsert operation without the ExternalId field using the below syntax, Database.upsert(sObjectToUpsert, false); But I am not sure Salesforce recommends it, I can't find any ...
0 votes
1 answer
499 views
Database.Upsert and (External ID) Wont Upsert
I have a script that does an upsert on Contacts based off of a unique external ID. I am confused why I am getting duplicate errors as the failure response. I know this record already exists in the DB, ...
0 votes
1 answer
159 views
How to get Database.UpsertResult Error result Field values
I want to see the records that are failed via Database.UpsertResult. Need to check the error Message and Some required field values like Case Subject, Description other custom fields Schema....
1 vote
1 answer
101 views
(SSJS Cloudpage Error while batching records) Fetching Records: Unable to retrieve security descriptor for this frame
I have a cloudpage which serves the purpose of ejecting records from existing journey(s). The credentials are stored in a BU Package DE, so are the records in an ejection DE. Since the exit contact ...
0 votes
0 answers
119 views
how to override user's locale for number format in Apex data upsert operation
I've a Database.upsert operation on Apex base. But a user's locale(who runs the upsert operation) is Kyrgyz (Kyrgyzstan). Because of the number format that user has the numbers being upserted without ...
0 votes
0 answers
905 views
INVALID_CROSS_REFERENCE_KEY when upserting a custom object record via API
I've written a new API in GoLang to handle object syncs from our proprietary software to sync with the records in Salesforce following the steps to "Upsert a Record" in Salesforce on the ...
0 votes
0 answers
48 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 ...
2 votes
1 answer
238 views
SSJS functions - Platform.Function.GUID() and Platform.Function.UpsertData - no records in Data Extension
Trying to use ssjs 2 functions - Platform.Function.GUID() and Platform.Function.UpsertData in the Script Activity Added Script Activity into the Automation and executed Run Once. No errors, however no ...
0 votes
1 answer
88 views
Extended Response Time with simple_salesforce Library's upsert method
Problem Statement: I'm encountering prolonged response times exceeding 30 seconds while using the simple_salesforce library to perform upsert operations in batches using the bulk functionality. The ...
0 votes
1 answer
225 views
Can i upsert to History objects like CaseHistory?
I am trying to do so and I am getting the following error: Invalid status code: 400, response body: [{"errorCode":"INVALIDJOB","message":"InvalidJob : No create/...
0 votes
0 answers
516 views
Bulk API 2.0: Can I insert AND upsert in one csv request?
Edited to clarify: Background info on what I'm working on – we're going to be receiving email lists from clients, and we want to create new Leads or update existing Leads in Salesforce with the info ...