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

1
vote
2answers
44 views

Referencing a Custom Field in a Master-Detail Relationship

I have a new custom object (let's call it fancyobject) that I want to have use Accounts as parents (i.e. there will be many fancyobjects for each account). The purpose of this is to upload data from ...
0
votes
1answer
17 views

OpportunityContactRole Upsert ExternalId

I would like to upsert OpportunityContactRole when I look at the documentation it states that upsert is supported: ...
2
votes
1answer
110 views

Null or Empty value are allowed in Unique and External ID text field

I have created a text field in a custom object, and checked the option for External ID and Unique only but not the Required option. i want know if this text field will allow a NULL or Empty value ? ...
2
votes
1answer
19 views

Auto-detection of duplicates in import. To avoid multiple imports

Say I have three Unique(External ID) Fields (Email, Phone, Mobile) But in my file, I do not have values for all three fields for all the rows. But I have atleast value for any one of the field. In ...
1
vote
1answer
27 views

Get external id limit for an org

For my org I need to get the number of external Ids that I am allowed to create Some time back the limit was 3, now it is 7. I have hardcoded the limit to 7 now to check if Im hitting number of ...
0
votes
1answer
85 views

Update records based on External ID

When a new Applicant record is created with the same External ID as another Applicant, I'd like to update the original Applicant record with field values from the new record. So far, I have the ...
0
votes
0answers
45 views

Missing required lookup field when transferring data from org to org using API and External Id

I am migrating data using PHP Toolkit from one org to another using the source org Id as the External Id in the destination org. The problem is that any data with a lookup field does not get upserted ...
5
votes
2answers
510 views

What fields can be set as external ID?

I am learning for my 401 dev exam and reading the book For.com Developer Certification Handbook DEV401. This book is written a little weird and sometimes is even contradictory to itself. therefore I ...
0
votes
0answers
132 views

UPSERT opportunitylineitem via apex dataloader commandline causing Error code is:DUPLICATE_VALUE

I have created a external id field and made it to unique and is having combined text by concatenating OpportunityId and PricebookId; I have .csv file with PriceBookID, Opportunity Id and other ...
0
votes
1answer
270 views

Change account owner with external id on user - partner wsdl (C#)

Using the partner WSDL Is it possible to update the owner of an Account by passing an external id through the Account.owner field? It is my understanding that this field is actually an Id field and ...
8
votes
0answers
265 views

SOQL Query by External ID is missing records

I'm having a problem consistently querying an object by an external id. When I do a SOQL query that has a queryplan that uses an index on the externalID, the record can not always be found. It is as ...
2
votes
1answer
249 views

Is it possible to populate a field of type Auto Number External ID?

I'm trying to populate a Lookup using External ID which is Auto Number field. It is giving the error: Compile Error: Field is not writeable: Opportunity.Opportunity_Number__c Opportunity_Number__c ...
1
vote
1answer
95 views

Can we use AccountNumber field in Account object as an External ID?

Can we use AccountNumber field in Account object as an External ID? Would upsert work with AccountNumber field? Any suggestions please.
1
vote
1answer
159 views

Why does upsert check lookup to determine duplicates rather than ID?

In a salesforce project, I have an object called Project__c which I want to upsert. I have recently added a lookup to the Project__c object and now when I do an upsert project, the following error ...
0
votes
0answers
93 views

Error using ExternalID to reference Opportunity when loading Quote via DataLoader commandline

I am getting an error that states "Required fields are missing: [OpportunityId]" when I try to upsert some Quote records via the DataLoader command line (part of a nightly data load process). The ...
1
vote
2answers
456 views

Populating lookup fields using an external ID with Object type as String

My question is pretty much the same as here. But the difference is I'll have to do it generically. As in the object type is sent as text and I'll have to typecast in the code. Eg., //create an ...
0
votes
2answers
447 views

How to insert (upsert) an object that has no external id?

According to this documentation, you need to know the external ID field of an object to inset new records. For some of my custom objects, I'm not seeing any fields in the object description that have ...
1
vote
0answers
132 views

Exact Target - Individual Email Result object - linking Lookup field to IER records in Salesforce

Apparently Exact Target "uses" Stack Exchange for support issues. More specifically, they have no developer support, and their API is "as-is", and either way I believe I have this isolated to a ...
2
votes
0answers
121 views

Create Master and detail records in single insert without external ID

I can't seem to find a direct answer for this... I am hoping to create a master record and one or more detail records in a single API call. Most resources have suggested the use of an external ID, but ...
4
votes
1answer
123 views

Inserting a child record using a trigger based on an external ID

I have a trigger that inserts a new child record (Training Session) below Training Module using a third object (Scheduler). Training Module contains an external ID called Training_Module_ID, but when ...
2
votes
1answer
135 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
95 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
77 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
171 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
328 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
88 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
219 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
56 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
318 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
173 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
575 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
670 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
30 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
462 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?
5
votes
3answers
4k 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 ...
5
votes
1answer
322 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
144 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 ...
3
votes
2answers
2k 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
178 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
92 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
2answers
297 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
530 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
664 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 ...
4
votes
1answer
3k 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
371 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
458 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
882 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.
1
vote
1answer
1k 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
191 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 ...