Get record field after Error in Database.Upsert

apexdatabasedml

I'm upserting some records using Database.upsert, after that, I'm supposed to get the errors and pass them to a custom logger.

The problem is, the way this class works, I'd need to get a field value from the object that failed to upsert, is there any way to do so?

As far as I know, resultUpsert.getErrors won't return me any of the upserted fields.

Here's a code snippet of what I'm trying to do, it's not really doing anything, but anyway:

   if(lstNota.size() > 0){
            List<Database.upsertResult> resultUpsert = Database.upsert(lstNota, Nota_Fiscal__c.ID_externo_JDE__c, false);
            
            for(Integer i = 0; i < resultUpsert.size(); i++){
                ResponseNota res = new ResponseNota();
                if(!resultUpsert[i].isSuccess()){
                    if(resultUpsert.isCreated){

                    } else {
                       // here I'd like to access the fields to pass to my logger class, if possible.                       
                    }
                }
            }          
        }

I'm fine with any approaches to this, as long as it gets done.

Best Answer

The array of List<Database.upsertResult> will be in the same order as the records in lstNota. In other words:

for(Integer i = 0; i < resultUpsert.size(); i++){
  ResponseNota res = new ResponseNota();
  if(!resultUpsert[i].isSuccess()){
    if(resultUpsert[i].isCreated){
      // ...
    } else {
      sObject record = lstNota[i];
      doSomethingWith(record, resultUpsert[i]);
    }
  }
}

Related Solutions

[SalesForce] Get Error record on bulk upsert

Change your loop from for-each to indexed:

for(Integer idx = 0; idx < srList.size(); idx++) {
    if(srList[idx].isSuccess()) {
        ...
    } else {
        ...
    }
}

srList[idx] will correspond to accts[idx].

This is guaranteed in the documentation:

An array of Database.UpsertResult objects is returned with the upsert database method. Each element in the UpsertResult array corresponds to the sObject array passed as the sObject[] parameter in the upsert Database method; that is, the first element in the UpsertResult array matches the first element passed in the sObject array, the second element corresponds with the second element, and so on. If only one sObject is passed in, the UpsertResults array contains a single element.

[SalesForce] Simulate DML error in Unit test

My way in this situations - using Service Locator

public class MyServiceLocator {

    private static final Map<Type, Type> customTypesMap = new Map<Type, Type> {
        MyIDatabase.class => MyDatabase.class,

        // Services
        MyICustomObjectService.class => MyCustomObjectService.class,
        MyIHttpService.class => MyHttpService.class,

        // DAOs
        MyICustomObjectDao.class => MyCustomObjectDao.class
    };

    private static final Map<Type, Type> testTypesMap = new Map<Type, Type> {
        // Mocks
        MyICustomObjectDao.class => MyTestCustomObjectDao.class,
        MyIHttpService.class = MyTestHttpService.class
    };

    public static Type resolve(Type t) {
        if (Test.isRunningTest()) {
            if (testTypesMap.containsKey(t)) {
                return testTypesMap.get(t);
            }
        }

        if (customTypesMap.containsKey(t)) {
            return customTypesMap.get(t);
        }

        return t;
    }

}

And in MyTestCustomObjectDao I can throw exceptions. For different behaviors you can add flag for unit test (throw or not throw exceptions).

Best Answer

Related Solutions

[SalesForce] Get Error record on bulk upsert

[SalesForce] Simulate DML error in Unit test

Related Topic