I usually access some ticket information from my company's Jira using the issue view:issue-xml method, directly from my browser.
https://mycompany.atlassian.net/si/jira.issueviews:issue-xml/TICKET-123/TICKET-123.xml
Now I am trying to access the same information by Google Sheets but, correctly, the application can't authenticate to Jira and the consequence is that I can't open the same address.
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.