for almost two years I have used the Google Sheet script to get data from the Jira (Server, not Cloud) installed on client premisses.
Now, in a different environment, I cannot run it properly and an error message pops saying that the address is unavailable: https://internal.clientsname.com/jira/rest/api/2/
Taking a deeper look into it I can see that the address exists and is accessible, but there is a SSL3 handshake failure and I cannot import the data from Jira.
Do you know how to solve it?
I would suggest you to try out an alternative to using script.
You can try Coupler.io Google Sheets add-on to export data from Jira Server and import it to Google Sheets. The add-on will let you set up data frequency for updates (1 hour, for instance), as well as use JQL to filter out the results you want to pull.
Please let me know if this option worked for you!
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events