we are unable to download Issue transition list in Excel

[yogesh kumar]

We are working under a company and the company not ready to give any admin rights to the contract employee. 

We need to extract the data from JIRA and manually need to enter the transition details to the team. This will be very difficult to the team to enter in manual way. 

When I try to extract using VBA code,  its not picking the right value . 

Could you please guide me on how to extract the transition data with basic user rights. 

[Sudarshan]

Hello @yogesh kumar Welcome

Extracting for a non admin may not give you free/full access.
and I suggest try with NodeJS or Java more info about the JIRA REST API here

can you also give us an idea of what have you tried using VBA?

Normally as a jira user (with minimum rights, view, Create) the transition details are available only for the issue page, even if you export the single issue, you will not get it.!

if your org wants to track how long a issue has been in a specific status -- you can try understanding the control chart 

Hope this helps you.!