API issue field value retrieval

[Mitch Wayte]

We have a ton of different projects, not all of which have data that requires retrieval.  I have figured out a way to decipher which projects to get the data out of, but now I am having a difficult time getting it.  We have projects that have a custom status called Main.  Inside this status we are trying to keep track of things with fields like Controller Model, Front End, Est Sales Time etc.  The only way I have found to navigate it is to get all the issues in a project, lookup each issue, and check if it has a status of Main.  If someone has a way to specify a project and issue with a status of Main to grab the relevant data that would be optimal.  However, even just grabbing all the issues with a status of Main would work as well.

[Tomislav Tobijas]

Hi @Mitch Wayte ,

As you're using API, you could use it to return items based on a JQL search query > see Run JQL search query using Jira Cloud REST API 

In short, write a JQL in Jira and search for work items. Then, copy the part of the URL and add that to your API call, like:

curl --request GET \
  --url 'https://<yoursitename>.atlassian.net/rest/api/3/search/jql?maxResults=10000&jql%3Dproject%3DOP%20and%20created%20%3E%3D%20-7d' \
  --user 'youremail@mail.com:yourapitoken' \
  --header 'Accept: application/json'

You can use any custom field; pretty much anything that JQL supports.

Hope this helps.

Cheers,
Tobi