Hi
I am sending a request with sender, multiple numbers and ID say
Sender is same for each request
sender, number, ID
A, 9999, 1
A, 8888, 2
A, 7777, 3
For ths request when I get a msgID against each number. The response contains only the msgID and the ID I hav send in the request say
msgID, ID
ABC, 1 (for 1st number)
DEF, 2 (for 2nd number)
GHI, 3 (for 3rd number)
Now I have a table in SQl as below
Number
msgID
ID
I want to store the number and the corresponding msgID in this table.How can dis b achieved with best possible way.
My prob is in case a issue occur say at dat particular time msg ID is not genarated or the updation was not successful and another request is fired with the same sender ID and numbers so the corresponding data shoul get updated not all the data .
Say
I am sending the below req.
sender, number, ID
A, 9999, 1
A, 8888, 2
A, 7777, 3
and the updation fails but the msgID is gnerated and user sent another request say
sender, number, ID
A, 9999, 1
A, 8888, 2
A, 6666, 3
and in this case msgID is generated, den how it will update obnlly dis record not the previos one that was sent earlier.