How to get JSON Information via the rest API?

[Marcus_Dyer]

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]

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