To export certain tables, you'll need to add a Jira API token. These tables include:
Project Roles: only the Administrator can export this table
Group Members: only the Administrator can export this table
User Jira Properties: only the Administrator can export this table
User Profiles
Sprint Reports
Sprint Report Issues
Velocity Charts
All Assets tables
Users: you can't export inactive users without a Jira API token
In all other cases, a Jira API token is not necessary.
In your Jira Cloud instance, select your profile picture, and then select Manage account.
Select the Security tab, and then select Create and manage API tokens.
Select Create API token.
The Create an API token pop-up window will appear.
In the Lebel* field, enter the name of your API token, and then select Create.
Select a label that is short, memorable, and easy for you to remember.
Select Copy.
Before closing the window, make sure you copy your new API token. You won’t be able to see this token again.
Go back to your Jira Cloud instance, select Apps, and then select SQL Connector for Jira.
On the left-side menu, select Tokens, and then select Jira API token.
In the Email* field, enter the email you use with your Jira Cloud instance.
In the API Token* field, paste your newly-created API token, and then select Validate & Save.
