How to Export Data Requiring Jira API Token

Owned by Liliia Ostrovska
Last updated: Jul 05, 2024
2 min read

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 (Insight) tables

  • Users: you can't export inactive users without a Jira API token

In all other cases, a Jira API token is not necessary.

 

  1. In your Jira Cloud instance, select your profile picture, and then select Manage account.

 

  1. Select the Security tab, and then select Create and manage API tokens.

 

  1. Select Create API token.

The Create an API token pop-up window will appear.

  1. 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.

 

  1. Select Copy.

 

  1. Go back to your Jira Cloud instance, select Apps, and then select SQL Connector for Jira.

 

  1. On the left-side menu, select API Integrations, and then select Jira API token.

 

  1. In the Email* field, enter the email you use with your Jira Cloud instance.

  2. In the API Token* field, paste your newly-created API token, and then select Validate & Save.