Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-291

Unable to connect to instance with an IP policy enforced

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Answered
    • Icon: Low Low
    • None
    • 1.0
    • Jira Cloud for Google Sheets
    • None
    • Severity 3 - Minor
    • Hide

      If you restrict access to your Jira Cloud instance, please add these IP addresses to your allow list:

      34.86.33.169, 34.86.254.214, 34.86.159.247, 35.188.250.227, 34.86.95.48, 34.86.125.23, 34.86.25.26, 34.86.189.204, 34.86.118.203, 34.86.202.157, 34.86.8.82, 34.86.247.165

      This applies to Jira for Google Sheets, Jira for Excel, and the export to Google Sheets/Excel from Jira.

      Show
      If you restrict access to your Jira Cloud instance, please add these IP addresses to your allow list: 34.86.33.169, 34.86.254.214, 34.86.159.247, 35.188.250.227, 34.86.95.48, 34.86.125.23, 34.86.25.26, 34.86.189.204, 34.86.118.203, 34.86.202.157, 34.86.8.82, 34.86.247.165 This applies to Jira for Google Sheets, Jira for Excel, and the export to Google Sheets/Excel from Jira.

      Issue Summary

      If you have an IP allowlisting policy enforced on your instance then Jira Cloud Sheets won't be able to connect or authenticate because the add-on is not automatically allowlisted.

      Steps to Reproduce

      1. Connect to your Jira Cloud as described in Use Jira Cloud for Sheets

      Expected Results

      Successfully connected and can start using JQL to pull issue data from Jira

      Actual Results

      You have been deauthorized from Jira. Please connect to continue.

        1. You_have_been_deauthorized.png
          You_have_been_deauthorized.png
          94 kB

            [API-291] Unable to connect to instance with an IP policy enforced

            AlexC added a comment -

            Clarified in the Current Status field the required list of our add-on service's IP addresses that must be added to the allow list in Jira Cloud.

            AlexC added a comment - Clarified in the Current Status field the required list of our add-on service's IP addresses that must be added to the allow list in Jira Cloud.

            James Chi added a comment -

             

            Since IP restriction (whitelisting or allowlisting) is mandatory by policy at my company,

            Either Atlassian or 3rd-party app provider  should resolve this issue.

            In my case, 3rd-party apps are 

            • Jira Cloud for Sheets by Google
            • Jira Cloud for Excel by Microsoft

             

            Here's my sugession:

            Atlassian: Add a button, at IP restriction page, like 'allow access from Jira Cloud for Sheets app', which allow access from Google app server.

            Google or Microsoft: Provides list of their IP addresses for app server. Then I can add them to the IP restriction list. 

             

            Thanks in advance,

             

            Note on CSV download:

            A workaround would be export to CSV file using menu : Export issues > Export Excel CSV (all fields).

            But, you should know that "all fields" means really all fields. My CSV file has 144 columns. 

            How do I edit it in short time? So, practically this is not a workaround.

            James Chi added a comment -   Since IP restriction (whitelisting or allowlisting) is mandatory by policy at my company, Either Atlassian or 3rd-party app provider  should resolve this issue. In my case, 3rd-party apps are  Jira Cloud for Sheets by Google Jira Cloud for Excel by Microsoft   Here's my sugession: Atlassian: Add a button, at IP restriction page, like 'allow access from Jira Cloud for Sheets app', which allow access from Google app server. Google or Microsoft: Provides list of their IP addresses for app server. Then I can add them to the IP restriction list.    Thanks in advance,   Note on CSV download: A workaround would be export to CSV file using menu : Export issues > Export Excel CSV (all fields). But, you should know that " all fields " means really all fields. My CSV file has 144 columns .  How do I edit it in short time? So, practically this is not a workaround.

            Mark Dreyband added a comment -

            We do use Whitelisting on our Jira Cloud, and impacted by this bug. Here are some more details in different configurations

            Just our own IPs whitelisted

            Once I export data from browser then receive an error message "403 Client error"

            Add additional IPs provided by Atlassian Support into our IP Whitelist

            Export data from browser- works fine

            Start Excel and try to authenticate in Jira Cloud to initiate import process from Excel is not working- I was able to successfully complete authentication process in browser, but then Excel still tries to authenticate once again (still on the step "Get Started")

            Mark Dreyband added a comment - We do use Whitelisting on our Jira Cloud, and impacted by this bug. Here are some more details in different configurations Just our own IPs whitelisted Once I export data from browser then receive an error message "403 Client error" Add additional IPs provided by Atlassian Support into our IP Whitelist Export data from browser- works fine Start Excel and try to authenticate in Jira Cloud to initiate import process from Excel is not working- I was able to successfully complete authentication process in browser, but then Excel still tries to authenticate once again (still on the step "Get Started")

              achaniotis AlexC
              lellis2@atlassian.com Belto
              Affected customers:
              7 This affects my team
              Watchers:
              17 Start watching this issue

                Created:
                Updated:
                Resolved: