-
Bug
-
Resolution: Answered
-
Low
-
None
-
1.0
-
None
-
Severity 3 - Minor
-
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
- 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.
[API-291] Unable to connect to instance with an IP policy enforced
| Resolution | New: Answered [ 9 ] | |
| Status | Original: Gathering Impact [ 12072 ] | New: Closed [ 6 ] |
| Current Status |
New:
If you restrict access to your Jira Cloud instance, please add these IP addresses to your allow list:
{code:java} 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 {code} This applies to Jira for Google Sheets, Jira for Excel, and the export to Google Sheets/Excel from Jira. |
|
| Description |
Original:
h3. 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. h3. Steps to Reproduce # Connect to your Jira Cloud as described in [Use Jira Cloud for Sheets|https://support.atlassian.com/jira-core-cloud/docs/use-jira-cloud-for-sheets/] h3. Expected Results Successfully connected and can start using JQL to pull issue data from Jira h3. Actual Results {code:java} You have been deauthorized from Jira. Please connect to continue. {code} !You_have_been_deauthorized.png|thumbnail! h3. Workaround If you restrict access to your Jira Cloud instance, please add these IP addresses to your allow list: {code:java} 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 {code} This applies to Jira for Google Sheets, Jira for Excel, and the export to Google Sheets/Excel from Jira. |
New:
h3. 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. h3. Steps to Reproduce # Connect to your Jira Cloud as described in [Use Jira Cloud for Sheets|https://support.atlassian.com/jira-core-cloud/docs/use-jira-cloud-for-sheets/] h3. Expected Results Successfully connected and can start using JQL to pull issue data from Jira h3. Actual Results {code:java} You have been deauthorized from Jira. Please connect to continue. {code} !You_have_been_deauthorized.png|thumbnail! |
| Description |
Original:
h3. 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. h3. Steps to Reproduce # Connect to your Jira Cloud as described in [Use Jira Cloud for Sheets|https://support.atlassian.com/jira-core-cloud/docs/use-jira-cloud-for-sheets/] h3. Expected Results Successfully connected and can start using JQL to pull issue data from Jira h3. Actual Results {code} You have been deauthorized from Jira. Please connect to continue. {code} !You_have_been_deauthorized.png|thumbnail! h3. Workaround Please contact [Atlassian support|https://support.atlassian.com/contact/#/] so we can apply a workaround to fix this. |
New:
h3. 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. h3. Steps to Reproduce # Connect to your Jira Cloud as described in [Use Jira Cloud for Sheets|https://support.atlassian.com/jira-core-cloud/docs/use-jira-cloud-for-sheets/] h3. Expected Results Successfully connected and can start using JQL to pull issue data from Jira h3. Actual Results {code:java} You have been deauthorized from Jira. Please connect to continue. {code} !You_have_been_deauthorized.png|thumbnail! h3. Workaround If you restrict access to your Jira Cloud instance, please add these IP addresses to your allow list: {code:java} 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 {code} This applies to Jira for Google Sheets, Jira for Excel, and the export to Google Sheets/Excel from Jira. |
| Assignee | New: AlexC [ achaniotis ] |
| Status | Original: Needs Triage [ 10030 ] | New: Gathering Impact [ 12072 ] |
| Remote Link | New: This issue links to "Page (Confluence)" [ 603139 ] |
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.
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.