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
14
votes
1answer
1k 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
1answer
5k 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 ...
19
votes
4answers
14k 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 ...
-1
votes
2answers
84 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 ...
6
votes
1answer
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 ...
5
votes
1answer
1k 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 ...
4
votes
1answer
1k 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 ...
3
votes
1answer
2k 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 ...
3
votes
2answers
1k views

Make an existing text field an indexed External Id. Will/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 ...
2
votes
2answers
1k 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
1answer
4k 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....
2
votes
2answers
96 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
2answers
808 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 ...
0
votes
1answer
722 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 ...