Feature #5303
closed
Add spent_hours to /issues/index API
Added by Alex Last over 14 years ago. Updated over 3 years ago.
0%
Description
I'm trying to import redmine tasks into Microsoft Project through REST API.
I need "time spent" info for tasks to update the remaining time properly in MSP plan.
can we add the corresponding API ?
Related issues
Updated by Alex Last over 14 years ago
I haven't looked at the redmine database structure, but I believe adding this info into basic/default data packet sent by Redmine REST API can slow down the system because it would require SQL select from several tables.
maybe we could introduce a special parameter for REST API to indicate that additional info should be added to the data structure? this way we can keep the default data format intact and only add extra fields (by running more expensive SQL queries) only when needed
Updated by Jean-Philippe Lang over 14 years ago
spent_hours is already present in /issues/1.xml
Updated by Alex Last over 14 years ago
Jean-Philippe, is there a way to add that information to "issues list" response as well (let's say, if some additional parameter is provided in the request). The reason I'm asking about this - it would be very ineffective to load data from Redmine to an external system (like Microsoft Project ) this way. If I export 500 tasks, I'd have to perform 500 additional requests to get the "time spent" info for every task being exported.
I'm currently working on a system, which automatically generates Microsoft Project (MSP) files from the real data stored in Redmine. This way we can reuse all possible reports provided by MSP.
Updated by Jean-Philippe Lang almost 14 years ago
- Subject changed from get "time spent" info through REST API to Add spent_hours to /issues/index API
Updated by Maxim Zyukin over 12 years ago
I'm working with Alexey on the system.
And one of our customers asked for this ability.
Could you, plz, implement this feature?
Updated by Ivan Cenov over 11 years ago
Do you need this: http://www.redmine.org/projects/redmine/wiki/Rest_TimeEntries
If so, I think this issue could be closed.
Updated by Daniel Felix over 11 years ago
- Due date set to 2013-03-31
- Status changed from New to Needs feedback
Please give some Feedback if note 6 solves your problem/if everything is fine.
Please give some feedback in the next 14 days. Otherwise this issue will be closed. Thanks.
Updated by Alex Last over 11 years ago
no, the point was to include time info into "get issues" response so that the client code won't need to perform dozens or hundreds of extra requests after receiving a list of issues. we already implemented the import, so I don't really care that much.
Updated by Daniel Felix over 11 years ago
- Due date deleted (
2013-03-31) - Status changed from Needs feedback to New
I'm removing due date as this one still needs some further investigation.
Updated by David Lukas Müller over 11 years ago
- When selecting issues via a query like this
http://myhost/redmine/issues.json?cf_7=42, thespent_hoursinformation is missing - But wenn I ask for a single issue details directly via
http://myhost/redmine/issues/1234.json, thespent_hoursinformation is provided
I'm using Redmine version 2.3.1.stable on Ruby version 1.9.3 (x86_64-linux) with Rails version 3.2.13 (Database adapter Mysql2).
Beside some other plugins, I'm using "redmine_spent_time 2.5.0"
Updated by Toshi MARUYAMA almost 10 years ago
- Related to Defect #18943: REST API does not return spent_hours when listing issues added
Updated by Go MAEDA over 3 years ago
- Is duplicate of Feature #34857: Add total estimated hours, spent hours, total spent hours for issues to issue list API added