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

0
votes
0answers
44 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
59 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
68 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
31 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
44 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
40 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
54 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
40 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
26 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
72 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
131 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
85 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
118 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
51 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
234 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
109 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
173 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
304 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
23 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
278 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?
3
votes
2answers
2k 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
26 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 ...
5
votes
1answer
149 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
107 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
1answer
1k 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
121 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
63 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
176 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
255 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
463 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
2k 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
244 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
315 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
593 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
844 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
141 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. ...