Export Issues to CSV at Group Level (or any level other than project level)

Hello,

I was hoping there might be a way to export issues to csv file at a level higher than project-level. In particular, I need to be able to report at a group level. I don’t understand why you can list and filter on issues at a group level but not export to csv at a group.

If this is not possible, I wonder whether anyone would know how to perform a roll-up operation (perhaps in a macro or script?) that takes all the issues that are found at a particular level and export to csv.

Thanks for any response.

Hi,

Unfortunately, it’s not possible from the group-level. You could maybe open an issue for it here: Issues · GitLab.org / GitLab · GitLab so that a Gitlab Dev could potentially include it for the future.

As an aside, you could use the Gitlab API to achieve what you wanted:

curl -s --header "PRIVATE-TOKEN: your-access-token-here" "https://gitlab.example.com/api/v4/groups/yourgroup/issues?state=opened"

the output is in JSON format. You could then potentially turn this into CSV format. Replace gitlab.example.com with your servername/domainname your-access-token and yourgroup from the above and it’ll do what you need. This will default to 20 per page. so you can add to the end of the URL:

curl -s --header "PRIVATE-TOKEN: your-access-token-here" "https://gitlab.example.com/api/v4/groups/yourgroup/issues?state=opened&per_page=100"

to have 100 issues per page. See pagination docs, to work with this: API Docs | GitLab

For issues, you can change state=opened to something else: Issues API | GitLab if you want to find other states for issues, such as closed, etc.

thanks so much the rest api insight. I did not know it was there. I am just starting to attempt so calls. I first need to figure out what servername/domain is (I am using remote gitlab as part of trial license) and I guess i need to create access tokens.

Access tokens you can configure in your user preferences. Give it API access so that it can make the calls. The url, will be what you use in the web browser to connect to your Gitlab instance. So if using gitlab.com it would be https://gitlab.com/api/v4 otherwise change as per the url you are using.