nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Scriptrunner rest end point - create issue

kumar sam

I would like to create a rest end point in scriptrunner. This should accept projectname, username and description as input parameters ( may be more later) and create jira issue.

Started to write along the following lines:

import com.atlassian.jira.bc.issue.IssueService;
import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.issue.IssueInputParameters;
import com.onresolve.scriptrunner.runner.rest.common.CustomEndpointDelegate
import groovy.json.JsonBuilder
import groovy.transform.BaseScript

import javax.ws.rs.core.MultivaluedMap
import javax.ws.rs.core.Response

@BaseScript CustomEndpointDelegate delegate

doSomething(httpMethod: "GET", groups: ["jira-administrators"]) { MultivaluedMap queryParams, String body ->

 ComponentAccessor.userManager.getUserByName("admin");
 IssueService issueService = ComponentAccessor.getIssueService();


 IssueInputParameters issueInputParameters = issueService.newIssueInputParameters();

 issueInputParameters.setSummary("This is a summary");



 return Response.ok(new JsonBuilder([abc: 42]).toString()).build();
}

While I am trying to figure this out, do anyone have sample code to create issue from paramters & A sample test input ...

Thanks

Accepted answers

Alexey Matveev

Hello,

You would read parameters with the following line

String projectName = queryParams.getFirst("projectname").toString()

And so on for all of your parameters.

You can find an example how to create an issue here

https://community.atlassian.com/t5/Jira-questions/Error-creating-JIRA-tickets-via-groovy-script-set-up-as-a/qaq-p/5113

All comments

Alexey Matveev

Hello,

You would read parameters with the following line

String projectName = queryParams.getFirst("projectname").toString()

And so on for all of your parameters.

You can find an example how to create an issue here

https://community.atlassian.com/t5/Jira-questions/Error-creating-JIRA-tickets-via-groovy-script-set-up-as-a/qaq-p/5113

Alexey Matveev

If you need a specific example, kindly ask

kumar sam

Thanks Alexey Matveev

I have looked at the link when I googled and took few lines from there..

I am specifically looking for one sample script which can show me how to create issue from input parameters

and

How the script is called

That way I can use that sample to create rest of my scripts.

I need to write few scripts like this, first I started down known path of creating rest plugin, but when I was reading up chanced upon scriptrunner capability and thought it is much easier this way.

Alexey Matveev

Ок. A more detailed example on how to create issue with inputparameters you can find here

https://community.atlassian.com/t5/Jira-questions/How-to-create-issues-in-jira-programmatically-inside-a-listener/qaq-p/352020

Just put it inside your rest endpoint script template. Add to your script a part where you read passed parameters as I explained in my first reply. Then you can call the script by making a call like this

Http(s)://yourjira/rest/scriptrunner/latest/custom/doSomething?projectname=test&username=testuser&descriltion=testdescriptiin

kumar sam

Issue createdErrors: {}
Error Messages: [We can't create this issue for you right now, it could be due to unsupported content you've entered into one or more of the issue fields. If this situation persists, contact your administrator as they'll be able to access more specific information in the log file.]

For the call:

http://localhost:8080/rest/scriptrunner/latest/custom/restCreateIssue?projectname=MPJ&issuetype=bug&reporterid=admin&summary=mysteingdescr&description=mydescription1

In the log file I see this:

Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ID FROM PUBLIC.rundetails WHERE JOB_ID=? (General error: "java.lang.IllegalStateException: File corrupted in chunk 226790, expected page length =< 512, got 811808614 [1.4.185/6]"; SQL statement:
SELECT DISTINCT ID FROM PUBLIC.rundetails WHERE JOB_ID=? [50000-185])
 at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:533)
 at org.ofbiz.core.entity.GenericDAO.createEntityListIterator(GenericDAO.java:877)
 at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:857)
 at org.ofbiz.core.entity.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:216)
 at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:399)
 ... 17 more
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: File corrupted in chunk 226790, expected page length =< 512, got 811808614 [1.4.185/6]"; SQL statement:
SELECT DISTINCT ID FROM PUBLIC.rundetails WHERE JOB_ID=? [50000-185]
 at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
 at org.h2.message.DbException.get(DbException.java:168)
 at org.h2.message.DbException.convert(DbException.java:295)
 at org.h2.command.Command.executeQuery(Command.java:209)
 at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
 at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
 at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:527)
 ... 22 more
