SonarCloud API search projects by size

[ScorcioneMatteo]

Hello!

For a data analysis project I would need to collect from https://sonarcloud.io/api/components/search_projects the organisation key and project name for all projects with size >=4. Filter in a similar way as in Open Source Projects - SonarCloud. Is this possible or there are other soultions to get a similar result? Web Scraping directly from the latter would be much more challenging.

Thanks in advance.

[Colin]

Hey there.

You’ve already identified the right Web API to use, which returns the organization key and project. What’s the missing piece?

How to reverse engineer the Sonar Web API

Every action that is taken in the SonarQube / SonarCloud UI is driven by the Web API. There is nothing you can do in SonarQube / SonarCloud that you cannot do using the Web API. We put a great deal of effort into the UI and UX of our products and sincerely think that most actions should be completed there. Especially when it comes to viewing analysis results, the UI is the best place to view up-to-date information with the right context. We think it is much better that you give access…

[ScorcioneMatteo]

Hi Colin,

the right API would be https://sonarcloud.io/api/components/search_projects that is not included in the documentation. But it gives back project key and organization name as output. I would need to filter to get only project with more than 100k ncloc (or like in the explore section size >=4).

My temporary solution is saving all the possible projects key returned by https://sonarcloud.io/api/components/search_projects and then double check through https://sonarcloud.io/api/measures/component if they have more than 100k ncloc. But I think that with this last method I miss out some of the projects and would be better to filter directly within the first call.

Thank you again!

[Colin]

You can also just add this query parameter: &filter=ncloc+>%3D+100000

Like:

https://sonarcloud.io/api/components/search_projects?boostNewProjects=false&facets=ncloc%2Clanguages&ps=50&f=analysisDate&s=analysisDate&asc=false&filter=ncloc+%3E%3D+100000