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

Trying to send a scriptrunner jql over JIRA's REST API

Adrian Popescu_xg60iz

Hello,

I'm trying to send a more complex JQL over rest api currently testing in postman and I cannot seem to get the end of it with formatting to keep the escape characters of the jql in place properly. Whenever I manage to fix the jquery to be valid, I get a jql error and the other way around as well.

Any chance anyone could help with this or did anyone find a way around stuff like this?

Thank you!

JSON (The point where I got it to and I don't know anymore thinsg to try with it):
{
"jql": "project = \"PROJECT\" AND issuefunction in parentsOf(\"issueFunction in subtasksOf(\\\"issuefunction in parentsOf('type in subTaskIssueTypes() and status != Resolved and component = ABC') and status = 'Status' and type = 'Issue Type'\\\")\") ORDER BY \"Start date\" DESC\"",
"startAt": 0,
"maxResults": 1,
"fields": [
"issuekey"
]
}

The exact jql that functions in jira and needs to be sent on the api:

project = "PROJECT" AND issuefunction in parentsOf("issueFunction in subtasksOf(\"issuefunction in parentsOf('type in subTaskIssueTypes() and status != Resolved and component = ABC') and status = 'Status' and type = 'Issue Type'\")") ORDER BY "Start date" DESC

Accepted answers

jira guy_ymfmzd

Hey

I am not sure how you are sending this JQL. It's always easier to form the rest api url after executing the JQL.

My url after executing in JIRA:

https://myinstance.com/issues/?jql=project%20%3D%20META

My rest api URL would be:

https://myinstance.com/rest/api/2/search?jql=project%20%3D%20META

Let me know if this helped

All comments

jira guy_ymfmzd

Hey

I am not sure how you are sending this JQL. It's always easier to form the rest api url after executing the JQL.

My url after executing in JIRA:

https://myinstance.com/issues/?jql=project%20%3D%20META

My rest api URL would be:

https://myinstance.com/rest/api/2/search?jql=project%20%3D%20META

Let me know if this helped

Adrian Popescu_xg60iz

Hey @jira guy ,

I'm trying to send that json with post to - https://jira.vidaxl.com/rest/api/2/search

What you're saying does help, but I'm trying to fetch only 1 result per call, only with the "issuekey".

If I'm making a GET request on the rest api url after executing the jql string, I get default max results 50.

Any idea on that one?

Also, thanks a lot, it did help me move forward one step at least.

jira guy_ymfmzd

Use pagination. You can limit the results and loop through using startAt param. You can also end the search by comparing the total.

https://myinstance.com/rest/api/2/search?jql=project%20%3D%20META&maxResults=10&startAt=2

Check out the rest api documentation for more info

https://docs.atlassian.com/software/jira/docs/api/REST/8.2.4/

Adrian Popescu_xg60iz

No idea why I didn't take into consideration including everything in the url, since I did look into the API documentation from the start. Thanks a lot for the help!

I also added "&fields=issuekey" and it returned exactly what I was struggling to achieve through POST. Better open my eyes more next time.

Welcome!

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

Quick Links

Find more posts tagged with

server

scriptrunner

jira

rest-api

jira-server

jql