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
0 answers
10 views

How to use navigationmixin on externalobject with external-Id

I have a lwc page on click of the button i need to open an external object via external-id. I know that i can first make a query with ext-id and get the record id and then i can redirect, but is there ...
user avatar
  • 309
0 votes
1 answer
21 views

Clear a Lookup Field in an upsert call through Rest API

We're building an interface to upsert records into a Custom Object through Rest API. We're building the relationship to other records through external Ids, so we're using the following json structure: ...
user avatar
2 votes
1 answer
109 views

How to Create Record from LWC using External Id in lookup fields

I'm trying to create an object in LWC, without using Apex. So I found out that we can do that with CreateRecord from uiRecordApi : But I'm trying to create a Custom Object (ClientMember__c in our ...
user avatar
  • 100
1 vote
1 answer
49 views

How to connect an external id to another record using apex

I currently have a situation where new contacts are created with the chance of creating duplicates. The existing contacts have an external id. Since it is not possible to merge external ids with ...
user avatar
  • 2,066
0 votes
0 answers
118 views

MALFORMED_ID Error during integration

We have a custom object called "Activity" with 2 lookup fields and an external ID. The 2 lookup fields are Contact and Course. The Contact object contains "contact ID" as the ...
user avatar
0 votes
1 answer
17 views

Way to migrate data in bulk which reference record types

Record Type standard object lacks Unique External Id field and doesn't allow to create a custom Unique External Id field, which brings a challenge to migrate data in bulk which reference record types, ...
user avatar
  • 13.2k
0 votes
1 answer
52 views

External ID not searchable in Global Search

We have a custom object (allow search = true) with a tab default on in a sandbox where there is an External ID field on which we'd like to perform search. When searching on it, nothing is displayed ...
user avatar
1 vote
1 answer
329 views

Update (never insert) a record by External Id using REST API

Salesforce offers a way to upsert a record by a given External Id: curl https://na1.salesforce.com/services/data/v20.0/sobjects/Account/customExtIdField__c/11999 -H "Authorization: Bearer token&...
user avatar
  • 557
4 votes
1 answer
204 views

Rest API - Set polymorphic Lookup with external Id

I am wondering If it is possible to set a polymorphic lookup value with external Id with Rest API. I didn't find any documentation on this and it does work for me. Here I am trying to set the lookup ...
user avatar
  • 423
0 votes
2 answers
82 views

Rest API - Lookup Field

I am trying to upsert list of ContactPointAddresses based on external Id Address_Id__c and it is working perfectly. But when I set the lookup field ContactPointAddresse.ParentId with the external id ...
user avatar
  • 423
0 votes
2 answers
34 views

Fetch all records matching a repeating ExternalID [closed]

I have a non-unique custom field which is an ExternalID. Is it possible to fetch all records matching a given value using the REST API? The documentation example shows the API returns one record. ...
user avatar
  • 111
0 votes
1 answer
70 views

Can we create an indexed field which is not unique

I am extremely new to salesforce. I read that we can mark any custom field as an ExternalID which creates an index over it. I have a use-case where I have multiple Address records which have the same ...
user avatar
  • 111
0 votes
1 answer
97 views

Difference between Upsert and Update database methods

Good morning. Database.update (fields , allOrNothing) Database.upsert (fields, externalId, allOrNothing) I need help to understand why the second parameter "externalId" is not necessary on ...
user avatar
  • 27
3 votes
0 answers
73 views

UPSERT REST Api creates new record because of space(%20) urlencoding

I'm currently trying to use the salesforce UPSERT endpoint. The ExternalId that I'm using contains a space, like so: North America_12345 so my URL looks like: /services/data/v49.0/sobjects/...
user avatar
0 votes
1 answer
24 views

Upsert not working in apex class

I have two object temp__c and NFSave___c. I am dumping all the data in temp object through data loader in rich text area field(Section__c). Then I am sending the data with apex class from Section ...
user avatar
0 votes
0 answers
9 views

Pass Non-Salesforce Site Data to Einstein Chatbot

Does anyone know a good way to pass site data (SAP Commerce Cloud) to the chatbot? Im thinking of storing the data in a login menu then using it through findOrCreate. Ideal Scenario: User logs into ...
user avatar
-2 votes
1 answer
41 views

Check if upsert necessary

I am using external id and rest callout to another org, but is there a way to check if i need to make callout? Cause callout called even if all fields are the same. I can compare all fields, but its a ...
user avatar
-2 votes
1 answer
27 views

How to retrieve all external id fields of account object?

I have a class public static List<AccFieldWrapper> AcctFields(String Account){ Map <String,Schema.SObjectType> mapobject = Schema.getGlobalDescribe(); Schema....
user avatar
  • 1
0 votes
1 answer
257 views

Workbench upsert: how to use an External id?

I want to update a number of Cases using a CSV file that contains two fields: case number (NOT technical id, but the automatically generated human readable id/name) and a textual complaint. Data ...
user avatar
0 votes
1 answer
63 views

Why ExternalID field of parent Account is null?

I have the next code on my test Class: parentAcc.ExternalId = '001'; insert parentAcc; System.debug('parentAcc ExternalId' + parentAcc.ExternalId); childAccount.ParentId = parentAcc.id; insert ...
user avatar
  • 147
0 votes
0 answers
208 views

External Id a standard field on Custom Objects

I am writing a data migration project to take data from an external system and map it into SFDC as a hierarchical structure of custom objects using the Bulk Api 2. The pattern is as follows: Insert ...
user avatar
1 vote
1 answer
193 views

Is it possible to make a single API request which deletes multiple records using external id without creating a custom rest resource?

Let's say I have an external identifier field Account.External_Id__c. I have a web application which has the values for this field and needs to delete multiple records, (e.g. "Abc123", "...
user avatar
0 votes
2 answers
132 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 = ...
user avatar
  • 147
0 votes
1 answer
24 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 ...
user avatar
  • 1,612
2 votes
1 answer
364 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 ...
user avatar
  • 961
0 votes
1 answer
124 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 ...
user avatar
0 votes
1 answer
161 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 ...
user avatar
2 votes
1 answer
151 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, ...
user avatar
  • 701
2 votes
1 answer
424 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/...
user avatar
  • 43
1 vote
0 answers
45 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. ...
user avatar
0 votes
2 answers
419 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
user avatar
  • 101
0 votes
1 answer
167 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 ...
user avatar
0 votes
1 answer
179 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 ...
user avatar
0 votes
1 answer
52 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 ...
user avatar
0 votes
1 answer
508 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 ...
user avatar
0 votes
1 answer
237 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 ...
user avatar
0 votes
1 answer
77 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 ...
user avatar
  • 113
0 votes
0 answers
82 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 ...
user avatar
0 votes
0 answers
381 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 ...
user avatar
0 votes
1 answer
375 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 ...
user avatar
0 votes
0 answers
32 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() ...
user avatar
0 votes
0 answers
77 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 &...
user avatar
  • 129
1 vote
1 answer
394 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<...
user avatar
  • 4,511
1 vote
1 answer
697 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,...
user avatar
  • 45
0 votes
1 answer
1k 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 ...
user avatar
  • 1,051
-1 votes
2 answers
97 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 ...
user avatar
  • 45
-1 votes
2 answers
141 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 ...
user avatar
  • 45
0 votes
0 answers
146 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(...
user avatar
  • 1,051
0 votes
0 answers
25 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 ...
user avatar
0 votes
1 answer
106 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 ...
user avatar
  • 5