Is there a rest api to import a csv file of issues into jira?

[Lonn James Holiday]

Greetings,

All I want to do is import issues with a csv file.

I have looked into this for a while now and not found a solution.

Bob Swift's command line tools can do it but we are not allowed to install the server side and we do not have hands on access to the server.

I am looking at Postman as a solution. A great curl command would be awesome.

But does jira have an api to import a csv?

Thanks,

Lonn

[Ravi Sagar _Sparxsys_]

Hi @Lonn James Holiday 

I don't think it is possible. CSV importer in Jira is already quite configurable with all the mappings and making sure the format is correct. It will be hard I guess to do all that with REST API.

May be parsing the CSV first in the language of your choice and then feeding it to Jira? but again how many issues are you trying to import - few hundred, thousand or millions?

Ravi

[Lonn James Holiday]

Hi Ravi,

We expect to update a few hundred issues on a regular basis. I see there is not remote method for csv so I am now looking into exporting and importing json files.

Now I must ask the community another question.

"Why does jira with the json importer not import the very same file it exported?"

Thank you,

Lonn

[Santwana Sarangi {Appfire}]

Hi @Lonn James Holiday ,

There is no rest api for importing issues with a CSV file. If you are not able to use any third party apps, then I think it will be best to create your own plugin to import the issues from a CSV file using jira rest api or using java api.

You can take a look at this for your reference

https://community.atlassian.com/t5/Answers-Developer-Questions/Create-issue-via-REST-API-useing-Java/qaq-p/518478

Hope this helps.

Regards,

Santwana

[Lonn James Holiday]

Thank you, Santwana.

I have seen that article. I want to handle multiple issues on a regular basis. I may be able to do what I need to do using json file.

However I see jira will not import the very same json file it exports. Even if it is unchanged. This has me baffled so I am going to ask the community another question.

Lonn