AnsweredAssumed Answered

Duplicate records are being created

Question asked by gouthamr388096 on Dec 19, 2016
Latest reply on Dec 19, 2016 by gouthamr388096

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?

Thanks

G

Outcomes