Questions tagged [upsert]

All queries related to Upsert can be grouped under this Tag

Filter by
Sorted by
Tagged with
0
votes
0answers
15 views

Contact to Multiple Accounts via jitterbit

I have set up Contacts to Multiple Accounts We plan to write a jitterbit query to pull data from an external system to UPSERT Contacts in Salesforce. My question is - When UPSERTING Contacts ...
0
votes
0answers
45 views

Merge Duplicate Contacts

So I have Salesforce system that was implemented 6 years ago and sits ontop of a extremely old sales system. When implemented it was built in a way that it creates duplicate contacts on different ...
0
votes
1answer
80 views

User Upsert View All Data error through api

[{"message":"ViewAllData or ViewAllRecords required to upsert by standard field","errorCode":"INSUFFICIENT_ACCESS"}] I'm trying to upsert to an existing record by the ID using a PATCH call. Closest ...
0
votes
1answer
62 views

Upsert error with apex batch job

I have a custom object named AttendanceRate with 5 fields "AttendanceRate_' + weekDay + -'__c' for each day of the week. When a user creates an activity, he has 100% of attendanceRate for this day, ...
0
votes
1answer
46 views

Insert JSON to salesforce

I have a JSON which I got from An outer System to Salesforce and I should eventually insert it to SF. { "AFTR0": [ { "AFTR1":"U", "AFTR2": "3dcda8f9213ad43aafe456ae489a158b", "...
0
votes
0answers
99 views

Upsert Data with dataLoader using multiple keys

Is there a way to import Data with DataLoader \ Wizard using 2 keys? For example - I want to import Data (Upsert) when the unique key is actually built from 2 keys : externalId field and a ...
0
votes
0answers
278 views

Before Insert, Before Update Trigger

I have a trigger that runs on before insert and before update using trigger.new. I am sending data in batches, so the tirgger.new holds multiple records, some inserts, some updates. I also have some ...
0
votes
0answers
91 views

Opportunity Trigger with Upsert

I have an opportunity trigger that runs before insert and before update. It has a recursive check on the before update and a separate one on the before insert so that each only run once. I am pushing ...
0
votes
1answer
209 views

testing upsert campaign members gives error: INVALID_CROSS_REFERENCE_KEY, invalid cross reference id: []

Testing my apex controller in my dev org runs fine. However, testing the same file in another dev org gives error INVALID_CROSS_REFERENCE_KEY, invalid cross reference id: [] Here is the controller ...
0
votes
1answer
316 views

Restrict update existing record while upserting from Data loader

I am going to load data using WorkBench/Dataloader using UPSERT (ExternalId__c) DML operation. Once this ExternalId__c is matched then we have to check one more thing like Sr_number__c in that ...
0
votes
1answer
38 views

Can't upsert data with external ID's using Data Loader

Similar to this question, I am not shown the related object windows to define what object the record is related to. I have tried manually editing the mappings but it always returns the same "Field ...
0
votes
1answer
551 views

Can't update existing record with external ID

I have this script that gets time entries from a time tracking tool and that I'm trying to push into a custom object in Salesforce : Time_Entry__c. After following this help page : https://developer....
0
votes
1answer
155 views

How can I find out what fields made my upsert fail?

I'm trying to upsert some records. I use Database.upsert. If the failure is related to a duplicate value (external ids that have to be unique) I need to know what fields are duplicate and clear (...
0
votes
2answers
163 views

Dataloader upsert error

While I am doing an upsert operation in data loader, I am getting an error as: unable to obtain access to these records. What could be a possible reason for this?
0
votes
1answer
181 views

Does Insert happen for new records if I perform upsert on partial/full sandbox using Salesforce Id (instead of external id) from source?

Suppose I have records exported from source which includes records which are already in partial sandbox (Salesfoce Ids will be same for such records in source and partial sandbox) and some new records ...
0
votes
1answer
577 views

Update not working for Visual Force Page fields

I am writing a class to update a record with data from visual force page if it exists in contact, if it does not it will insert a row.I am using Update and Insert statements for this purpose.Looks ...
0
votes
2answers
428 views

Upsert not updating existing rows with visual force fields

I have a custom VF page and a custom class. There are several fields on the page. When Submit button is hit, a new row will be inserted if does not exit or the row will be updated if it already exists....
0
votes
1answer
152 views

value not updating from upsert

when click on edit outputlink text show in inputfield work fine but when save record its create new record instead of updating. how can i update record if id is already exists. my whole code of class ...
0
votes
1answer
107 views

How to remove reference link (__r field) between objects?

I am trying to find a way to unlink reference between two objects. We have an object of Academic_Institution__c and Previous_Academic_Institution__c. If "CEEB_Code__c" exist Academic Institurion is ...
0
votes
1answer
324 views

Scripted dataloader error: Expected 5000 to be processed for batch but got results for 4000

We have few jobs scheduled on data loader, we are receiving the error in the sdl.log file: Expected 5000 to be processed for batch but got results for 4000 Relevant portion log is given below ...
0
votes
1answer
693 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 ...
0
votes
1answer
262 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 ...
0
votes
1answer
405 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 ...
0
votes
1answer
130 views

upserting a feeditem

I'm actually working on a backup and restore procedure of my salesforce data, and my client wants the ability to restore their chatter feed also. I saw in the documentation (https://developer....
0
votes
0answers
676 views

Error code : REQUEST_RUNNING_TOO_LONG

I have an application which call a Salesforce web service to upsert data into it but since yersterday, I get errors and I don't know why because it workded since a lot of times. These are logs : ...
0
votes
0answers
768 views

Upsert throws Missing Argument exception. Any thoughts please?

I tried to upsert and my code is below. But i am getting an exception and nothing is inserted or updated. Any thoughts please. if(lstp.size()>0) { Boolean isUpsertfirstTime = true; try { ...
0
votes
1answer
58 views

Why Workflow fire when object upserted

I create a workflow which will send an email only when a user created. But when i upsert users, it send emails to all user. What upsert do is delete and insert again ??? and can i change workflow to ...
0
votes
2answers
591 views

Using upsert with the partner WSDL SOAP API

I have created a DLL project in C# which is used to add a lead to a Salesforce account via the Partner WSDL/SOAP API. This DLL is called from an external .NET web application, and the idea is to send ...
-1
votes
1answer
236 views

on trigger upsert: if value not found in select , create a new row in different object

I am having a beastly time trying to in a trigger, check the oldmap vs new map, if a certain value exists, check for existence of a row in another object, if that row exists update, otherwise insert a ...
-1
votes
1answer
867 views

How can I add multiple rows to a data extension?

Currently, I have a microsite which is being used as a form to insert / update data in a data extension. In data extension, email is NOT a primary key so I can have multiple records for same email ...
-1
votes
1answer
205 views

Issue in upserting child object with master external id [duplicate]

I have one custom object named Class__c, which has one master relationship with another custom object named Plan__c. I have Class.csv files which contains classes objects. This csv file also has ...
-3
votes
1answer
108 views

Save method not working

I have a vf page. I'm unable to add a save method to it. I have a few fields on visualforce page. I am able to write a save method for it. Here my code so far. public class ...

1 2 3
4