I'm building an integration between VSTS TimeTracker and our accounting system to generate employee timesheets and client invoices. The Reporting API provides exactly the data we would need.
As part of the integration, we'll be reviewing the time entries for each employee before sending to accounting. This review would be different than the approval process, as it would integration client and other mappings to obtain an accounting level review of activity. Our review will be on an employee by employee basis and we will want to review "live" data".
Currently, the Reporting API only allows us to filter by date range and NOT by employee. This means for each review we will need to retrieve time entries for all users and filter on our end. This is certainly doable, but I have scaling concerns and would prefer to minimize loads on both of our servers.
I've tried using standard odata $filter on both TeamMember and UserId and both yield similar errors:
"The property 'TeamMember' cannot be used in the $filter query option."
Would it be possible to add some sort of filtering to the Reporting API to allow us to retrieve entries for a single user?
Thanks.
-
Gregory,
We are working on new Reporting API where we are going to implement vast majority of features of OData, including $filter, $orderby, $aggregate features.
I think it is what you need, I will let you know when we release new API in preview mode that you can test it before we release it publicly.
Maxim Lutsan
Post is closed for comments.
Comments
1 comment