Questions tagged [externalid]
An external ID is a custom field that has the “External ID” attribute, meaning that it contains unique record identifiers from a system outside of Salesforce.
200 questions
0
votes
0
answers
61
views
SOQL vs Reports: Why is server losing connection when I run equivalent SOQL from Query Editor?
I have a Batch process which accepts 300,000 or so records from its query. When I run the query as a standalone in Query Editor or in Workbench, I get errors (discussed in last post Errors for count() ...
- 11
0
votes
0
answers
609
views
Bad Field Names on Insert Update in Integration (but not on all records in transaction)
Scenario
We have an integration that upserts records against Sobject A, C and CO. (I'm using letters to represent for brevity)
A - Account
C - Contact
CO - CustomSobject (junction Sobject between A &...
- 159
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
1
vote
1
answer
2k
views
Salesforce Data Loader Cant Upsert Tasks using External Id to link to Account?
I'm trying to Upsert Tasks to their Accounts using an ExternalID field but the 2nd step (Step 2b) doesn't appear with a Task Upsert.
Does Task not support External IDs for Account-association?
Also,...
- 55
0
votes
1
answer
2k
views
Not being able to query External Object from Trigger
I need to query an external Object from Contact Trigger. If records are present in the external object, then we have to update the contact. Otherwise we have to create the contact.
Now, my issue is ...
- 1,435
-1
votes
2
answers
154
views
Dataloader Upserting: the Child overwrites the parent
I'm using Dataloader to Upsert a Child Account to Parent Account using an external ID.
When the Upsert is complete, the Child overwrites the parent, it's not not connecting the Child Account to the ...
- 55
-1
votes
2
answers
655
views
Dataloader Upserting Child Account to Parent Account using External ID: [duplicate]
I'm using Dataloader to Upsert a Child Account to Parent Account using an external ID.
When the Upsert is complete, it's creating a new account, it's not not connecting the Child Account to the ...
- 55
0
votes
0
answers
409
views
AsyncSaveCallback not working in apex
I am trying to insert records to an external object and get the Id back for the inserted record
I have the following piece of code
Database.SaveResult[] insertResultAccount = Database.insertAsync(...
- 1,435
0
votes
0
answers
148
views
Getting error while fetching external id type field
When i am trying to fetch external Id type field through soql.it is giving me error saying this column doesn't not exist on object if you are using custom field try to append __c .when it exists and ...
1
vote
1
answer
396
views
Error Message When Using Clone Method in External ID scenario
I'm currently wrapping my head around inserting both parent records and child records at the same time. The second requirement is that all fields must be cloned.
Example: Clone an Account and all ...
- 15
0
votes
1
answer
628
views
Encrypt a text field that is both ExternalID and Unique
I am trying to determine if this is possible - Encrypt a text field that is both Unique and an ExternalID. Via deterministic encryption, I believe it is possible. I am just wanting to see if anyone ...
- 391
0
votes
1
answer
363
views
ExternalID need to be unique?
I am trying to make a certain field an externalID,and the background job runs, and I never see the checbox get checked. Originally, I was trying to make it both unique an an externalID, however, ...
- 391
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
1
vote
0
answers
358
views
SOAP API: Populate lookup using an external Id
Helping a client structure their C# SOAP API an upsert into Salesforce and we're running into issues.
I'm having a hard time finding documentation on this.
(searched all this doc, found nothing ...
- 159
1
vote
2
answers
2k
views
External Object Query in trigger
I have an external object lookup in case. I have a scenario when a record inserted or updated on the case. If the type and subtype field condition matches, I have to check the external object field ...
- 11
1
vote
1
answer
3k
views
Using External ID field from User in Dataloader to set lookup field (User)
I have created below two fields -
Object: User, Field API: identifier__c, Type: Text(25) (External ID) (Unique Case Insensitive)
Object: Lead, Field API: Lead_Owner__c, Type: Lookup(User)
Sample ...
- 1,265
2
votes
1
answer
547
views
Cannot update lookup reference by External Id, if current reference is not null
Scenario:
Product__c product = [SELECT Id, ProcurementGroup__r.Number__c FROM Product__c LIMIT 1]
product.ProcurementGroup__r = new ProcurementGroup__c(ExternalId__c = '123');
update product;
I am ...
- 21
4
votes
2
answers
3k
views
Populate Owner in REST API Using external Id
I'm upserting a custom object via the REST api.
How can I use the REST api to populate the record owner using an external id?
See details below:
Endpoint:
/services/data/v42.0/sobjects/...
- 487
1
vote
2
answers
118
views
Case Insensitive - GA Summer 19?
I have been doing some digging on case Insensitive encryption. I am reading this:
Get Exact Matching with Case-Insensitive Deterministic Encryption (Generally Available)
And it looks like this ...
- 391
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
760
views
Using autonumber field type as externalId to make an upsert & store values in a Map from soql by external id
I know that those questions asked a few times here - but I saw that it little old (Greater than 3 years) and\or it doesn't have the "best answer" so I hope something changed about it.
1) Is there a ...
- 1,209
0
votes
1
answer
224
views
How to execute class or method after update external id from post callout
I have a custom object in Salesforce with a set of fields. Some of the fields I sent over by an invocable method which calls a future method to send the first set of fields to entity in an external ...
- 2,320
0
votes
0
answers
91
views
MemberNumber field in MemberPlan object not searchable
We have installed Health Cloud and there is an object named Member Plan. This object is searchable in setup (like all the standard objects). We created a custom external ID text field in this object, ...
- 101
1
vote
1
answer
2k
views
Upsert by External Id - Different recordTypes
I have an External Id on Account object.
Is there a way to make an upsert when 2 records or more have the same external Id BUT they have different record type?
When I make the upsert I get the ...
- 1,209
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
0
votes
3
answers
188
views
Adding a Custom Field to all sObjects in the same edit?
I want to add a custom field to all my salesforce objects, at the same time,
a high level idea, is that they are control ID for an external source, but is there a way to add the fields to all objects ...
- 333
0
votes
1
answer
47
views
Is it possible to get a value with a formulafield fro product to Order Product
I have a external id value on product which I want to put on the Order Product object. Is this possible with a formula field?
- 2,320
4
votes
2
answers
4k
views
URL link to SF record from external system - LIGHTNING
I have a requirement to provide a link to an external system, which will link to an Account in Salesforce. The external system doesn't store the AccountId, but uses an externalId (UUID). The UUID__c ...
- 459
0
votes
1
answer
396
views
Why I am not getting empty field of type external Id, while fetching if from soql query?
Fetch empty text value of type external id using SOQL query in apex. I am using this query :
Select id,name,CommentBody__c,CommentId__c,ParentId__c
from Case_Comment__c
where ParentId__c =:caseObj....
0
votes
1
answer
307
views
External Id - Make unsearchable
I want to make the external Id field to be unsearchable from the global serach or sidebar search. Is it possible? If so how?
0
votes
1
answer
283
views
Can we use Named Credentials with this Weird API?
In order to do something, we need to make call outs to an external server where the URL takes the format:
http://www.example.com/path/{external_id}/doSomething?api-key={api-key}
The external-id ...
- 4,674
0
votes
1
answer
108
views
External ids in data infrastructure?
I just learned about setting related records with external ids, and I love it. It makes test code much easier to read and write, and it means I have to query less in general.
In my ideal world, ...
- 4,232
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
0
votes
1
answer
133
views
How to accomplish conditional saving when using Unique External IDs?
I have an object with a Unique External ID field. It works fine but have a good amount of already existing records with the same value in the field. And I have a Flow which needs to populate a field ...
- 3,924
2
votes
2
answers
4k
views
Is it possible to not use an ExternalId field for Database.Upsert?
I'm trying to upser a list of Asset records via Database.upsert(List, externalIdField, boolean) and on the externalIdField, I want to pass the standard field 'SerialNumber'.
List<Database....
2
votes
1
answer
695
views
Custom Preference Page - External Key (Generate it / Retrieve preferences)
I need to make a Custom Preference Page (for the Cloud Marketing). I know that on the Standard Preference Page you use the "QS" value in the URL, and that it is used to fetch the Preferences from the ...
- 23
5
votes
1
answer
2k
views
How to refer to an existing record in REST API composite JSON?
When using REST API composite JSON, how to refer with external id
an existing record
to existing Master-Detail parent from a newly created child
We have the following objects:
Organization__c:
Has ...
- 151
2
votes
1
answer
615
views
Getting error while relating child to parent using external id
I am referring to this link for relating parent data with external id.
Link: Click here
Sample code which I am trying:
ysr_NS_test__Object_Child__c childObjectReference = new ...
- 3,175
2
votes
1
answer
909
views
How to make an External Id field unique in a managed package?
We need to make couple of existing external Id fields unique in a managed package, But it's not possible to make them unique once released.
Unfortunately these have been not made unique by mistake (...
- 2,549
3
votes
1
answer
2k
views
Upserting a record using ExternalID is giving an error
I have an object of type Contact with an External ID field called my_external_id_field
when i call:
https://instance/services/data/v41.0/sobjects/Contact/my_external_id_field/012443
with a patch ...
- 171
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
1
answer
487
views
Data migration when external Id is not unique on the detail object
We are migrating records from one org to another org and I ran into this scenario.
Background:
We have two objects with master detail relation between them and API names are Master__c and Detail__c
...
- 8,957
0
votes
1
answer
805
views
Batch Insert child records with External Id
I'm creating a process to take records from a parent object and child object records and recreate them into different parent and child objects. This is for budgeting where we take a snapshot of ...
- 3,731
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
3
votes
1
answer
7k
views
Upsert Multiple Records with external ID with REST API
I am trying to update multiple contact records via the REST API that have an external Id CustomField__c.
Is there any way to do this?
I've tried using Workbench, hitting
(POST) /services/data/v39....
- 45
2
votes
1
answer
2k
views
External Id is not showing up in data loader field mapping
I am trying to insert Junction object data based on External Id of the Contact. I have created an external id field as follows on Contact object:
Name: External Id
API: External_Id__c
DataType: Text(...
- 36.2k
1
vote
1
answer
287
views
Marking field as External Id in managed package patch org
Can we mark a field as External Id in a patch org?
I need this so that the field will be indexed.
- 761
2
votes
1
answer
284
views
Global Search - Not matches found message
I'm trying to search a record using a global search putting part of the content, but the results show a message: "No matches found".
If I put all the content, the global search show me the record. ...
1
vote
0
answers
1k
views
Challenge when inserting records that has lookup field(that uses external Id of parent record)
In my scenario , I am loading records of object xyz__c in my system. This xyz__c has a lookup field that refers to abc__c object.
I am loading records using an external system. It maps the fields on ...
- 4,839