Skip to main content

Questions tagged [upsert]

All queries related to Upsert can be grouped under this Tag

Filter by
Sorted by
Tagged with
1 vote
1 answer
50 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 ...
aryashah2k's user avatar
0 votes
0 answers
37 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 ...
batuayyildiz's user avatar
0 votes
0 answers
71 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 ...
palmPixel's user avatar
0 votes
0 answers
31 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 ...
Pronit Agrawal's user avatar
2 votes
1 answer
69 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 ...
Luiza Zdebska's user avatar
0 votes
1 answer
59 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 ...
Mahesh Patil's user avatar
0 votes
1 answer
93 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/...
Kestrel's user avatar
  • 11
0 votes
0 answers
196 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 ...
Brittany Layne Rapheal's user avatar
-2 votes
2 answers
92 views

How can one copy account data from one org to another without errors? Is it possible to do so without mapping all fields?

How can this upload be done without mapping all the fields from source instance? Is it possible to do so without any errors?
QueenB's user avatar
  • 11
0 votes
1 answer
115 views

issue with UpsertDE "Unable to retrieve security descriptor for this frame"

I'm trying to write results in a Data Extension but this is the message response in the cloud page {"message":"Unable to retrieve security descriptor for this frame.","...
Juan's user avatar
  • 1
0 votes
1 answer
580 views

Error Message: "Unable to retrieve security descriptor for this frame." - Get JSON Data using SSJS in SFMC

I've just started to get my head round SSJS and tried this simple script from a tutorial as the script I wrote (same logic) was erroring in the same way. I am looking to upsert data into a DE from a ...
Eddie Belhay's user avatar
0 votes
0 answers
184 views

How to prevent same coupon code assignment to multiple email addresses in SFMC using AMPscript

