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
32 views

Create Junction object with External IDs

I have the following Objects and fields. Object A: External Id (a_ext_id) and other fields Object B: Extrernal Id (b_ext_id) and other fields Custom Junction Object C: External id (c_ext_id) and ...
0
votes
0answers
27 views

Need to connect 2 custom objects together using an external ID and a Trigger

I have 2 objects which are parent and child. I am using Layer 2 Cloud Connect (Need to do it this way because it does replication and automatically updates any field changes between the 2 records) to ...
1
vote
1answer
43 views

Inserting a child record with Parents external id not working

In one of our requirement we have to clone a parent and then also clone the child and attach the cloned child with the new cloned parent. The child and parent have a M-D relationship. There is two way ...
1
vote
1answer
27 views

System.SecurityException: ViewAllData or ViewAllRecords required to access external id fields which do not have a unique index

I am trying to cover the following in my test class. @RemoteAction global static Tfunc InsertOrg(String Name,String AddressLine1,String AddressLine2,String AddressLine3,String AddressLine4,String ...
2
votes
2answers
81 views

Establishing Parent-Child Relationship via Process Builder

Here is my use case: A data load of applicant information must be inserted (no updates) into Salesforce. From this applicant information, a Contact record must be created with a specific record type ...
3
votes
1answer
87 views

Update Error: Cannot specify both an external ID reference Contact and a salesforce id

I have some code that was being called from a trigger on a case that, in certain situations, would create add an account and contact to the case. I originally tried to do it synchronously and while it ...
0
votes
0answers
20 views

Lookup reference using external Id in mulesoft

Anyone have experience in loading child record and associate parent using parent_external_id__c field. for custom objects ex: Load child__c record and associate Parent__c object using ...
4
votes
1answer
48 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; But,...
1
vote
1answer
81 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
35 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
49 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
37 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
29 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
73 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
36 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
28 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
26 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
68 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
96 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
21 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
133 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
47 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
40 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
64 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
49 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 "...
2
votes
2answers
126 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
53 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
105 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
150 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
189 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
95 views

OpportunityContactRole Upsert ExternalId

I would like to upsert OpportunityContactRole when I look at the documentation it states that upsert is supported: https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/...
2
votes
1answer
791 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
33 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
88 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
257 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
506 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
541 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
619 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
218 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
356 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
910 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 in-...
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
478 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 non-...
2
votes
0answers
176 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
304 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
246 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 ...