Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Running WI Export (html or cvs) via Java Client

I would like to automate some query export (e.g. send it by mail every day)
Is there a way to do it via API?

I can iterate a query results and ask every attribute, but is there a way to perform the same action like exportin items in the UI?

Thanks,
Moti

0 votes



2 answers

Permanent link
I would like to automate some query export (e.g. send it by mail every
day)
Is there a way to do it via API?

I can iterate a query results and ask every attribute, but is there a
way to perform the same action like exportin items in the UI?

The HTML and CSV export can be called via URL, which is probably the most
convenient way for you (I assume you would have a shell script which is
run once a day and could get the export using e.g. 'curl').

The URLs are of the form

https://jazz.net/jazz/resource/itemOid/com.ibm.team.workitem.query.QueryDescriptor/_g6IlwDWTEd6mccAyNHwwhQ?_mediaType=text/csv

To find the URL for your particular query, you can look at the links of
the 'Download as Spreadsheet' and 'View ... in Printable Format' buttons
in the Web UI.

--
Regards,
Patrick
Jazz Work Item Team

0 votes


Permanent link
Thanks a lot Patric,

This script is working for me:

curl -k -c .\cookies.txt "https://<repository>:9943/jazz/authenticated/identity" > temp.html

curl -k -L -b .\cookies.txt -c .\cookies.txt -d j_username=%1 -d j_password=%2 https://<repository>:9943/jazz/authenticated/j_security_check > temp.html

curl -k -b .\cookies.txt https://<repository>:9943/jazz/resource/itemOid/com.ibm.team.workitem.query.QueryDescriptor/_pz6r4HdoEd6zr914Fr4kGg?_mediaType=text/csv > QueryResult.csv

Regards,
Moti

0 votes

Your answer

Register or log in to post 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,926

Question asked: Aug 06 '09, 5:39 a.m.

Question was seen: 5,540 times

Last updated: Aug 06 '09, 5:39 a.m.

Confirmation Cancel Confirm