Generating and fetching CSV reports URL via the API

108 views
Skip to first unread message

NewUser457

unread,
Sep 21, 2015, 11:34:05 PM9/21/15
to taigaio
The csv reports are excellent. Given that I was admin for multiple projects, is there anyway I can generate the URL and access it through an API call? I couldn't find any documentation on that. Thanks! and again great work!!

Alejandro Alonso

unread,
Sep 22, 2015, 4:00:48 AM9/22/15
to NewUser457, taigaio
Thank you very much for your comments!,

Actually CSV report system works only by project but you could use our API (it's the same the web app uses) for fetching all the data you need. All the info about the API can be found here -> http://taigaio.github.io/taiga-doc/dist/api.html

Regards!,

2015-09-22 5:34 GMT+02:00 NewUser457 <suhas...@gmail.com>:
The csv reports are excellent. Given that I was admin for multiple projects, is there anyway I can generate the URL and access it through an API call? I couldn't find any documentation on that. Thanks! and again great work!!

--
You received this message because you are subscribed to the Google Groups "taigaio" group.
To unsubscribe from this group and stop receiving emails from it, send an email to taigaio+u...@googlegroups.com.
To post to this group, send email to tai...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/taigaio/7ef5b0a3-c914-4be0-96de-476ac5593d97%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--

  
Alejandro Alonso Fernández  
CIO & Co-founder

www.kaleidos.net/FC8EAC/

Suhas Xavier

unread,
Sep 22, 2015, 4:14:01 AM9/22/15
to Alejandro Alonso, taigaio
Got it! But this is my query- here's a public project I was starting upon. In order to view the csv reports for user stories I generated a URL: https://api.taiga.io/api/v1/userstories/csv?uuid=ac698c1b8c53488a817a6645171bc650. Can you tell me which curl command I need to run in order to fetch this particular URL? I looked in my projects overview API data- it didn't contain any uuid details.
curl https://api.taiga.io/api/v1/projects/69625 -u username:secret key

Alejandro Alonso

unread,
Sep 22, 2015, 6:40:52 AM9/22/15
to Suhas Xavier, taigaio
Are you trying to get the userstories via API?, if so you could use something like:

curl -X GET \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer ${AUTH_TOKEN}" \
  https://api.taiga.io/api/v1/userstories?project=1

(the rest of the doc for this part of API is here: http://taigaio.github.io/taiga-doc/dist/api.html#user-stories-list)

Regards,

David Barragán

unread,
Sep 22, 2015, 8:16:35 AM9/22/15
to Alejandro Alonso, Suhas Xavier, taigaio
Hi,

To get the reports urls you need the "csv url uuids" and the are in every project resources, in "tasks_csv_uuid", "userstories_csv_uuid" and "issues_csv_uuid" values.

To get this values you need to get the project object making a GET request  to

GET "/api/v1/projects/<id>" 

or to

GET "/api/v1/projects//by_slug?slug=<project-slug>"

To generate or regenerate "csv url uuids" make a POST call to

POST "/api/v1/projects/<id>/regenerate_userstories_csv_uuid"
POST "/api/v1/projects/<id>/regenerate_tasks_csv_uuid"
POST "/api/v1/projects/<id>/regenerate_issues_csv_uuid"

You only need to make this calls if this values are null or if you want to change for any reason.

And noow the urls to get the csv reports are:

GET "api/v1/userstories/csv?uuid=<userstories_csv_uuid>"
GET "api/v1/tasks/csv?uuid=<tasks_csv_uuid>"
GET "api/v1/issues/csv?uuid=<issues_csv_uuid>"


Regards


For more options, visit https://groups.google.com/d/optout.



--

---

 
David Barragán Merino  
Engineer

www.kaleidos.net/FFF8E7

Suhas Xavier

unread,
Sep 23, 2015, 3:50:05 AM9/23/15
to David Barragán, Alejandro Alonso, taigaio
This is really helpful! Thank you so much!


David Barragán

unread,
Sep 23, 2015, 3:54:01 AM9/23/15
to Suhas Xavier, Alejandro Alonso, taigaio
You're welcome.
Reply all
Reply to author
Forward
0 new messages