I usually access some ticket information from my company’s Jira using the method issue view:issue-xml
, directly from my laptop browser.
https://mycompany.atlassian.net/si/jira.issueviews:issue-xml/TICKET-123/TICKET-123.xml
As I am already authenticated to Jira, this doesn’t ask me for login but if I try to access the same information by Google Sheets it doesn’t work.
Can I authenticate myself by accessing the same methods? Something like passing a username/password in the parameters of the URL or (better) a token ID in the URL as well.
My final target is to use the APIs endpoint to Google Sheets and import with the function IMPORTXML.