Caused by: java.lang.IllegalStateException: File corrupted in chunk 226790, expected page length =< 512, got 811808614 [1.4.185/6]
 at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:773)
 at org.h2.mvstore.Page.read(Page.java:640)
 at org.h2.mvstore.Page.read(Page.java:194)
 at org.h2.mvstore.MVStore.readPage(MVStore.java:1830)
 at org.h2.mvstore.MVMap.readPage(MVMap.java:736)
 at org.h2.mvstore.Cursor.fetchNext(Cursor.java:150)
 at org.h2.mvstore.Cursor.next(Cursor.java:50)
 at org.h2.mvstore.db.TransactionStore$TransactionMap$1.fetchNext(TransactionStore.java:1396)
 at org.h2.mvstore.db.TransactionStore$TransactionMap$1.next(TransactionStore.java:1435)
 at org.h2.mvstore.db.MVSecondaryIndex$MVStoreCursor.next(MVSecondaryIndex.java:508)
 at org.h2.index.IndexCursor.next(IndexCursor.java:277)
 at org.h2.table.TableFilter.next(TableFilter.java:360)
 at org.h2.command.dml.Select.queryFlat(Select.java:532)
 at org.h2.command.dml.Select.queryWithoutCache(Select.java:644)
 at org.h2.command.dml.Query.query(Query.java:322)
 at org.h2.command.dml.Query.query(Query.java:290)
 at org.h2.command.dml.Query.query(Query.java:36)
 at org.h2.command.CommandContainer.query(CommandContainer.java:90)
 at org.h2.command.Command.executeQuery(Command.java:197)
 ... 26 more

kumar sam

For url:

http://localhost:8080/rest/scriptrunner/latest/custom/restCreateIssue?projectname=MPJ&issuetype=bug&reporterid=admin&summary=mysteingdescr&description=mydescription1

createResult.getIssue() is null Errors: {}
Error Messages: []

No error messages in collection.

Alexey Matveev

I just tried your code. I return value from Json like this

return Response.ok("Issue created is" +createResult.getIssue().getId().toString(), "application/json" ).build();

It works for me. I can see the Id of the created issue. What is your Jira version?

kumar sam

7.4.0 is my jira version

kumar sam

ok my bad typo in the line in debug statement. Now it works fine.

I will now go on to JSON

Andy Heinzer

Hi Kumar,

The error you posted of:

Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: File corrupted in chunk 226790, expected page length =< 512, got 811808614 [1.4.185/6]"; SQL statement:

This specific error message is an indication that the H2SQL database is corrupted. I would recommend reviewing our Jira Supported platforms documentation and then selecting a supported database for Jira and using that instead. The H2 database is known to easily be corrupted and is never recommended for a production environments. It is the easiest to setup and that is why it is commonly used for evaluations, but in this case, I would recommend avoiding that database type to move past this specific error.

Regards,
Andy

kumar sam

For anyone else who come across this post here is the full script (Coutesy: Alexey)

import com.atlassian.jira.bc.issue.IssueService
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.IssueInputParameters
import com.atlassian.jira.issue.index.IssueIndexManager
import com.atlassian.jira.user.ApplicationUser
import com.atlassian.jira.user.util.UserManager
import com.atlassian.jira.util.ErrorCollection

import com.atlassian.jira.issue.IssueInputParameters;
import com.atlassian.jira.project.Project;
import com.atlassian.jira.issue.issuetype.IssueType;

import org.apache.log4j.Category;
import com.atlassian.jira.issue.index.IssueIndexingService;

import com.atlassian.jira.issue.IssueInputParameters;
import com.onresolve.scriptrunner.runner.rest.common.CustomEndpointDelegate
import groovy.json.JsonBuilder
import groovy.transform.BaseScript

