Reportable REST interface -- apt/workResourceDetails not working
I'm trying to use the reportable REST interface to query all of the Contributors assigned to a development line and their work assignments. The query I'm trying to use is:
https://hub.jazz.net/ccm01/rpt/repository/apt?fields=apt/workResourceDetails[developmentLine/itemId='...']/(*|contributor/*|contributor/workDays/*|contributor/absences/*) but the response always come back empty. In fact, even just a simple query for any workResourceDetails comes back empty (e.g. https://hub.jazz.net/ccm01/rpt/repository/apt?fields=apt/workResourceDetails/*&size=5 I've used this type of query on other RTC installations, so this seems to have been intentionally disabled on Jazz Hub-- can this be reenabled? Thank you in advance. - Andre Asselin |
2 answers
You may be putting wrong itemId value in it. (Perhaps value of workResourceDetails/itemId instead of developmentLine/itemId ..... at least I did that mistake initially)
This URL works for me
Comments and I received this output http://pastebin.com/2LFvjNig Ankur,
I am not a member of your project area so can not see the data related to it. Is it a public project area? Can you give me some access to it for few days which we can remove later once this is sorted out?
Andre Asselin
commented Aug 26 '13, 11:18 a.m.
Ankur,
Andre Asselin
commented Aug 28 '13, 11:45 p.m.
Ankur,
Can you share the project link. I will then send you a request to join which you can accept. Posting email address is on a forum is not a wise thing to do :)
Andre Asselin
commented Aug 30 '13, 10:03 a.m.
https://hub.jazz.net/project/asselinps/test1 My bad. Currently Jazzhub doesn't exposes the Work Allocation data. Since it is not set for the user, hence not showing up in the REST output.
Andre Asselin
commented Sep 03 '13, 9:50 p.m.
Ankur,
showing 5 of 9
show 4 more comments
|
Starting from: fields=apt/workResourceDetails/* will only list the explicit assignments. It will not list the system generated default assignments. If you want the implicit default assignments, use: fields=apt/contributor/(name|assignments/*) Please avoid using wildcards against a production server, the results could be huge and only ask for the fields you need.
Comments fields=apt/contributor/(name|assignments/*) will actually return the combined implicit and explicit assignments. But the call can be expensive as it has the examine data like: team area membership combined with the explicit assignments, etc... This is inline with what I found here as well. Once I went and generated some explicit data, I was able to get results with the requests you provided. If you run them again, you will see there is some data coming back now as I put in some work allocations for myself.
Andre Asselin
commented Sep 05 '13, 9:21 p.m.
Thanks guys for the suggestions. My goal is to try to get all the assignments, absences, and work day info for everyone assigned to a particular project so that I can create reports and such.
Andre Asselin
commented Sep 05 '13, 9:30 p.m.
Starting from apt/contributor, you can't filter on a developmentLine/itemId. Ex:
Hi Andre. I am not sure what tool you are using to collect the data. But you could create one query to fetch all the members of a project area. Then iterate over each member and find their assignments. A tool like RPE makes it easy to write such reports and can even let you filter on the data just in case some of those filters cannot be expressed in a single URL.
Adam @agarcher,
@andre I was able to get it to work for private projects. I believe the reason it looked like it wasn't working for private projects was because there wasn't any explicit data.
Andre Asselin
commented Sep 12 '13, 8:35 a.m.
@agarcher FYI, my userid is @asselinps, so Jazz.net didn't send me a notification for your last comment.
showing 5 of 8
show 3 more comments
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
Hi Andre,
We haven't deliberately disabled the API, so it's probably an issue with our deployment. We'll look into it and let you know what we find.
I can confirm that the problem exists, even for me with Admin permissions on that RTC server. This script shows the empty result from hub.jazz.net/ccm01 versus a full page from jazz.net/jazz:
!/bin/sh
verbose="-v"
verbose="-silent"
jazzUserid="jazzuser"
jazzPassword="jazzpassword"
serverURL="https://hub.jazz.net/ccm01"
serverURL="https://jazz.net/jazz"
curl $verbose -c cookies.txt -b cookies.txt -k -L $serverURL/authenticated/identity
curl $verbose -k -c cookies.txt -b cookies.txt -d j_username=$jazzUserid -d j_password=$jazzPassword $serverURL/authenticated/j_security_check
curl $verbose -c cookies.txt -b cookies.txt -k -L $serverURL/rpt/repository/apt?fields=apt/workResourceDetails/*&size=5
@asselinps, I assume you are authenticating when you invoke the service? And you get a valid, but empty response?
We'll continue to investigate why we're seeing the empty responses. It may be a permissions issue.
@Scott Rich, correct, I am authenticated, and get a valid, empty response.
Thanks for looking into this!
- Andre Asselin
@Scott or @Adam,
Any progress?
- Andre
ping......