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

Question

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 · Answer

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

Carlo Gonella · Answer

answered below

Trudy P Claspill · Answer

Hello @Carlo Gonella

Welcome to the community.

Please show us what you have already tried.