Creation of JIRA tickets using Rest API

Casey Maynard

I am hoping there is a way to use some add-on or feature with JIRA/Confluence that will allow my team to create a set of JIRA tickets with multiple fields, via a CSV (or some table that is created in Confluence).  Current these are the fields that I need to have JIRA cards created 

Project

Type

Summary

Description

Assignee

Timecode (custom field)

I have projects, and Epics already created. but I need to create about 50 User Stories and this takes awhile manually.

Someone suggested Rest API, but I cannot find a tutorial that is specifically related to only the JIRA card creation from a source file (.csv) file or some other 'table'.

Thanks

Arun_Thundyill_Saseendran

If you want to create issues from CSV without using the Jira Importer Plugin then your approach is right. You have to go with ReST API provided by JIRA.

 

You can use a simple Python script or a simple app in JAVA that reads the CSV, iterates over each row - form the issue create JSON and just POST it. You can improvise as and how it is required to suit your needs.

Pseudocode will be as follows. I do not have my code base handy. So this is that I have now.

    

// Create Issue and make a post request
private void createIssueFromFile(String fileName) 
{
 issuesRestApiURL = ""; // You instance base URI

CsvReader reader = null;
 reader = new CsvReader(new BufferedReader(new FileReader(RESOURCES_PATH + fileName)));
 // read file using CSV Reader - OpenCSV is my choice
 String[] line = null; 
 while ((line = reader.readLine()) != null) 
 {
 // create Issue object (issueWrapper)
 .....
 ..... 
 // create headers should set the headers right - You can use simple Basic Auth
 HttpEntity<CreateIssueWrapper> request = new HttpEntity<CreateIssueWrapper>(issueWrapper, createHeaders());
 // REST request
 restTemplate.postForObject(issuesRestApiURL, request, IssueWrapper.class);
 }
 // close reader
 reader.close(); 
}