Get top x urls without the above categories nested data aka filter results for precence of URL

I want to retrieve the top 10 URLs via the API. But I have activated the categories feature which aggregates all pages also under there directories diverted by “/”.

How can I get rid of the categorie data in the result? I just need the top 10 URLs on the whole site.


Additional to this API query I would need a function to:

  1. Filter only rows where a url value is existing


  1. Have a funktion that gives me only the leaves of the tree.

Searched through all the documentation a couldn’t find anything to get this in my eye really simple result set.

Is this really not possible?