Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

how to execute ZQL Query through api ?

I want o execute below zql :- project = "XYZ" AND fixVersion in ("a1","a2") AND cycleName = "Regression" .

Any suggection how to execute this query in jmeter or postman.

I am using JIRA cloud.. my jira url is like - https://<companyName>.atlassian.net .

3 answers

Hello @pksah,

You can use free add-on available in marketplace named with ZAPI to access ZFJ data programmatically.
refer below documentation link to setup & use ZAPI to access API's.

Let us know if you face any issues.

Thanks.

Thanks mate for replying me back. 

so far I have understood that 

For (JIRA) - I have to use jira api token.

For zephyr- I have to use JWT and zapiAccesskey.

My question is If I ´want to execute a zql query from postman/jmeter... what will be the uri

https://<companyName>.atlassian.net/rest/zapi/latest/zql/executeSearch?zqlQuery=project="XYZ"+AND fixVersion+in+("a1","a2")+AND+cycleName="Regression"

or

https://prod-api.zephyr4jiracloud.com/connect/public/rest/api/1.0/zql/executeSearch?zqlQuery=project="XYZ"+AND fixVersion+in+("a1","a2")+AND+cycleName="Regression"

Hi @pksah you have to use below endpoint for all the api call's 

https://prod-api.zephyr4jiracloud.com/connect/

you can refer the apiary documentation, where you will get sample request and response

https://zfjcloud.docs.apiary.io/#

Jinansh I'm New Here Mar 28, 2021

@jagadeesh madhura 

Can you help me out with the canonical query string for 

https://prod-api.zephyr4jiracloud.com/connect/public/rest/api/1.0/zql/filters/quicksearch?query=project="TTP"

I am trying to understand it from https://developer.atlassian.com/cloud/bitbucket/query-string-hash/ but I am not able to make it work for the above query

I am getting the following error while executing the above API:
Expecting claim 'qsh' to have value A but instead it has the value B

Thank you for your help

@Jinansh  You will get this qsh error when there is issue with JWT generation. You can use the sample project in GIT hub for generating the JWT and try again.

https://github.com/zephyrdeveloper/zapi-cloud/tree/master/Samples/src/com/thed/zapi/cloud/sample

For more details please follow :

https://support.smartbear.com/zephyr-for-jira-cloud/docs/api/jwt-token.html

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Bitbucket Smart Commits vs. Genius Commits - What's the difference?

If you already heard about Smart Commits in Bitbucket, know that you just stumbled upon something even better (and smarter!): Genius Commits by Better DevOps Automation for Jira Data Center (+ Server...

106 views 0 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you