How do I export all issues from particular project in JIRA DC

[RG]

Dear Experts,

I would like to export all issues from a particular project in JIRA data centre with all fields, all comments history and attachment reference links.

Purpose : Want to migrate data to Microsoft Dynamics

JIRA Version : 10.3.4 Datacentre

All comments and attachments are important for this export.

Please suggest how can we proceed with this.

Any script or 3rd party tool?

Thanks

[Marc -Devoteam-]

Hi @RG 

As mentioned by @Gunjan Kumar API is the most reliable.

Otherwise, search for issues via JQL and then export the results with all fields

[Aron Gombas _Midori_]

Microsoft Dynamics has extensive support for importing data from Excel files. (It is not surprising as both belong to MS, of course.)

You can export Jira issues with all fields, comments and attachment references to Excel files using the Better Excel Exporter app:

This route seems a relatively easy one to me, without coding required.

(Discl. this paid and supported app is developed by our team. Free for 10 users.)

[Natalia_Kovalchuk_SaaSJet_]

Hi RG!

If you need to export all issues from a particular project in Jira Data Center, including all fields and comment history, I recommend you try Issue History for Jira (Work Item History) app from the SaaSJet team. 

Using it, you will be able to do the following:

• Export full comment history (who added, edited, and when)

• Export complete change history (status, assignee, priority, etc.)

• Filter by project and date range

• Generate structured, export-ready reports in CSV or Excel formats.

Also, this article may help you to get the info related to other export methods: 5 Ways to Export Tasks and Project Data in Jira Data Center

[Gunjan Kumar]

Hi RG,

Using JSON via the Jira REST API is the most reliable and Atlassian-supported way to export all issues from a project with all fields, full comment history, and attachment references.

The simplest and recommended approach is to use the Jira REST API with a JQL query (for example, project = KEY) to export issues in JSON format. This export includes all fields, complete comments, and attachment details with download links, so attachments can be downloaded separately. The normal CSV export from the Jira UI is limited and not suitable for migrations. Therefore, using the REST API and then importing the exported data into Microsoft Dynamics is the best solution.

[RG]

@Gunjan Kumar Thanks for suggestions. Could you please guide me with the steps/JQL. I am using one but not working as expected.

https://<BASE URL>/rest/api/2/search?jql=project=ABC

[Gunjan Kumar]

Use this one:

For 1000

https://<BASE_URL>/rest/api/2/search?jql=project=KEY&fields=*all&maxResults=1000&startAt=0

For more than 1000

https://<BASE_URL>/rest/api/2/search?jql=project=KEY&fields=*all&maxResults=1000&startAt=1000