Google Apps Script fetch data from private network (vpn)

3.3k Views Asked by At

I've tried to do use Jira API for my application, but Jira is placed like a private network.

UrlFetchApp.fetch responds with a DNS error.

How do I resolve this problem ?

1

There are 1 best solutions below

0
On

Apps Script is a cloud based solution. Your onpremise JIRA server won't be accessible.

Google once upon a time supported connection through firewalls with the Secure Data Connector but this has now been discontinued.

Best option is to have a local solution extract and deploy a reporting format to be consumed via Google Drive if you need Apps Script access.

from: Does code on a Google sheet runs locally or on a Google server? - UrlFetchApp returns empty