I'm trying to create a small webpart to display the most recently added subsites in a site collection. The collection has ~230 sub sites currently - a number that will only increase over time.
I want to use REST to retrieve the data for my webpart, but I'm getting the error "The request uses too many resources". The GET request I'm trying to execute is this:
https://site-coll-url/_api/web/webs?$select=Title,Created,Description,Url,ServerRelativeUrl &$top=10&$orderby=Created desc
If I remove the "orderby" query, the request is handled fine. Also, even if I remove "orderby" and "top", the request runs, and returns all 230 subsites as results. Does anyone know why "orderby" is causing the 'too many resources' error? And what can I do to get around it?