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.
19 questions
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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....
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 ...
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 ...
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 ...
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(...
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 ...
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 ...
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.
...
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 ...
-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 ...