What's the easiest way to extract a certain project data from Jira into a CSV file?

[Samir Moubarak]

I need to extract a certain projects data in details to load the data over to BigQuery to be able to query more in depth and create a detailed and advanced reports.

also if there is a way to do that through Python script what attributes i need to know to be able to connect to Jira software to extract data ?

Also i noticed that to connect to Jira i have to have those three attributes:

# Set Jira API credentials

JIRA_SERVER = 'https://your-jira-instance.com'

USERNAME = 'your-username'

API_TOKEN = 'your-api-token'

Where can i find this API_Token?

[Trudy Claspill · Accepted solution]

Hello @Samir Moubarak 

Jira allows you to export issue information from the Advanced Issue Search screen to a CSV file. This does not export the issue history information, just the current issue information. You can learn more about that export function here:

https://support.atlassian.com/jira-software-cloud/docs/manage-search-results/

To connect with an API token you have to generate that token for the User Account that you want to use in the connection. Refer to

https://support.atlassian.com/atlassian-account/docs/manage-api-tokens-for-your-atlassian-account/

The method that is going to meet your needs depends on your requirements. Exactly what data do you need to get?

Have you considered using the BigQuery Connector app instead of trying to export data manually?

[Samir Moubarak]

The extract option from the the Advanced Issue Search screen to a CSV file worked perfectly .. That's what I was looking for 

Thank you so much!!

[Trudy Claspill]

You're welcome!

If your question has been addressed satisfactorily, please consider marking the Answer as Accepted.

[Samir Moubarak]

Done .. thank you so much for your help!