Microsoft Graph API - Fetch Sharepoint Sites - New Sites not listed

Question

Have been using https://graph.microsoft.com/v1.0/sites endpoints to list all SharePoint sites successfully (Teams Sites, Communication Sites, Document Content Sites) both against my trial SharePoint account as well as at a third party SharePoint account (auth is client credentials)

The third-party created some new sites yesterday and they are not listed in the response (all of the sites created before, even last month are listed as expected).

Thus created new sites (one Teams Site, one Communication Sites, and one Document Content Site with the same settings as my third party client) against my SharePoint Collection and noticed that the new sites are not displayed right away (I can access them via the site URL). Only after about a 5-minute delay, they start appearing in the REST response.

Wondering whether the Graph API is not fetching site information from the live repository and if it relies on some sort of a cache? And if so why do I not get similar results with my third-party SharePoint sites (even with a lag)?

Has anyone experienced this recently (as I believe this used to work fine with new sites before)?

Answer 1

Hi @Artha Wijendra ,

Per the API documents, this endpoint of enumerating sites is only available in /beta version. Hence i belive the related functionlaity are not yet perfect.

You can have a try below alternative method:

There is a list in tenant-admin site that stores a cached copy of aggregated site collections data from all contentdb.

• Get tenant -admin site:

• Find the lists: DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECO and DO_NOT_DELETE_SPLIST_TENANTADMIN_ALL_SITES_AGGREGA

These lists contain all site collection info.

One list includes personal site and another does not.

Best Regards,
Baker Kong

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.