UPSERT Partial JSON

Question

I am trying to add a feature by which I can update all records from a JSON payload, but the insert should only occur for those which have "archived" value = False.

below is a sample JSON. My batch job currently adds all records ,both for archived = true and false. How ever , I would like false records to be added and existing records to get updated and even change from false to true. But for any insert with archived = true , should not get added to SF.

I tried the trigger (after insert) approach to check for archived = true , but that bombed because as soon as SF found one record which matches the criteria (record 1 .. payload below), it prevented that insert , but even stopped update of sister roots (record 2) from the same payload.

Checking the archived condition in the controller class also worked for insert, but it won't update existing records from the same payload.

{  
   "content":[  
      {  
         "record":1,
         "number":12345,
         "archived":"True"
      },
      {  
         "record":2,
         "number":54321,
         "archived":"False"
      }
   ]
}

Answer 1

Okay team. I finally found a way. I did add try the scenario with a validation rule, but it did not work, as all other changes were rolled back, when one entry had archived =true.

So instead I queried all the existing records using SOQL.

Map<Decimal, List<sObject>> existingMap = GroupBy.decimals('primary_key', [SELECT Id, primary_key,Order_Id__c FROM sObject WHERE primary_key IN :parent_object_list]);

And used an if-condition to check all incoming records for boolean condition (archived == True) and use primary key to check for existing records. If primary_key exists, I am updating the record. If not and boolean flag is true, I am rejecting insertion.

if(list.Archived__c == True && existingMap.containsKey(list.primary_key) == False)
  {
    errors.add('Archived record insertion is rejected: ' + list.primary_key);
    recordsToIgnore.add(counter_value);  
  }

In this way, all updates are successful, even when an entry is archived , while all archived insertions are rejected.

Thank you all for your input.