Skip to main content

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
18 votes
1 answer
3k views

Set Relationship Via Name Pointing Field?

One of the most startling things I ever learned from @BobBuzzard is that you can update a lookup by using the name pointing field. At least, I thought that's what I learned, until a recent debate cast ...
Adrian Larson's user avatar
  • 151k
8 votes
1 answer
6k views

Parent Id Apex Data Loader

I'm using the data loader. I'm not sure about the use of the Parent id in the picture below. When have i use this? I'm upserting with the data loader contacts that are related of course to certain ...
Enry's user avatar
  • 3,736
20 votes
3 answers
20k views

What is the use of External ID field, not unique?

What can be the use of an external ID field, not marked as unique? Helps in indexing? I checked the documentation , and found that to upsert records with an external ID, there is no requirement that ...
Dharshni's user avatar
  • 568
4 votes
1 answer
1k views

Rest API - Set polymorphic Lookup with external Id

I am wondering If it is possible to set a polymorphic lookup value with external Id with Rest API. I didn't find any documentation on this and it does work for me. Here I am trying to set the lookup ...
Raphael D's user avatar
  • 636
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 ...
SfdcBat's user avatar
  • 4,839
6 votes
1 answer
1k views

not able to upload attachments to Accounts with External ID

I have a Salesforce implementation for a big company; every month the marketing department produces a report ( pdf ) for each client account; they ask me about batch process to automatically import ...
user4907's user avatar
6 votes
1 answer
2k views

How to use External Ids in a Before Insert trigger?

Our company deploys surveys from an external system. We receive them in Salesforce, but we don't have any relationships. I thought I could create the relationship with an External Ids in a Before ...
Matthew Mitchener's user avatar
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 ...
Touko's user avatar
  • 151
4 votes
3 answers
2k views

Make packaged Text Field an Indexed External Id. Can Support do it?

In our ISV package we had to "convert" a pre-indexed Lookup field to a Text(255) field as we wanted to keep Ids even when the referenced record was deleted. After we did that the performance of SOQL ...
Robert Sösemann's user avatar
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....
Will's user avatar
  • 45
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 ...
user9064103's user avatar
3 votes
1 answer
3k 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 ...
Alon Segal's user avatar
2 votes
2 answers
3k views

Add a custom field to multiple objects

I am working on an assignment to populate the data in a developer sandbox with production data. This activity involves me in populating data for over 50 objects. I am planning to create an external Id ...
Balaji Pooruli's user avatar
2 votes
2 answers
143 views

Prevent DMLException when lookup's external id is unknown

Imagine a Custom SObject X with a lookup field for Custom SObject Y. Y has an external ID field EID. As described in this answer, I can create a record X like this: Y y = new Y(EID = 1); X x = new X(...
Jolanda Verhoef's user avatar
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 ...
AJ Sagar's user avatar
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 ...
Daniel's user avatar
  • 15
0 votes
2 answers
140 views

Fetch all records matching a repeating ExternalID [closed]

I have a non-unique custom field which is an ExternalID. Is it possible to fetch all records matching a given value using the REST API? The documentation example shows the API returns one record. ...
ishan3243's user avatar
  • 111
0 votes
1 answer
1k views

Displaying Duplicate Record Ids for External Id [duplicate]

I have created the field set as External Id and now I am changing the field to set as unique record identifier, I am not able to change, because Records exist already with duplicate values for that ...
SFDC's user avatar
  • 668
-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 ...
Steve's user avatar
  • 55