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
0
votes
1answer
732 views

External Id issue::: INVALID_FIELD, Foreign key external ID: extid::3073631 not found for field

I'm getting above error message when I try to create child records based on the External Id of the Parent Record. Here is the scenario. Please note that both reference1 and reference2 are related to ...
0
votes
2answers
42 views

Update both Pricebook2 and PricebookEntry objects using just one for loop

Having the next code: for (WrapperTest pb : pbs_lst) { Pricebook2 newPB2 = new Pricebook2(); PricebookEntry newPBE = ...
0
votes
1answer
564 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
23 views

Create AccountContactRelation with External IDs

I'm trying to insert multiple Contacts related to Accounts via a POST call from an external database. I'm relating the Contacts to the Accounts via an External ID, but if I want to relate a Contact ...
0
votes
1answer
16 views

Understand token expiry for Connected APP using JWT authentication

The session expiry for an accessToken can be configured at org level, profile level, connected app level. When authenticating via private key certificate using the JWT OAuth Flow, which session expiry ...
1
vote
0answers
44 views

DUPLICATE_VALUE error - Composite REST API by External Id

I'm trying to upsert a record using an external Id with composite API. my external Id is (External ID) (Unique Case Insensitive) - to be precise - I created this field only with the external Id ...
0
votes
0answers
7 views

Create a URL Formula to access an SObject UI using an external field

We typically have multiple systems that write on Salesforce two objects, A and B, which are related. Since we cannot perform any assumption on which one gets written first, we need to encode "...
1
vote
1answer
863 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 ...
0
votes
1answer
49 views

Update child record based on parent external id

I have two custom objects, the Rate Cards and the Rate Card Lines. What i need to do is to create rate card and rate card line records by deserializing two json files(one for the rate cards and one ...
0
votes
1answer
26 views

Upsert without an external Id

We have external system that is pushing an event using Platform events saying that an asset is changed. I have created a Platform event object and a trigger on it, make a webservice callout to get ...
0
votes
0answers
17 views

Errors when using Import Wizard to upsert custom object records with external ID

I am trying to upsert a large number of records into a custom object "Invoices". This Invoices object is a child of Accounts. Thus, every Invoice record I upsert must be associated with a ...
0
votes
0answers
32 views

upsert Records using standard API and external Id

We want to give an external system the standard API to upsert records from Account Object with an external Id. The records have an associate parent Account that needs to be filled also with the same ...
1
vote
1answer
43 views

Set Packaged Custom Field as External Id After Initial Deployment

I've been struggling to find a definitive answer as I've seen contradictory information. In our managed package we have a custom field that we want to make an External Id, but is this possible at all, ...
0
votes
2answers
1k views

Make Custom '__c' Field Searchable in Global Search Bar

I have a custom field at the Opportunity Product level that can't be searched at the moment on the global search, even if I click on 'search all' I have seen this link that selects 'external ID' on ...
2
votes
1answer
43 views

Reference lookup external Id when inserting records in composite API call

I am trying to insert standard Account records at the same time as child records (designed by relation Related_Person_Account_Relations__r). I am using the Composite tree Account endpoint (/services/...
1
vote
1answer
1k 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 ...
0
votes
1answer
586 views

How Does Upsert Work When No External Id Is Specified?

I have looked at the documentation on Database Methods. What I do not understand is, what happens when an upsert is performed without specifying an external id field? Is it just based on whether or ...
1
vote
0answers
42 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
75 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
62 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
28 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
234 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
31 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
38 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
144 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
120 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
1answer
48 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
66 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
54 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
86 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
0answers
24 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
27 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
191 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<...
4
votes
2answers
825 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/...
0
votes
1answer
264 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
434 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
80 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 ...
-1
votes
2answers
84 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 ...
0
votes
0answers
63 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
44 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
491 views

Setting value of AccountId / ContactId on AccountContactRelation by trigger using external ID

I have created a custom field on my AccountContactRelation called SurrogateId__c and I set configured it to be an External Identifier. When I create an AccountContactRelation from an external ...
1
vote
2answers
808 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 ...
0
votes
1answer
63 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, ...
4
votes
2answers
2k 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
1answer
102 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
0answers
188 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 ...