How to get JSON Information via the rest API?

Question

I am trying to get some JIRA issues into a JSON format and display it as a message box in Excel, this is my code for a button so far and when I run it just gives me the error "You do not have permission to see the specified issue login required"

Michael Raj_18ewee · Answer

Hi @Marcus_Dyer ,

you have to add authorization header with login & password hash.

I recommend Red Stapler's tutorial available here: https://www.youtube.com/watch?v=nScy6S9tcmI&list=PLbu98QxRH81I6_CkO2nasj-Vlmpq2nWci

After all videos everything will be clear.

Best,

Michael