Extracting incremental data

Officially Answered

Follow

New post

John Marsh

• August 02, 2019 08:46

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?

0

• 

  Maxim Shestakov

  • August 02, 2019 11:27

  Hi John!

  Thanks for your message.
  It is possible with a new Reporting feature (it is currently in a preview state).
  If you want, we could enable it for your account.

  Regards,
  Maxim

  0

  Comment actions Permalink
• 

  John Marsh

  • August 12, 2019 08:45

  Hi Maxim,

   

  I did send you an email response to this but I can see it is not on here. Please enable this for my account if possible. It would be a very useful feature.

   

  Thanks

   

  John

  0

  Comment actions Permalink
• 

  Maxim Shestakov

  • August 12, 2019 13:41

  Hi John!

  We didn't receive additional emails from you. I've just created a ticket from this request - please provide your Organization name there.

  Regards,
  Maxim

  0

  Comment actions Permalink

Please sign in to leave a comment.