Increase API call limits above default settings

Note : This article only applies to QMetry On-Premise installations. For SaaS/Cloud customers these settings are not customizable. 

QMetry Application has the below pre-defined API call limits to ensure optimum performance. However, depending upon the preferred usage of your automation teams and your server hardware capability, these limits may be modified.

Pre-defined API Call limits

API'sMaximum API CallsDetails

Automation API

500 Per Day

  • Maximum API call limitation gets set for the entire QMetry Instance including all users.
  • The counter would reset as per UTC timezone.

All Open API's

1000 Per Hour

All Open API's

10000 Per Day

Increasing API call limits

Caution! Increasing API call limits can lead to slowness or performance issues if the server hardware is not capable. For QMetry recommended server configurations (Large Teams) the API limits should not be set beyond 5000 hits per hour and 50000 hits per day.

Follow the below step to modify the default limits :

  1. Execute the command : docker ps to view existing dockers running on the server.
    • To go the QMetry MySQL Docker execute the command : docker exec -it <docker_name> bash, example : docker exec -it qmetry_rds_1 bash
  2. Login to QMetry DB, by replacing the username, password in the below commands
    • mysql -u[username] -p[password] qmetry -A
  3. To view the currently set API limits, execute the below query
    • SELECT name, value FROM productconfig WHERE name IN ('automationHourlyAPIRequestCount','dailyAPIRequestCount','hourlyAPIRequestCount');
  4. Turn off SQL safe updates and execute the below queries by replacing the values for the limits to be set. 
    • SET SQL_SAFE_UPDATES = 0;
    • UPDATE productconfig SET value = <set value here> WHERE name ='automationHourlyAPIRequestCount' ;
    • UPDATE productconfig SET value = <set value here> WHERE name ='dailyAPIRequestCount' ;
    • UPDATE productconfig SET value = <set value here> WHERE name ='hourlyAPIRequestCount' ;
    • To check the updated values run the query in Step 3 again.
    • exit; 
  5. Restart QMetry Tomcat Services
    • Check the running containers using the following command:
      • docker ps
    • Restart both docker containers using below commands:
      • docker stop qmetry_app_1 qmetry_rds_1
      • docker start qmetry_rds_1
      • docker start qmetry_app_1

In case you have any questions about these steps, send an email to qtmprofessional@qmetrysupport.atlassian.net