import javax.ws.rs.core.MultivaluedMap
import javax.ws.rs.core.Response

/* Reading from JSON */
import com.atlassian.jira.issue.fields.rest.json.beans.PriorityJsonBean;
import org.codehaus.jackson.map.ObjectMapper;
import groovy.json.JsonSlurper;

@BaseScript CustomEndpointDelegate delegate

restCreateIssue1(httpMethod: "POST") { MultivaluedMap queryParams, String body ->

//return Response.ok("beautiful", "application/json").build();

/* Define a Logger */
def Category log = Category.getInstance("com.samsung.issueCreate")
log.setLevel(org.apache.log4j.Level.DEBUG)

/* Read input parameters from get request */

/*
String projectName = queryParams.getFirst("projectname").toString();
String issueTypeName = queryParams.getFirst("issuetype").toString();
String reporterId = queryParams.getFirst("reporterid").toString();
String issueSummary = queryParams.getFirst("summary").toString();
String issueDescription = queryParams.getFirst("description").toString();
*/

// Reading input from POST with JSON payload 

def jsonSlurper = new JsonSlurper()
def object = jsonSlurper.parseText(body)
def String projectName = ((Map) object).projectname
def String issueTypeName = ((Map) object).issuetype
def String reporterId = ((Map) object).reporterid
def String issueSummary = ((Map) object).summary
def String issueDescription = ((Map) object).description

//return Response.status(Response.Status.NOT_FOUND).entity("projectName from JSON: " + projectName).build();


/* Get correspoding objcts */
Project project = ComponentAccessor.getProjectManager().getProjectObjByKey(projectName)
//def myIssueType = ComponentAccessor.issueTypeSchemeManager.getIssueTypesForProject(project).find{it.name=="Task"}
def myIssueType = ComponentAccessor.issueTypeSchemeManager.getIssueTypesForProject(project).find{it.name== issueTypeName}


 if(project == null)
 return Response.status(Response.Status.NOT_FOUND).entity("Project Id not found for: " + issueTypeName).build();

 if(myIssueType == null)
 return Response.status(Response.Status.NOT_FOUND).entity("IssueType Id not found for: " + issueTypeName).build();



IssueService issueService = ComponentAccessor.getIssueService();
IssueInputParameters inputParameters = issueService.newIssueInputParameters();

UserManager userManager = ComponentAccessor.getUserManager();
def issueManager = ComponentAccessor.getIssueManager();

inputParameters
 .setProjectId(project.getId())
 .setIssueTypeId(myIssueType.getId())
 .setReporterId(reporterId)
 .setSummary(issueSummary) 
 .setDescription(issueDescription);


// No logged in user for groovy script
ApplicationUser curUser = userManager.getUserByKey(reporterId);

//return Response.status(Response.Status.NOT_FOUND).entity("User r: " + curUser).build();

IssueService.CreateValidationResult createValidationResult = issueService.validateCreate(curUser, inputParameters)

def issueIndexingService = ComponentAccessor.getComponent(IssueIndexingService);

if(!createValidationResult.isValid()){
 ErrorCollection errorCollection = createValidationResult.getErrorCollection();
 return Response.status(Response.Status.NOT_FOUND).entity("Entity not found for UUID: " + errorCollection.toString()).build();
 // return errorCollection.toString()
}
else{

 IssueService.IssueResult createResult = issueService.create(curUser, createValidationResult);
 if(createResult.getIssue() == null)
 return Response.status(Response.Status.NOT_FOUND).entity("createResult.getIssue() is nullx "+createResult.getErrorCollection()).build();
 return Response.ok("Issue created"+createResult.getIssue().getKey().toString(), "application/json").build();
 // log.debug ("Issue created is:"+createResult.getIssue());
 issueIndexingService.reIndex(issueManager.getIssueObject(createResult.getIssue().getId()));
 String json = "Issue created is:"+createResult.getIssue();
 return Response.ok(json, "application/json").build();
}


}