Current use-case / scenario: We have a cloud page that is used as an API endpoint. Within the cloud page, there is an Ampscript set @coupon_Code = Lookup("Coupon_DE","Coupon_Code",&...
kl2's user avatar
  • 353
0 votes
1 answer
561 views

UpsertDE function not working on Shared Data Extension using SSJS from child BU even though used ENT

I want to use UpsertDE function on Shared Data Extension using SSJS from child BU. Even I tried ENT. before DE name, I have received 500 error in cloud page and script activity is getting errored in ...
SFMCuser's user avatar
3 votes
0 answers
467 views

Duplicates value on record, on Upsert. Upsert shouldn't cause duplicate check?

We have a pipeline built for moving data from our custom app through Mulesoft (Anypoint). The Mulesoft app is utilizing the Mule-provided Salesforce Connector, and we're performing single Upsert calls ...
Matt P's user avatar
  • 145
2 votes
2 answers
259 views

How can I dynamically upsert data in object

I want to upsert data in SF based on the selected columns by the user. I make HTTP callout to an external service and it returns the data. Then, I want to iterate over the each returned row and create ...
Stojchesky's user avatar
1 vote
1 answer
1k views

Upsert with two external_id in APEX

I can upsert objects with one external_id like below: upsert objects external_id_a; But I want to upsert with two external_id like upsert objects external_id_a external_id_b; But It's wrong syntax. ...
Richard's user avatar
  • 33
1 vote
1 answer
1k views

How can we upsert a record in the object, querying by a particular field?

How can we upsert (insert if not found, update if found) a record in the object, querying by a particular field (in our case: UserID__c)? We tried to PATCH the following request URL: $userId = $_POST['...
Platoscave's user avatar
0 votes
1 answer
805 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 ...
Milan Stegnjaic's user avatar
0 votes
1 answer
292 views

Product name upsert to a data extension on click and redirection to cloud thank you landing page through AMPscript

as the title says, I have a number of products in an email in SFMC. On click on any of the products, I'm trying to capture the product clicked on, upsert the name of it to a Data Extension then open / ...
Snowalker's user avatar
  • 369
2 votes
1 answer
128 views

SOAP XSL Integration error during upsert: "cannot specify Id"

Below is an example of the SOAP request that is being sent to Salesforce from our app. <?xml version="1.0" encoding="UTF-8"?> <soap:Envelope xmlns:soap="http://...
Gonzalo's user avatar
  • 23
2 votes
0 answers
60 views

How do I perform Upsert using Enterprise WSDL v54?

Attempting to use the Upsert function contained in the Enterprise WSDL (Salesforce Sandbox) version 54. Unfortunately not very familiar with SF development or Upserts, the documentation on the ...
Bob P's user avatar
  • 31
0 votes
1 answer
997 views

SQL query to update field only if it is empty

I need to run a query which updates a target DE with some rows from another. There is a field called 'origin' which shows on the target data extension where the data came from. I appreciate this may ...
TCassa's user avatar
  • 878
1 vote
1 answer
1k views

How to get UpsertData function to insert data into the data extension?

On the landing page I have a form that is submitting and gathering all the RequestParameter values. When it gets to the UpsertData function it doesn't fire even the few values I have in the function ...
Ryan's user avatar
  • 11
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&...
mmm321321's user avatar
  • 659
0 votes
0 answers
149 views

REQUIRED_FIELD_MISSING when saving data

Hello I'm getting this error when saving data from a form to database. This field isn't a field from My contact I just add it to try to solve the issues, but nothing happens. 11:32:59:059 FATAL_ERROR ...
Juan Pablo Vila's user avatar
-1 votes
1 answer
121 views

Get records modified by SF Data Loader App (or get history of jobs on it)

I did some bulk upserts using csvs and SF Data Loader. However, my formatting was off for my external Id and "duplicate" records were created instead. Is there a simple option to revert jobs ...
user2402616's user avatar
3 votes
0 answers
179 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/...
Luis Valdez's user avatar
0 votes
1 answer
399 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 ...
sfdc developer's user avatar
1 vote
0 answers
630 views

DataLoader batch job failing with PricebookEntry upsert

I have an issue with our PRICE BOOK ENTRY Upsert using the DataLoader batch bulk job. We have External IDs in our PRICE BOOK and PRODUCT objects that we use when Upserting to our PRICE BOOK ENTRY ...
VinceD's user avatar
  • 11
-2 votes
1 answer
44 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 ...
Femladamli's user avatar
0 votes
1 answer
262 views

Rest upsert callout

How can i make an upsert callout? I have object Contact with custom ExtId with Custom_Object__c id. So i am tried post, patch method and without/with '?_HttpMethod=PATCH'; What do i need to do? I ...
Femladamli's user avatar
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 ...
Sander de Jong's user avatar
1 vote
1 answer
1k views

Python Simple Salesforce - Upsert to CampaignMembers Object

I am trying to find an automated way to add contacts & leads to existing campaigns by using simple salesforce to upsert records to the CampaignMembers object. I have a CSV file with CampaignId and ...
codr's user avatar
  • 23
0 votes
1 answer
865 views

Upsert list<SObject> with external id

I want to upsert a list of generic sobject with the external id field. This list of generic sobject contains records from different sobjects, where the sobject type will be unknown and will be ...
sfdeveloper21's user avatar
0 votes
1 answer
277 views

Is it possible to perform upsert operation on UserTeritorry2Association?

I am writing a batch class on the UserTerritory2Association SObject and I need to perform an upsert operation. I have tried to use insert and records are getting created but if I need to do upsert I ...
Night Guy's user avatar
  • 214
0 votes
1 answer
109 views

upsert operation using IdLookup

I want to perform insert and upadate operation on Account on same record by using following query but It inserts two accounts with different descriptions Account acct = new Account(Name = 'practice ...
Shivani Tanwar's user avatar
0 votes
1 answer
103 views

can we insert a date value when the Closing date on opportunity is Null using a before trigger?

we are using dataloader to upsert records into Opportunity object but there might a case where there is no Closing date for some records, in that case, can we insert a particular date value using ...
user94412's user avatar
0 votes
2 answers
341 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 = ...
CPS's user avatar
  • 365
0 votes
1 answer
355 views

The Query Cost of UPSERT

In an Apex Test, I'm getting the 'Too many SQL queries: 100' error. Quite a lot happens in the code that is called (it's an API endpoint, not just a single function) and in one scenario, the end point ...
cyberspy's user avatar
  • 210
0 votes
1 answer
158 views

Block an insert call or convert it to upsert in trigger

Zapier connects our forms to our Salesforce instance. However, Zapier does not provide an upsert call as a way to insert a record, only insert and update. This means we have to use up more of our ...
Doodool_Tala's user avatar
0 votes
1 answer
953 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 ...
Balaji Pooruli's user avatar
0 votes
1 answer
3k views

Upsert DML Operation

Consider the below code. I thought the way upsert DML works is that if it sees that there is a new record with matching key (here in this case there is already an account with Name = Acme and ...
Krishnamurthy's user avatar
0 votes
1 answer
308 views

How can I update opportunity / account / product with a Json that gives a web service as a response?

enter code here currently the web service receives as a parameter a Json that is sent with salesforce information of opportunity / account / products. In turn, the web service generates a Json ...
Jesús Merino's user avatar
0 votes
0 answers
598 views

Apex upsert duplicate external id specified error

Long time listener, first time caller (and apex-er). I have a class to copy subscription items to a custom ARR Sub Line object; from there I can use out of the box rollups to pull my ARR onto ...
Brendan's user avatar
0 votes
1 answer
455 views

How to update Email Opt Out field?

Is there any way to update the Email Opt out field ? this is OOTB field in SF but when i trying to save my code IDE told my " field is not writeable" The API name is IsEmailBounced
artist's user avatar
  • 145
0 votes
0 answers
328 views

stripinaccessible stripping fields for system administrator

I have a generic function to validate CRUD before DML which uses stripInaccessible(). public static SObjectAccessDecision validateCRUD(AccessType access, List<SObject> records, Boolean ...
N_H1922's user avatar
  • 315
0 votes
1 answer
262 views

Bulk API upsert error for a Field type Location

I'm using the Bulk API v2 for upserting data into a CustomObject. When i try to upsert data without the CustomField Location, it works correctly, but when i add in the CSV the Location__c header, i'm ...
kassam housseny's user avatar
0 votes
0 answers
395 views

Use Database.upsert with external id field is not working on PricebookEntry object

I need help to do a DML operation with external id field. I am using the below syntax, but it is throwing an error Schema.SObjectField f = PricebookEntry.Fields.Product_Code__c; Database.UpsertResult[...
jsmith's user avatar
  • 185
1 vote
2 answers
1k views

Force RecordTypeId to Null on Contact

I am working in a very old org where majority of the contacts do not have a recordtypeid, and contact visibility, page layout assignments revolve around this master no record type id contact record. ...
S.B.'s user avatar
  • 2,111
0 votes
0 answers
134 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 ...
GroundToCloud's user avatar

1
2 3 4 5