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
1answer
43 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
44 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
14 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
20 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
81 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
36 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
26 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
35 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
41 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
31 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
78 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
46 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
64 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
93 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
111 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
65 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
489 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
30 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
62 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
201 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
63 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
2k 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
454 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
489 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
509 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
174 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
289 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
769 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
253 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
156 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
220 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
205 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
119 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
216 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
455 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
332 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
70 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
384 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
218 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
897 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
905 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
36 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
615 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?
7
votes
3answers
6k 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
450 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
173 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
3k 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
205 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 ...