Importing all issues, cross-project, via REST API in Excel

[Carlo Gonella]

Hi everyone,

The company I work in has some people that have issues assigned to different projects.

To use some dashboarding in Excel, I need to :

- import all the issues contained in some projects ( ie pr1, pr2, pr4, pr6, pr8 ) in Excel using REST API .

I tried different jql codes, but it seems that I have to define which issues I want, and there's no way to select ALL the issues from all the selected projects. 

Besides, I need to import all the fields for each issue, then in excel I will do the dirty job ... 

Thank you all.

-cg

[Carlo Gonella]

answered below

[Trudy Claspill]

Hello @Carlo Gonella 

Welcome to the community.

Please show us what you have already tried.

[Carlo Gonella]

Hi Trudy. 
https://companyname.atlassian.net/rest/api/2/jql="project in (ML, DVPS21, TDB, DVPS, TDI)

is what I found online. 

I also tried :
https://companyname.atlassian.net/rest/api/2/issue 

And even if I use my API token at the beginning ( username:APItoken@.... ) 
it doesn't work,

Thanks,

-cg