We need scriptrunner script to retrieve "Time to first response"
1 answer
Hi @[deleted]
For your requirement, you will need to use the REST Endpoint to invoke the SLA from the Service Desk's REST Service and need to filter the result with something like:-
import com.atlassian.jira.component.ComponentAccessor
import com.onresolve.scriptrunner.runner.rest.common.CustomEndpointDelegate
import groovy.json.JsonBuilder
import groovy.transform.BaseScript
import groovyx.net.http.HttpResponseDecorator
import groovyx.net.http.RESTClient
import javax.servlet.http.HttpServletRequest
import javax.ws.rs.core.MultivaluedMap
import javax.ws.rs.core.Response
@BaseScript CustomEndpointDelegate delegate
getTimeToFirstResponse { MultivaluedMap queryParams, body, HttpServletRequest request ->
def issueKey = queryParams.getFirst('issueKey')
def applicationProperties = ComponentAccessor.applicationProperties
final def baseUrl = applicationProperties.getString('jira.baseurl')
final def username = 'admin'
final def password = 'q'
final def headers = ['Authorization': "Basic ${"${username}:${password}".bytes.encodeBase64()}",
'X-ExperimentalApi': 'opt-in', 'Accept': 'application/json'] as Map
def http = new RESTClient(baseUrl)
http.setHeaders(headers)
def resp = http.get(path: "/rest/servicedeskapi/request/${issueKey}/sla") as HttpResponseDecorator
if (resp.status != 200) {
log.warn 'Commander did not respond with 200 for retrieving project list'
}
def issueJson = resp.data as Map
def totalValues = issueJson['values'] as List<Map>
def result = totalValues.findAll {it['name'] == 'Time to first response'}
def time = result['ongoingCycle']['startTime']['jira']
Response.ok(new JsonBuilder(time).toPrettyString()).build()
}
Please note that the sample code provided is not 100% exact to your environment. Hence, you will need to make the required modifications.
Below is a screenshot filtered result that is returned:-
Below is a screenshot of the REST Endpoint configuration:-
Once you have obtained the result, you can pass the value to a Behaviour or Listener or whatever you want to use to invoke it.
I hope this helps to solve your question. :-)
Thank you and Kind regards,
Ram
Hi @[deleted]
It appears you have commented out the lines below:-
@BaseScript CustomEndpointDelegate delegate
getTimeToFirstResponse { MultivaluedMap queryParams, body, HttpServletRequest request -
You need these lines for the REST Endpoint to work correctly.
Also, you seem to be missing the last line, i.e.:-
Response.ok(new JsonBuilder(time).toPrettyString()).build()
If the last line is not included, you won't be able to get the correct value that you want. Instead, you will get the entire JSON Response.
Please correct your code and ensure it is added to the REST Endpoint. The code should be:-
import com.atlassian.jira.component.ComponentAccessor
import com.onresolve.scriptrunner.runner.rest.common.CustomEndpointDelegate
import groovy.json.JsonBuilder
import groovy.transform.BaseScript
import groovyx.net.http.HttpResponseDecorator
import groovyx.net.http.RESTClient
import javax.servlet.http.HttpServletRequest
import javax.ws.rs.core.MultivaluedMap
import javax.ws.rs.core.Response
@BaseScript CustomEndpointDelegate delegate
getTimeToFirstResponse { MultivaluedMap queryParams, body, HttpServletRequest request ->
def issueKey = queryParams.getFirst('issueKey')
def applicationProperties = ComponentAccessor.applicationProperties
final def baseUrl = applicationProperties.getString('jira.baseurl')
final def username = 'tiwarab'
final def password = 'q'
final def headers = ['Authorization': "Bearer MDI5NjAxODc5ODE5Olvt0d7GCC2o790uYGHZ3AuHp4eo",
'X-ExperimentalApi': 'opt-in', 'Accept': 'application/json'] as Map
def http = new RESTClient(baseUrl)
http.setHeaders(headers)
def resp = http.get(path: "/rest/servicedeskapi/request/${issueKey}/sla") as HttpResponseDecorator
if (resp.status != 200) {
log.warn 'Commander did not respond with 200 for retrieving project list'
}
def issueJson = resp.data as Map
def totalValues = issueJson['values'] as List<Map>
def result = totalValues.findAll {it['name'] == 'Time to first response'}
def time = result['ongoingCycle']['startTime']['jira']
Response.ok(new JsonBuilder(time).toPrettyString()).build()
}
For this code to work, you need to configure the REST Endpoint and not just invoke it from the console.
Once you have configured the REST Endpoint, you can now invoke the REST Endpoint from the ScriptRunner console doing something like:-
import com.atlassian.jira.component.ComponentAccessor
import groovy.json.JsonSlurper
def applicationProperties = ComponentAccessor.applicationProperties
final def host = applicationProperties.getString('jira.baseurl')
def issueKey = 'ST-1'
def baseUrl = "${host}/rest/scriptrunner/latest/custom/getTimeToFirstResponse?issueKey=${issueKey}" as String
def output = new URL(baseUrl).text
def json = new JsonSlurper().parseText(output) as List
log.warn "=====>>> ${json.first()}"
This should return your date value. Using the code above in the Console should return something like:-
Thank you and Kind regards,
Ram
Hi @[deleted]
In your last comment, you asked:-
1) For "Time to first response" we are getting a date "2022-02-09T08:44:36.389+0000" from rest api but in jira UI it shows -8mon. Why is there a difference?(Issue-SPSDT-68)
Basically, Jira is doing a calculation between the number of days or months from the Time to First Response and the current system date. In other words, something like:-
def dateFrom = Date.parse("yyyy-MM-dd'T'HH:mm:ss.SSSZ", "2022-02-09T08:44:36.389+0000")
def dateTo = new Date(System.currentTimeMillis())
def diffMonths = { Date start, Date end ->
int diffYears = (start[Calendar.YEAR] - end[Calendar.YEAR]) * 12
int diffMonths = start[Calendar.MONTH] - end[Calendar.MONTH]
return diffYears + diffMonths
}
log.warn diffMonths(dateFrom, dateTo)
So the output will display the total number of months, i.e.
You also asked:-
2) There is one more Jira for which it shows -1mon in jira UI. But the rest api is giving no date because it has no ongoingCycle how to handle this case.Rest endpoint payload for this issue i have posted in my previous comments, please refer?(Issue-SPSDT-69)
That doesn't make sense. Even if the issue's SLA is paused, the ongoing cycle will remain.
And for your third question, i.e.:-
3) Also, is there noway we can get "Time to first response" from customfield value object rather than calling rest apis?
Basically, once you have obtained the value from the REST Endpoint, you can use the console, for example, to update a Text Field with that value.
I hope this helps to answer your questions. :-)
Thank you and Kind regards,
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.