We had a requirement to update a text area field of a custom object. As it was a bulk update, we use Database.upsert using an external id (happened through script already created in Mulesoft) and provided only text area field values. In this process what happened is - all the parent lookup field values changed to blank. Below are my queries-
- When salesforce executes upsert command, do we need to provide lookup field values again?
I haven't seen anything like this. Please correct me if we are doing something wrong over here.