I have a process that exports data to a mysql table. One of the requirements is to check if records exist in destination table. If they d onot exist, I create records. If they exist, I check to see if those records also exist in salesforce and update the record.
Now when there are not records in the destination, the process runs fine ( as shown below). Also see second screenshto of the data in table.
Data in MySQL destination table
Now that there are some records in destination table. I rerun the process. So now because the records are there, they should be updated. As expected, the process goes into the update part of the process (see below)
The screenshot of destination table
What is happening is that whatever is the last request id , that is being populated for all the rows (as seen above). I have no clue why this happens. Can anyone suggest please?