要約

Users of the Jira Cloud for Excel add-in may experience performance issues, errors, or authentication failures when attempting to retrieve data from Jira Cloud. This article provides steps to troubleshoot and resolve such issues.

環境

• Jira Cloud

• Jira Cloud for Excel Add-in (available on Microsoft AppSource)

• Microsoft Excel

診断

Users may encounter errors such as:

• "Must set field 'siteId' in request."

• Significant lag or failure when loading data from Jira into Excel

• The add-in not responding or failing to retrieve issues

These symptoms typically indicate an authentication problem where the connection between Excel and Jira Cloud is either missing or has expired.

原因

The issue is often caused by:

• A session timeout or an expired authentication token

• A missing or incorrectly set siteId parameter in the request

• Network-related restrictions blocking API requests

ソリューション

To resolve the issue, follow these steps:

1. Disconnect and Reconnect Jira Cloud for Excel:

   • Open the Jira Cloud for Excel add-in.

   • Navigate to the Settings menu.

   • Click Disconnect Site to remove the existing connection.

   • Reconnect by selecting Get Started and logging into your Jira Cloud instance.

2. Force Re-authentication:

   • Instead of reconnecting to the same site, try selecting Connect to another site in the add-in.

   • Authenticate using your Jira Cloud credentials.

   • Once authentication is complete, switch back to the desired Jira site.

3. Check Network and Permissions:

   • Ensure that no firewall or security restrictions are blocking requests from Excel to Jira Cloud.

   • Confirm that you have the necessary permissions to retrieve Jira issues using the add-in.

4. Restart Excel and Try Again:

   • Close and restart Excel after performing the above steps to ensure the changes take effect.

Additional Notes:
If the issue persists, consider testing on another device or network to rule out local restrictions. If the problem continues, reach out to support with details of the error message and any troubleshooting steps already attempted.