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

4
votes
1answer
36 views

Setting External Id via SObject.put()

When I try to set the lookup field with the external id, everything works fine: Account a = new Account(); a.AccountExternal_ID__c = 'abc'; Car__c c = new Car__c(); c.Account__r = a; insert c; ...
1
vote
1answer
43 views

How do i Upsert record in Parent- child relationship from custom to custom object Using External ID

We have data integration Job for SQL SERVER - SFDC using Talend data integration tool. SFDC environment: Full sandbox Account We have two custom object. In that, Master-Detail relationship from ...
1
vote
1answer
29 views

Conditionally using External ID in upsert function

I want to use external id to reference a parent record on a lookup field. The problem is if this external id can't target that record, I just want to leave that lookup field a null. Contact ct = new ...
1
vote
1answer
30 views

Upsert with External ID: DUPLICATE_VALUE Error

I'm trying up upsert Asset records with an external Id and am getting the DUPLICATE_VALUE error which makes no sense to me: I want it to UPDATE the record if it finds a duplicate, that's what UPSERT ...
3
votes
1answer
32 views

Trigger to match existing Accounts via custom Field

I am trying to match existing accounts based on a custom field but not having any luck with my code. If in an upcoming upsert there is no Salesforce ID, then I want to check for existing accounts ...
1
vote
0answers
25 views

Duplicate prevention and Merge on Account

We have an integration with a legacy system and we use an Unique ExternalID to send personAccount upserts back and forth between salesforce and the legacy system using JItterbit. However, that ...
2
votes
1answer
64 views

Can I show an auto number field (or any other unique ID type value) on a new record before it has been saved?

A simple request. I am customising an opportunities object page layout and want to show a UID type value that staff can quote to people. I have this working currently with an auto number field but ...
1
vote
0answers
31 views

Test class for a REST endpoint which inserts multiple records into a custom object referencing other Objects with external IDs

I am having trouble testing an apex class which inserts multiple records into a custom object having references to other objects. The following is my class. @RestResource(urlMapping='/MultiTicket/*') ...
0
votes
1answer
26 views

How to set CampaignId as external Id?

I have trigger that contains query below: List<CampaignMember> campaignMembers = [SELECT Id, CampaignId, Campaign_Name__c FROM CampaignMember WHERE CampaignId IN: setCampaignIds]; I already ...
1
vote
3answers
25 views

why u go for 7 externalids in salesforce, i need some reason

We can create upto 7 External ID's on single object. But anyone please give me one scenario where we require all 7 Ext. ID's for upsert. As per my understanding 1 Ext. ID is sufficient for upsert then ...
0
votes
1answer
59 views

Populate Account on Opportunity using externalID in before insert Trigger

I am to trying to populate Account lookup on Opportunity using External Id field on Opportunity using before insert trigger. It is not working however if I do it by a simple class it work. ID__c is my ...
1
vote
2answers
76 views

How to map a field from External Object to Standard Object

Working on Odata first time , Needs to know Is it possible to map external object from Odata to standard object? Is it needs to be done using custom field (using formula) in standard object. ...
0
votes
0answers
19 views

change owner using external id not allowed

Actually i am doing a backup and restore procedur for my client, and i want to restore their data with the owner set to the original user and not the one doing the insert. I am doing a mapping on the ...
0
votes
0answers
25 views

Records Using External Id for SF Dataloader

SF: Professional Packages: Workflow/API Hello everybody, We want to treat an External ID from our ERP like an Salesforce ID to Modify an Record according to this external one over the Salesforce ...
3
votes
1answer
109 views

The External ID standard field vs custom external ID

I'm reading the lightning connect docs and I'm getting confused. What exactly is External ID standard field? I thought you can only define external id on custom fields
0
votes
1answer
43 views

Can I use a apex:repeat on a VF page to iterate through related external data? Trying to test in dev org using Odata standard system

Object type not accessible. Please check permissions and make sure the object is not in development mode: An error occurred while connecting to the external system. Please try again, or contact ...
1
vote
0answers
28 views

When accessing Odata through tabs or search an error is returned

I am getting error when trying to access The record with external ID "/o" is currently unavailable in the external data source. Error from Search: (searched on customer 600) The query is giving ...
1
vote
0answers
39 views

External Id attribute of an Account field

When populating a custom field in Account, is a text field marked as External ID so different from a different text custom field in Account NOT marked as External ID, that I would be getting an error ...
0
votes
1answer
54 views

Combined ExternalID

I have fields UserID and RoleID. Combination of these fields are unique. Is it possible make these combination as ExternalID without creating new field? Thanks in advance.
0
votes
0answers
42 views

Jitterbit Dataloader - How to “automap” relationships

I want to define a CSV file that can be used for a migration of data in jitterbit. Where relations are expressed, I want to express them in such a way that they are recognised when a user presses ...
1
vote
2answers
90 views

Insert data to custom object with relationship using external Id

Good day everyone, I have installed an npsp package and then I created a visual force that will save a new affiliation . I've tried to used an external Id to save the data. I've already tried saving ...
1
vote
0answers
51 views

Error while updating custom object lookup using external id using SOAP API request

I am trying to update a Custom object lookup using SOAP API by passing an external Id. While doing that I am getting an error Invalid foreign key relationship name Service_Maintenance_Contract__r ...
0
votes
1answer
89 views

Handling Upserted Records within a Trigger from Data Loader when External Id not Found

This question is very similar to this issue, however I have a slight derivation. Currently I am upserting Cases via the Data Loader, this way I can insert Cases and relate some look-up fields by ...
1
vote
1answer
134 views

Cross reference works for ID but not for External Id

I am facing INSUFFICIENT_ACCESS_ON_CROSS_REFERENCE_ENTITY while creating CaseComment object with external id CaseNumber for Case parent object. I am using the profile with "Partner Community" user ...
1
vote
2answers
148 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
81 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
665 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
32 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
77 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
234 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
66 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
3k 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
1answer
484 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 ...
10
votes
1answer
515 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
576 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 ...
2
votes
1answer
197 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
333 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 ...
1
vote
2answers
859 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
1k 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
375 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
164 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
262 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
227 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 ...
2
votes
1answer
125 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 ...
4
votes
1answer
234 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
488 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
89 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 ...
2
votes
1answer
359 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
74 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
403 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 ...