Export defect query results to file via command line?

I'm trying to find a programmatic way to export queried defect
information to a local file. I know I can export defect information
from a defect query in the web client by clicking the "export to
csv" feature.

Is there any way to do this via the command line? I need a way to
export defect information to a local text file without using a GUI
interface.

As the export functionality is available using plain HTTP, you could use
'curl' to download the CSV. The export URL looks as follows:

https://server:port/jazz/resource/itemOid/com.ibm.team.workitem.query.QueryDescriptor/_7yQNQLYnEd29gJkOCv4V6Q?_mediaType=text/csv

If your server is using form-based auth, you need to log in explicity
(curl's -u parameter doesn't work here):

COOKIES=./cookies.txt
USER=user
PWD=password
HOST=https://localhost:9443/jazz

curl -k -c $COOKIES -d j_username=$USER -d j_password=$PWD
$HOST/j_security_check


Then you can do the export:

curl -k -b $COOKIES
https://localhost:9443/jazz/resource/itemOid/com.ibm.team.workitem.query.QueryDescriptor/_7yQNQLYnEd29gJkOCv4V6Q?_mediaType=text/csv


--
Regards,
Patrick
Jazz Work Item Team

Patrick,

Thanks for the reply. I think this will work perfectly for what I need. I'm having some trouble getting the first command to work. When I try it like this:
> curl -D -k -c "d:\cookies.txt" -d "j_username=username" -d "j_password=mypassword" https://server:9943/jazz/j_security_check


I get an error from the site:
HTTP Status 408 - The time allowed for the login process has been exceeded. If you wish to continue you must either click back twice and re-click the link you requested or close and re-open your browser.

I get this same error on two different Jazz installs, each running TomCat.

I haven't gotten the second command to work yet because the login isn't working yet.

Any ideas?

Thanks again,
Jarett Stein

I get an error from the site:
HTTP Status 408 - The time allowed for the login process has been
exceeded. If you wish to continue you must either click back twice
and re-click the link you requested or close and re-open your
browser.

I get this same error on two different Jazz installs, each running
TomCat.

I haven't gotten the second command to work yet because the login
isn't working yet.

Any ideas?

I haven't come across this situation yet, but I have used the script
examples only against Jetty, which may be different from Tomcat: AFAIK,
Tomcat does not allow "drive-by" logins, i.e. directly posting to
j_security_check. It expects the JSESSIONID cookie that is sent along with
the login page.

So you could probably do the following:

1) curl -k -c $COOKIES
https://localhost:9443/jazz/resource/itemOid/com.ibm.team.workitem.query.QueryDescriptor/_7yQNQLYnEd29gJkOCv4V6Q?_mediaType=text/csv
--> This will record the challenge cookie.
2) post login data
3) do 1) again.

You may want to check if 1) already returns the export CSV (you may this
have a valid cookie in the cookie file).

--
Regards,
Patrick
Jazz Work Item Team