I have a SOAP request that sets the lookup fields using the lookup object's external IDs. However, for one particular lookup, I can't guarantee that it will find a matching Salesforce record. If that's the case, I still want it to insert, but insert with the lookup field set to null.
Currently, it will just throw an error saying the lookup value is not found. Is there a way to get around this in the SOAP message?
I'm using XSL transformations via the Oracle Service Bus.
:Foreign key external ID: 123456 not found for field Order_External_Key__c in entity Order:INVALID_FIELD;