We are looking to archive the call records, but may be approaching things the wrong way.
Using the basic: /restapi/v1.0/account/~/call-log?view=Detailed&perPage=900
(Yes we loop through the pages using nextPage)
We receive the call logs for the past 24 hours. We record them in SQL and were under the impression that the id was a unique identifier to the call record. So we run this every 5 minutes as we use this data for integrating with our wallboards and CRM in addition to archiving.
We do not want duplicates, so we filter for existing ids that exist in our SQL database.
The issue is we end up missing calls. It appears that there are multiple records with the same id, same session id but in cases different timestamp and duration etc.. (Unless the RC system is updating and existing call record in their system.) Again we were under the impression that a call was only logged in RC when it is completed.)
So in short is there an actual unique identifier or key-combination to use? Or is there a better approach to this method?
Thanks ahead of time.