[SalesForce] Dynamic field for Database.Upsert

I am trying to use a dynamic field for my Database.Upsert command as follows:

String extField = objVariable + fieldVariable;
Database.UpsertResult[] up = Database.upsert(toUpsert, extField);

This however returns the following error:

Method does not exist or incorrect signature: void upsert(List, String)

How can I resolve this?

Best Answer

The signature of Database.upsert() is

public static Database.UpsertResult[] upsert(sObject[] recordsToUpsert, Schema.SObjectField externalIdField, Boolean allOrNone)

While the Boolean parameter is optional, you must provide a value of type Schema.SObjectField for the second parameter.

You can obtain such values dynamically via the Describe API given string input:

String myFieldName = 'Account';
String myObjectName = 'Name';

Schema.SObjectField f = Schema.getGlobalDescribe().get(myObjectName).getDescribe().fields.getMap().get(myFieldName);

Related Solutions

[SalesForce] Method does not exist or incorrect signature: void containsKey(Id) from the type Set

For the first one, instead of:

affectedCasesByContactId.keyset().containsKey(...)

use either the Map method containsKey on the Map:

affectedCasesByContactId.containsKey(...)

or the Set method contains on the Set:

affectedCasesByContactId.keyset().contains(...)

For the second one instead of trying to access from the List:

trigger.new.get(...)

access from the Map:

trigger.newMap.get(...)

Take a look at the available Trigger Context Variables and also do some Googling about lists and maps to get clear about how to use those most effectively.

[SalesForce] Is it possible to not use an ExternalId field for Database.Upsert

The error message is phrased confusingly. It means there's three qualities that must be met for the field to be used:

Must be an External Id
Must be custom or standard
Must be indexed

This doesn't really express much more than that it has to be an External Id.

For clearer discussion, see Upserting Records and the Upsert SOAP call. The nomenclature there is explained as

On custom objects, this call [upsert] uses an indexed custom field called an external ID to determine whether to create a new record or update an existing record. On standard objects, this call can use the name of any field with the idLookup field property instead of the external ID.

(More on idLookup).

Unfortunately, you cannot upsert using any indexed standard field.

Best Answer

Related Solutions

[SalesForce] Method does not exist or incorrect signature: void containsKey(Id) from the type Set

[SalesForce] Is it possible to not use an ExternalId field for Database.Upsert

Related Topic