SonarQube API and Power BI Tabulation

Hi Community, quick question, the sonar api works well with Power BI for data tabulation, there a data cap though, we are to pull total issues but the cap is 500 limit, is there anyway / approach we can use to increase this?
Here’s an example of the api data cap. api/issues/search?componentKeys=MyApp&ps=-1&p=1

{“total”:2808,“p”:1,“ps”:500,“paging”:{“pageIndex”:1,“pageSize”:500,“total”:2808},“effortTotal”:21827,“debtTotal”:21827,“issues”:

Hi @crispin,

the page size (the ps parameter) has a max of 500, so you would have to go to the next page (the p parameter) for the next 500 entries

hope that helps :slight_smile:

Thanks for the response, is there anyway we can pull without caps, for instance a single URL? (without any next page p parameter)

An example , api/issues/search?componentKeys=MyApp&ps=-1&p=1 (-1 means unlimited or infinite)

The scenario would be from

{“total”:2808,“p”:1,“ps”:500,“paging”:{“pageIndex”:1,“pageSize”:500,“total”:2808},“effortTotal”:21827,“debtTotal”:21827,“issues”:

to the scenario below,

{“total”:2808,“p”:1,“ps”:2808,“paging”:{“pageIndex”:1,“pageSize”:2808,“total”:2808},“effortTotal”:21827,“debtTotal”:21827,“issues”:

Hi @crispin ,

no. for performance reasons this is a hardcoded max value