Questions tagged [externalid]

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.

Filter by
Sorted by
Tagged with
1
vote
0answers
34 views

Get RecordID based on ExternalID

I always stumble upon this situation - I have csv file with 200 records and each record has an ExternalId. These records may or may not exist in Salesforce. In Salesforce I have an ExternalID field. ...
0
votes
2answers
38 views

Why use autonumber as external id [closed]

I can't figure out why use autonumber as External ID. There is some case when must be used an auto number as ExternalID? Thanks
0
votes
1answer
36 views

Error when trying to Update using nforce to Product2 object

I am trying to update a custom field on the Product2 object, namely S3_Image__c - it is a URL field, linking to an image on AWS S3. Now, I've basically lifted the code from the examples given on the ...
0
votes
0answers
22 views

Is there a way to derive ExternalId from External Object key?

We are using External objects with custom adapter where ExternalId is 36 character unique identifier. When accessing external object Salesforce creates a 18 character long key similar to SObject Id i....
0
votes
1answer
86 views

Calling apex rest API endpoints after auth in an external JS app

I'm a little worried that what I want to do is not supported at all and I'm hoping someone can quickly give me an indication if I'm on the wrong track. My goal: Create a client-side only JS app on an ...
0
votes
1answer
23 views

Is there anything we need to check before mark a text field as External Id?

Do we need to check anything in a running org before making a text field as an External Id to avoid Non-selective query against large object type Exception? (Data loss, any apex errors, etc) I have ...
0
votes
1answer
30 views

Fetch record using External ID with specified fields

I would like to fetch a record over standard REST API via a field marked External ID (like here), but limit my fetched fields to just my required fields (e.g. using the fields parameter here). Is this ...
0
votes
1answer
41 views

Alternative to making Formula Field as an External ID

I have a custom object which draws an External ID field from its Parent. I created a Formula Field to pull that data in to the custom field. However, I want to use that field on the custom object as ...
0
votes
0answers
14 views

How to upsert child records with invalid foreign external ID(parent external ID)?

I am trying to upsert contact related to account using CLI Data Loader. We have a requirement to insert contact successfully even if the account with the external ID doesn't exist. For Example, if ...
0
votes
1answer
24 views

Update using External Id

I understand UPDATE operation doesn't support ExternlID. Is there any other way i can use Dataloader to update Salesforce records using external id ? If i use UPSERT operation, i don't want to ...
0
votes
0answers
21 views

currentid controller test case [duplicate]

Good day, Inherited this code. Can someone please assist me with a test case. I'm really not sure where to start: public class currentIdController{ public String PrintNotes { get; set; } ...
0
votes
1answer
65 views

Trigger : External Id is not Linking Parent and Child

I am trying to build logic to clone Opportunity and all related Product (Custom) when Opportunity is closed won. I am using externalId to link it. It is cloning opportunity but for it is cloning but ...
0
votes
0answers
41 views

Dealing with failed records in an Upsert operation

With the help of responses to my previous posts I was finally successful in Upserting Contacts in Salesforce via Jitterbit using External Id. However two records failed. I am thinking these failed ...
0
votes
0answers
33 views

Dataloader - Upsert Contact and Relate to Account

