We are performing a phasewise scheduled maintenance of our Zephyr for Jira Cloud and Capture for Jira Cloud customer instances to be compliant with GDPR- Atlassian privacy policy (https://www.atlassian.com/trust/privacy) .Please expect a downtime during this phase of maintenance between 14th December , 9:00 pm PST to 15th December 5:00 am PST.For any further queries regarding this please rasie a ticket by using the option 'Submit a Ticket' below
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