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

Has the Rest API changed for JIRA? I'm unable to query a project by status

Chris Voisey_p5d4ab

Until recently, the following command would work:
curl -D- -u "email:password" -X GET -H "Content-Type: application/json" https://mydomain.atlassian.net/rest/api/2/search?jql=project%20%3D%20TTI%20AND%20status%20in%20('In Progress','Build Broken','Unscheduled','Ready for Development', 'In Review', 'Requirements Definition')%20ORDER%20BY%20priority%20DESC

Now when I run this, I am getting:
syntax error near unexpected token `('

So what has changed? The problem is obviously with the parenthesis, but this used to work. I've even tried changing it to a %28, but that makes things worse.

Accepted answers

All comments

Andy Heinzer

I'm not sure what would have changed recently. So I walked through this same set of commands in my Cloud instance and using your syntax I was able to reproduce this same problem. I then went back to a few of the examples from our developer REST API Tutorials.

In looking at these I noticed that your URL string was note in single quotes like the examples in that tutorial were.

So I think you can change your curl request to look like this:

curl -D- -u "email:password" -X GET -H "Content-Type: application/json" 'https://mydomain.atlassian.net/rest/api/2/search?jql=project%20%3D%20TTI%20AND%20status%20in%20('In Progress','Build Broken','Unscheduled','Ready for Development', 'In Review', 'Requirements Definition')%20ORDER%20BY%20priority%20DESC'

When I did this, I was able to get back search results in my test, even when the URL had () or not.

Cheers,
Andy

Chris Voisey_p5d4ab

I think we are close, however when you run this full query, with the single quotes within the single quotes, it tries to run each of those single quote items too. i.e., after the first result, you get:

curl: (6) Could not resolve host: Progress,Build

curl: (6) Could not resolve host: Broken,Unscheduled,Ready

... and so on.

I'm very curious to what changed though. This worked great, untouched for a month or so now. All the sudden I get these errors.

Andy Heinzer

Hi Chris,

Sorry about that, I didn't think about the single quotes in the JQL itself. For that reason, it's probably better to use the double quotes to encapsulate the entire URL like this:

curl -D- -u "email:password" -X GET -H "Content-Type: application/json" "https://mydomain.atlassian.net/rest/api/2/search?jql=project%20%3D%20TTI%20AND%20status%20in%20('In Progress','Build Broken','Unscheduled','Ready for Development', 'In Review', 'Requirements Definition')%20ORDER%20BY%20priority%20DESC"

Try this,
Andy

Chris Voisey_p5d4ab

Thanks for the continued persistence through this one!! I wish it was that simple. I already (and again right now) tried that and it still doesn't work.

I get a 400 error.

To simplify this even further ... just to remove any noise, I used this smaller version with the same error:
curl -D- -u "email:password" -X GET -H "Content-Type: application/json" "https://mydomain.atlassian.net/rest/api/2/search?jql=project%20%3D%20TTI%20AND%20status%20in%20('In Progress')"

(Don't worry, I'm also putting in my correct domain and password info) Actually, if I remove the "AND status in ('In Progress')" the query will work. LIkewise, I also tried this with real spaces, removing the special character codes. Still the same thing. After all, it is just a string at this point.

Two weeks ago all of this worked. It is so odd.

Welcome!

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

Quick Links

Find more posts tagged with

jira

rest-api