How can I UPSERT Contact and relate it to the Account ? Data Structure Supplier_ID__c (External Id on Account ) Supplier_AdminID__c (External ID on Contact) Supplier_ID__c (lookup field on ...
0
votes
1answer
55 views

Bulk API upsert with both External Id and SFID in JSON

I'm using the Bulk API to upsert records into Salesforce. The Request contains both an External ID and also a Salesforce Id. Even though in the job detail references using the external Id, will ...
0
votes
0answers
22 views

SOQL vs Reports: Why is server losing connection when I run equivalent SOQL from Query Editor?

I have a Batch process which accepts 300,000 or so records from its query. When I run the query as a standalone in Query Editor or in Workbench, I get errors (discussed in last post Errors for count() ...
0
votes
0answers
22 views

Bad Field Names on Insert Update in Integration (but not on all records in transaction)

Scenario We have an integration that upserts records against Sobject A, C and CO. (I'm using letters to represent for brevity) A - Account C - Contact CO - CustomSobject (junction Sobject between A &...
1
vote
1answer
119 views

Check if Parent record exists using parent's External Id before inserting child

I have a child__c object that has a lookup relationship to Parent__c. Each have an ExternalId__c field in them. I am trying to create this relationship when inserting a child record. List<...
0
votes
1answer
132 views

Salesforce Data Loader Cant Upsert Tasks using External Id to link to Account?

I'm trying to Upsert Tasks to their Accounts using an ExternalID field but the 2nd step (Step 2b) doesn't appear with a Task Upsert. Does Task not support External IDs for Account-association? Also,...
0
votes
1answer
234 views

Not being able to query External Object from Trigger

I need to query an external Object from Contact Trigger. If records are present in the external object, then we have to update the contact. Otherwise we have to create the contact. Now, my issue is ...
-1
votes
2answers
78 views

Dataloader Upserting: the Child overwrites the parent

I'm using Dataloader to Upsert a Child Account to Parent Account using an external ID. When the Upsert is complete, the Child overwrites the parent, it's not not connecting the Child Account to the ...
-1
votes
2answers
68 views

Dataloader Upserting Child Account to Parent Account using External ID: [duplicate]

I'm using Dataloader to Upsert a Child Account to Parent Account using an external ID. When the Upsert is complete, it's creating a new account, it's not not connecting the Child Account to the ...
0
votes
0answers
48 views

AsyncSaveCallback not working in apex

I am trying to insert records to an external object and get the Id back for the inserted record I have the following piece of code Database.SaveResult[] insertResultAccount = Database.insertAsync(...
0
votes
0answers
16 views

Getting error while fetching external id type field

When i am trying to fetch external Id type field through soql.it is giving me error saying this column doesn't not exist on object if you are using custom field try to append __c .when it exists and ...
0
votes
1answer
38 views

Error Message When Using Clone Method in External ID scenario

I'm currently wrapping my head around inserting both parent records and child records at the same time. The second requirement is that all fields must be cloned. Example: Clone an Account and all ...
0
votes
1answer
44 views

Encrypt a text field that is both ExternalID and Unique

I am trying to determine if this is possible - Encrypt a text field that is both Unique and an ExternalID. Via deterministic encryption, I believe it is possible. I am just wanting to see if anyone ...
0
votes
1answer
23 views

ExternalID need to be unique?

I am trying to make a certain field an externalID,and the background job runs, and I never see the checbox get checked. Originally, I was trying to make it both unique an an externalID, however, ...
3
votes
2answers
1k views

How to use sfdx force:data:bulk:upsert on an object without an external ID?

I have a custom object (CustomObject__c) which is a child of another custom object. I want to import some records (CSV files) of CustomObject__c via SFDX (force:data:bulk:upsert). These are the ...
1
vote
0answers
164 views

SOAP API: Populate lookup using an external Id

Helping a client structure their C# SOAP API an upsert into Salesforce and we're running into issues. I'm having a hard time finding documentation on this. (searched all this doc, found nothing ...
1
vote
2answers
636 views

External Object Query in trigger

I have an external object lookup in case. I have a scenario when a record inserted or updated on the case. If the type and subtype field condition matches, I have to check the external object field ...
1
vote
1answer
635 views

Using External ID field from User in Dataloader to set lookup field (User)

I have created below two fields - Object: User, Field API: identifier__c, Type: Text(25) (External ID) (Unique Case Insensitive) Object: Lead, Field API: Lead_Owner__c, Type: Lookup(User) Sample ...
1
vote
1answer
86 views

Cannot update lookup reference by External Id, if current reference is not null

Scenario: Product__c product = [SELECT Id, ProcurementGroup__r.Number__c FROM Product__c LIMIT 1] product.ProcurementGroup__r = new ProcurementGroup__c(ExternalId__c = '123'); update product; I am ...
3
votes
2answers
525 views

Populate Owner in REST API Using external Id

I'm upserting a custom object via the REST api. How can I use the REST api to populate the record owner using an external id? See details below: Endpoint: /services/data/v42.0/sobjects/...
1
vote
2answers
103 views

Case Insensitive - GA Summer 19?

I have been doing some digging on case Insensitive encryption. I am reading this: Get Exact Matching with Case-Insensitive Deterministic Encryption (Generally Available) And it looks like this ...
0
votes
1answer
121 views

How do I continue to upsert with a SOAP call that has lookups that can't find a record via external id?

I have a SOAP request that sets the lookup fields using the lookup object's external IDs. However, for one particular lookup, I can't guarantee that it will find a matching Salesforce record. If that'...
0
votes
1answer
166 views

Using autonumber field type as externalId to make an upsert & store values in a Map from soql by external id

I know that those questions asked a few times here - but I saw that it little old (Greater than 3 years) and\or it doesn't have the "best answer" so I hope something changed about it. 1) Is there a ...
0
votes
1answer
122 views

How to execute class or method after update external id from post callout

I have a custom object in Salesforce with a set of fields. Some of the fields I sent over by an invocable method which calls a future method to send the first set of fields to entity in an external ...
0
votes
0answers
34 views

MemberNumber field in MemberPlan object not searchable

We have installed Health Cloud and there is an object named Member Plan. This object is searchable in setup (like all the standard objects). We created a custom external ID text field in this object, ...
1
vote
1answer
526 views

Upsert by External Id - Different recordTypes

I have an External Id on Account object. Is there a way to make an upsert when 2 records or more have the same external Id BUT they have different record type? When I make the upsert I get the ...
0
votes
1answer
683 views

External Id upsert

I know that with External Id, I can upsert a record and that will Insert or Update the record base on the External Id (update if exists or insert if not) instead of the regular Id. Is there is a way ...
0
votes
3answers
31 views

Adding a Custom Field to all sObjects in the same edit?

I want to add a custom field to all my salesforce objects, at the same time, a high level idea, is that they are control ID for an external source, but is there a way to add the fields to all objects ...
0
votes
1answer
33 views

Is it possible to get a value with a formulafield fro product to Order Product

I have a external id value on product which I want to put on the Order Product object. Is this possible with a formula field?
2
votes
2answers
1k views

URL link to SF record from external system - LIGHTNING

I have a requirement to provide a link to an external system, which will link to an Account in Salesforce. The external system doesn't store the AccountId, but uses an externalId (UUID). The UUID__c ...
0
votes
1answer
111 views

Why I am not getting empty field of type external Id, while fetching if from soql query?

Fetch empty text value of type external id using SOQL query in apex. I am using this query : Select id,name,CommentBody__c,CommentId__c,ParentId__c from Case_Comment__c where ParentId__c =:caseObj....
0
votes
1answer
209 views

External Id - Make unsearchable

I want to make the external Id field to be unsearchable from the global serach or sidebar search. Is it possible? If so how?
0
votes
1answer
118 views

Can we use Named Credentials with this Weird API?

In order to do something, we need to make call outs to an external server where the URL takes the format: http://www.example.com/path/{external_id}/doSomething?api-key={api-key} The external-id ...
0
votes
1answer
37 views

External ids in data infrastructure?

I just learned about setting related records with external ids, and I love it. It makes test code much easier to read and write, and it means I have to query less in general. In my ideal world, ...
1
vote
0answers
385 views

Record with duplicate external id was inserted through bulk API upsert

I have Account with user id as external id. I have a record of Account with user id 123 created 2 months ago. I have an upsert job created through bulk API yesterday with user id as ...
7
votes
2answers
10k views

updating a records using external Id in Apex

I copied the product data to another object named foo. I used only the name and externalId of product to copy it to Foo object. Foo's external id matches with product's external Id. Some of my ...
0
votes
1answer
35 views

How to accomplish conditional saving when using Unique External IDs?

I have an object with a Unique External ID field. It works fine but have a good amount of already existing records with the same value in the field. And I have a Flow which needs to populate a field ...