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; } } }

Bulk API endpoint for Star Ratings

Jetson Gospel

We are looking to make a query to import ratings on tickets from a date range for reporting purposes. The current API seems limited to passing each ticket ID and requesting for the rating on that ticket, increasing the number of calls that need to be made to fetch this info.

Is there a way to query by a date range and GET ticket ids and associated star ratings provided by customers.

Accepted answers

All comments

Trudy P Claspill

Have you tried using the issue search api with a jql statement? Simple example:

http://localhost:8080/rest/api/2/search?jql=assignee=charlie

I didn't check if star ratings are returned in the results.

Jetson Gospel

Hi, nope will check it out

Jetson Gospel

@Trudy P Claspill Tried that and did not have the star rating in there.

unknown

Hello @Jetson Gospel

There is nothing called a 'Star Rating' in the native version of Jira Software Cloud. You also mentioned searching for a 'ticket ID' but Jira Software Cloud doesn't have 'tickets' either. Perhaps you're referring to OpsGenie?

If not, perhaps you've got some sort of third party add-in like Rating CustomField that has added a custom star rating system to the issues in your Jira Software Cloud instance?

Jetson Gospel

Hi @[deleted]Its a field the customer uses in their service cloud for tracking CSAT. The only way to get this out now is by passing a single ID at a time: https://developer.atlassian.com/cloud/jira/service-desk/rest/api-group-request/#api-rest-servicedeskapi-request-requestidorkey-feedback-get

Looking to see if I query by a date range and process it from there. Seems pretty inefficient to make multiple calls. Ty

unknown

OK, you're talking about Jira Service Desk and when you say 'ticket' you mean customer requests.

The Get customer requests endpoint does allow you to search for all the requests, and you can use a JQL search to narrow the results to a date range, but in the results returned, the value of the FEEDBACK isn't included, as per the documentation:

expand

Array<string>

A multi-value parameter indicating which properties of the customer request to expand, where:

serviceDesk returns additional details for each service desk.
requestType returns additional details for each request type.
participant returns the participant details, if any, for each customer request.
sla returns the SLA information on each customer request.
status returns the status transitions, in chronological order, for each customer request.
attachment returns the attachments for the customer request.
action returns the actions that the user can or cannot perform on this customer request.
comment returns the comments, if any, for each customer request.
comment.attachment returns the attachment details, if any, for each comment.
comment.renderedBody (Experimental) returns the rendered body in HTML format (in addition to the raw body) for each comment.

To get the value of the feedback, including the feedback RATING field value (an integer from 0 to 5), you need to query the Get feedback endpoint and that endpoint needs to be used per customer request, one at a time.

In summary, there is no endpoint that allows you to query all the customer requests by date range and also have the value of the feedback rating for all returned at the same time.

Jetson Gospel

Thank you. Yeah, seems pretty inefficient and hopefully, they address this.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

rest-api

api

jira-cloud

atl-orange