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.

learn more… | top users | synonyms

2
votes
1answer
24 views

Cannot search for External ID

I have created a custom object in my Salesforce Org, I have created a new field in this org with 'External ID' selected. I presumed that I am able to search via that field in the global search bar in ...
1
vote
1answer
21 views

Order of Bulk API result rows

I am performing multiple batch upserts using the Bulk API using an external ID field from my system. In order to determine which record ids from my system failed, I'd need the results rows to ...
0
votes
0answers
9 views

How to work with multiple external ID's in process-conf.xml

I have marked 3 fields as external ID in the contact object.(EmailID__c, Number__c, MembershipID__c) I am using data loader command line. My process-conf.xml is like this. <entry ...
4
votes
1answer
46 views

How to make External Ids ReadOnly in Salesforce?

We have a requirement where we use External IDs in Salesforce Custom Object. Ideally, we wanted to make this External ID field to be : 1. Read Only. 2. Required. But i don't see why Salesforce does ...
2
votes
1answer
52 views

Trouble with Salesforce Lead Trigger before insert

I've had help creating some Apex code which is supposed to do the following Via Web-to-Lead I'm populating a field in our Lead Object called Promo_Code__c. Promo_Code__c has also been setup in our ...
1
vote
1answer
84 views

Is there any reason to log old IDs?

Recently did an org-to-org migration where the first org's ord-id and other IDs will never be used again; went from one trial, to another trial; second trial was converted to a non-trial account. Is ...
1
vote
1answer
75 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 ...
2
votes
2answers
47 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 ...
3
votes
3answers
204 views

Do unique external ID's have to be unique between objects?

If I have 2 custom objects, object A and object B, and both have an external ID field, is it acceptable to allow duplicates between objects? What I mean is if "ext_0000001" exists for a record in ...
5
votes
1answer
97 views

Polymorphic ID does not accept external ID, or does it?

Requirement: Via APEX dataloader upload attachments (standard object) and link it via ParentId to a custom object's record. This works easily when the SFDC ID is provided for the polymorphic ParentId ...
3
votes
3answers
81 views

Java BulkAPI exception: Field name provided does not match an External ID

This posting is in reference to this webinar and it's associated Java code regarding use of the Bulk API. Salesforce API Series: Fast Parallel Data Loading with the Bulk API ...
0
votes
1answer
157 views

Merge two unique field to create an external id. Possible?

Can we merge two unique fields to create a third field and then make that third field an external id? Any ideas and suggestion will be appreciated. Thanks
2
votes
1answer
22 views

Is there any way to tie an error in a API SOAP create response back to the original record when attempting to create more than 1 record at a time?

I'm creating new records in Salesforce by using the SOAP API create method. I'm attempting to create several records in one create call. Some of them are successfully created, but others fail due to ...
3
votes
1answer
203 views

Mass Delete Custom Object Records Using External Id?

Is there any tool that allows you to mass-delete custom object records using only the External Id on that object record rather than the Salesforce record Id?
2
votes
2answers
1k 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 ...
0
votes
0answers
22 views

external id on profile

How do I create an External Id on objects like Profile (for which isCreatable is false). I have to create External Id on Profile for upsert operation, but I am not able to create it. Is there any ...
4
votes
1answer
100 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 ...
2
votes
1answer
93 views

Salesforce Integration with External Scheduler

I'm currently working with a customer that is interested in launching Salesforce Batch jobs from an external scheduler. I was thinking about the following - Create a global interface global ...
2
votes
1answer
968 views

Updating a record based on external id which are not unique

I have an external system that needs to update a record in my org. This system only knows the external id, but the problem is that this external id is not unique, e.g. multiple records might have the ...
1
vote
1answer
104 views

If a custom field is unique will the Import Wizard for Leads block duplicates on that field?

I would like to use an external id which I've also marked as unique to prevent importing duplicate leads. Does the Import Wizard respect the uniqueness constraint on custom fields? And will the ...
3
votes
1answer
60 views

Will GROUP BY run faster if grouped field has a Standard / Custom Index?

Would it help to make a field an External Id if we use it as a GROUP BY field in many LDV SOQL queries? Is there a order in which SOQL queries are processed? So will it group after it filtered? How ...
2
votes
1answer
144 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 ...
0
votes
1answer
196 views

Issues while using IN operator in SOQL

I have a list of string,reqNumber, containing External Opportunity Id. I want to pull all the Opportunities belonging to the external Id's in reqNumber. Following is my SOQL query ...
6
votes
2answers
360 views

Error while upserting Opportunity Team members

I am trying to create Opportunity Team Member using External id's for Opportunity and User. First of all I create an instance of Opportunity and User using their respective External Id's User ...
3
votes
1answer
1k 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 ...
6
votes
1answer
203 views

Insert new objects via REST using an external ID

Here is my situation: I have created a custom object called "CSB" with fields: source_xml__c => Text IPN__c => text Salesman => Lookupfield to "User" In the "User" object there is a custom ...
3
votes
2answers
268 views

Linking two object in a trigger when I can an External Id

In my before insert trigger I want to link the incoming record with an existing record. I have a lookup from Lead to Account and the incoming Lead includes the value of the External ID of the Account. ...
1
vote
1answer
464 views

Standard Objects and External Id

Has any standard object an external id by default ? I need to know it for testing proposes. I was searching this unsuccessfully.
0
votes
1answer
726 views

Can free Jitterbit dataloader do an auto-relation like Dataloader.io?

Until now I was a happy Datloader.io user as it allowed me on a Mac to insert from CSV and have this wonderful auto mapping feature where a Lookup or Master Detail relation can be pointed to an ...
0
votes
1answer
124 views

External IDs unavailable in Apex Data Loader

I have a number of external Ids in my SFDC environment, but I can't see them in the Data Loader or in the Jitterbit Data Loader. Any ideas? Data Loader: Field settings:
2
votes
2answers
3k views

External ID & Unique field limit exceeded

We have a customer whom is experiencing this exception: External ID & Unique field limit exceeded. when they attempt to install our package. I assume this is related to a conflict with another ...
3
votes
3answers
2k views

How do you use an external ID in the import wizard to import child objects of a master/detail relationship?

OK, I need to import a few thousand records and import wizard seemed like a good choice. First I did some accounts - that went smoothly. Next I went to import some custom objects that have a ...
8
votes
4answers
2k views

Can I import child records using the parent's External ID?

I have a bunch of data I want to import into a custom object. I need these records to have a look up to the Account. The Account has an External ID which is also present in the data I'm importing. ...