Update for our Zephyr for Jira Server/DataCenter customers : Our team is working on a major version release of Zephyr for Jira to be compatible with Jira 8 .The tentative ETA for the release of this compatible version is by end of March 2019.Please watch this space and anticipate further notifications from the Zephyr team on the updates with regards to the release of the same.Till then we suggest you to use lower version of Jira for seamless operations of Zephyr plugin.For any further feedback , follow up queries or suggestions kindly 'Submit a Ticket' with us.
Support | Zephyr

How to increase the number records fetched by Zephyr Enterprise/Community APIs

Created on

Zephyr Enterprise/Community allows a maximum of 500 records to be fetched by the APIs. Please follow the below mentioned instructions to increase this limit.

Log in to MySQL instance that Zephyr connects to.

Windows instructions:

Please use the MySQL binaries chip with Zephyr. The MySQL binaries can be found in "Zephyr_Installation_Location/mysql/bin". In my machine the location is "C:\Program Files\Zephyr\mysql\bin" and this may be different in your machine. 

Open a command prompt and navigate to the above mentioned location and issue the following command. Please note, since Zephyr on Windows OS uses the port number 37638 we need to use this port number as well when connecting to Zephyr's database.

 mysql -uroot -proot --port=37638 itcc

Linux instructions:

Since Zephyr does not bundle with built in MySQL instance for Linux, Please use the required credentials to connect to the MySQL instance used by Zephyr.

Once logged in, Please execute the following queries.

UPDATE `itcc`.`preference` SET `value` = '40000' WHERE `name` = 'api.records.maxallowed';




Now, the API limit has been changed to 40000.



Title: Zephyr Enterprise, Community APIs maximum fetched records.

Product: Zephyr Enterprise, Community.

Version: 4.5.X+

Summary: Increasing the number records fetched by Zephyr Enterprise/Community APIs.


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk