I'm using the data from 7Pace to bill customers for the time we have spent on their projects. As there is a lot of data (and the API calls are slow) I would like to have a local database (Azure) that holds the work item ID, User, Record Date and Duration in Seconds. There doesn't seem to be a Update Time or anything I can use to incrementally pull the data across.
How would you recommend I synchronise the data so that if someone comes back off holiday and updates some time from 3 weeks ago?
Please sign in to leave a comment.