Issue with API Query Limitation for Retrieving Vulnerabilities in PowerBI

[apiknowbler]

Summary

Problem Statement:

An issue has arisen regarding the API query used to obtain vulnerabilities. The current limitation allows for only 100 records to be retrieved at a time, while there are approximately 9000 vulnerabilities available. This raises questions about the duration of this limitation and the possibility of retrieving the first 100 records in one query, followed by additional records after a specified interval. The user is experiencing a 'too many queries' error when attempting to execute the query from Power BI.

Resolution:

The limit for requesting vulnerabilities is strictly set to ensure adequate performance. This means that multiple requests are required to obtain all the data. To retrieve all vulnerability information, 90 requests, each returning 100 vulnerabilities, are necessary.

The Lansweeper API supports a maximum of 150 requests per minute, allowing for the retrieval of all required information within the allowed limits. To repeat requests and obtain remaining vulnerabilities, it is recommended that you utilize the pagination method. Detailed information on pagination can be found in the Lansweeper documentation.