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
2answers
44 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
170 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
77 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
1answer
43 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
58 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
19 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
95 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
345 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
19 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
57 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
78 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
666 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
82 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
56 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
126 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
150 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
304 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
170 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
203 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
335 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
599 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
113 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
2k 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
1k 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. ...