When performing an upsert operation via Mulesoft on a record that is a child of Account in SFDC, we are seeing the error
"Foreign key external ID: 0000336681 not found for field SWT_Account_Number__c in entity Account".
I have queried and verified that the Account Number in question does exist in Salesforce.
Here is reference to the field in the payload:
[{
SWT_Partner_Account__r: {
type: "Account",
SWT_Account_Number__c : "0000336681"
},
}]
SWT_Account_Number__c is a "Auto Number" field and marked as external ID.
We are testing this on a sandbox that has been just refreshed from Production. Wonder if this has got anything to with the issue.