Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to export issues and their links via JSON instead of CSV

Problem: The built-in JIRA Export to CSV only lists the linked issue's key, but not the link type. This is a known limitation. For example, see here: Known Issue.

I am performing an export of many issues in order to import them via CSV to another JIRA server, and I need to know the link type.

The solution that I devised is to export to JSON instead of CSV.

Step 1: Create an input JSON (save it in file input.json). Note that you cannot retrieve more than 1000 issues in one call, so you need to limit the search and perform subsequent calls if you have more than 1000 issues.

"jql": "project = \"Your project name here\" AND key >= FOO-1 AND key < FOO-1001 order by key asc",
"maxResults": 1000,
"fields": [

Step 2: Run curl on the JIRA server's REST API with the above JSON. This is on Linux and you need to have 'jq' installed:

curl -k -u user:password -X POST -H "Content-Type: application/json" --data @infile.json | jq '.' > outfile.json

Step 3: The output file will have all the issues and in each, the fields that you've specified:

"expand": "schema,names",
"startAt": 0,
"maxResults": 1000,
"total": 502,
"issues": [
"expand": "operations,editmeta,changelog,transitions,renderedFields",
"id": "140026",
"self": "",
"key": "FOO-1",
"fields": {
"issuetype": {
"self": "",
"id": "26",
"description": "",
"iconUrl": "",
"name": "CCB",
"subtask": false
"customfield_11280": {
"self": "",
"value": "No",
"id": "12252"
"issuelinks": [
"id": "59700",
"self": "",
"type": {
"id": "10020",
"name": "Related",
"inward": "Related",
"outward": "Related",
"self": ""
"inwardIssue": {
"id": "139870",
"key": "NGAC-9643",
"self": "",
"fields": {
"summary": "BCP || Cases still exists in queue after case was closed",
"status": {
"self": "",
"description": "The issue is considered finished, the resolution is correct. ",
"iconUrl": "",
"name": "Closed",
"id": "6",
"statusCategory": {
"self": "",
"id": 3,
"key": "done",
"colorName": "green",
"name": "Done"
"priority": {
"id": "3"
"issuetype": {
# more fields here
}, # end of the 1st issue here
{ # start of next issue
] # end of all issues
} # end of the JSON

 Step 4: If you need your output as CSV, use your favorite programming/scripting language to transform the JSON to CSV. This is basically what the JIRA UI does when you do Export to CSV...




Hi there,

is there a way to use this kind of export for exporting remote links?

On cursory check, the answer seems to be negative. When I'm retrieving an issue via REST API, like this:


it only returns the same-server links.

In the browser, I do see the external links as well.

I will research it further sometimes later.

Quick update: we're running Jira 8.8.1 (on-prem) and the REST API call still does not retrieve remote links.

Like Sébastien Lesourd likes this


Log in or Sign up to comment
Community showcase
Published in Jira

Admins, notify your Jira instance of system-wide changes with the new admin announcement banner

Hi All! We’re excited to share the launch of an announcement banner that lets Jira site administrators communicate directly to their users across their  Jira Cloud instance.  ...

635 views 16 18
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you