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.

Filter by
Sorted by
Tagged with
1
vote
0answers
11 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 ...
1
vote
1answer
27 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 ...
1
vote
1answer
25 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
vote
1answer
17 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 ...
3
votes
1answer
55 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/...
1
vote
2answers
88 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 ...
0
votes
1answer
25 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'...
0
votes
1answer
24 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 ...
0
votes
1answer
43 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 ...
0
votes
0answers
21 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, ...
1
vote
1answer
151 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 ...
0
votes
1answer
89 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 ...
0
votes
3answers
24 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 ...
0
votes
1answer
16 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?
1
vote
2answers
464 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 ...
0
votes
1answer
45 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
1answer
87 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
1answer
55 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 ...
0
votes
1answer
27 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, ...
0
votes
0answers
215 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 ...
6
votes
2answers
3k 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 ...
0
votes
1answer
29 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 ...
1
vote
2answers
664 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
1answer
202 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 ...
4
votes
1answer
433 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 ...
2
votes
1answer
100 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 ...
2
votes
1answer
109 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 (...
1
vote
1answer
316 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 ...
1
vote
0answers
302 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 ...
0
votes
1answer
115 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 ...
0
votes
1answer
341 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 ...
0
votes
2answers
501 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/...
2
votes
1answer
2k 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....
1
vote
1answer
515 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(...
0
votes
1answer
77 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.
1
vote
1answer
133 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
0answers
323 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 ...
0
votes
2answers
977 views

Inserting Parent and child records in apex without using external id

I am trying to insert a parent and related child records in same apex execution phase. // code to cretae parent record list List<Parent_Record__c> parentList = new List<Parent_Record__c>(...
1
vote
2answers
406 views

External ID matching no longer an option in Data Import Wizard for custom object to add new records

Every week we do a import into SF. The sales team reported they cannot add records to the custom object by matching external ID anymore. I checked and they are correct. previously we were doing it ...
1
vote
1answer
383 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 ...
1
vote
2answers
796 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 ...
0
votes
1answer
336 views

Setting value of AccountId / ContactId on AccountContactRelation by trigger using external ID

I have created a custom field on my AccountContactRelation called SurrogateId__c and I set configured it to be an External Identifier. When I create an AccountContactRelation from an external ...
1
vote
1answer
509 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 ...
0
votes
2answers
197 views

Make Custom '__c' Field Searchable in Global Search Bar

I have a custom field at the Opportunity Product level that can't be searched at the moment on the global search, even if I click on 'search all' I have seen this link that selects 'external ID' on ...
5
votes
3answers
158 views

Should I generate external IDs when not needed to avoid potential query issues later?

I have a Currency Rate table with a few fields like so: Currency_Definition__c : M-D(Currency Definition) As_of__c : Date FX_USD__c : Decimal Key__c : String(11) ExternalId This table gets ...
2
votes
1answer
422 views

How to set auto-number as external Id

I am not being able to set a Auto-number field as an external Id. I read in a lot of documents that it can be done
2
votes
0answers
78 views

How Long To Re-Index External Id Field? [closed]

I have a Custom Object in salesforce which has 50k+ records with one of the field as external id. I accidentally unchecked External Id and saved it. Now when I recheck External Id and save, it says ...
3
votes
1answer
2k views

INVALID_FIELD, Foreign key external ID not found - Inserting Related Records via External Id

I am trying to insert related records via an External Id. i am using an approach described here where we create an empty parent object with the same external Id like the "real" parent. It is a self-...
2
votes
1answer
1k 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 ...
2
votes
1answer
763 views

Insert Parent and Child Objects of One Type within One DML statement

I want to insert Parent and Child Accounts in one DML statement. I know it can be done for related Contact/Account objects using External Id field, but it doesn't work in my case. Running the ...