SOLVED

SPFx - Get all site collections

Brass Contributor

Dear Ladies and Gentlemen,

 

how can I get all site collections, for which the logged in user has access rights, through SharePoint Framework, which works in Office 365 and in SharePoint on premise?

 

Thank you very much for your help.

 

With best regards

Ladislav Stupak

4 Replies

@LadislavStupak I would use the Search REST API to get all of the site collections.

_api/search/query?querytext='contentclass:sts_site'

@Beau Cameron thank you for your answer.

 

When I do it through the following method below, then I receive following error: "Microsoft.SharePoint.Client.UnknownError

 

public GetAllSiteCollections2(context: WebPartContext:( Promise<ISiteCollection[]> {

        let restApiUrl: string = context.pageContext.web.absoluteUrl + "/_api/search/query?querytext='contentclass:sts_site'";        
        
        let siteCollections: ISiteCollection[] = [];

        return new Promise<ISiteCollection[]>(async(resolve, reject) => {

            context.spHttpClient
                .get(restApiUrl, SPHttpClient.configurations.v1)
                .then((response: SPHttpClientResponse) => {
                    response.json().then((results: any) => {

                        console.log(restApiUrl);
                        console.log(results);

                        results.value.map((result: any) => {

                            siteCollections.push({
                                Title: result.Title,
                                SPSiteUrl: result.Url,
                            });
                        });

                        console.log(siteCollections);
                        resolve(siteCollections);                    
                    });
                }, (error: any:( void => {

                    reject("error occured " + error);
                });
        })
    }
 
When I try it through following method, where I override the configuration version, then I receive as results an empty array. See print screen with the results log below the method.
 
public GetAllSiteCollections(context: WebPartContext:( Promise<ISiteCollection[]> {

        let restApiUrl: string = context.pageContext.web.absoluteUrl + "/_api/search/query?querytext='contentclass:sts_site'";
                      
        const spSearchConfig: ISPHttpClientConfiguration = {

            defaultODataVersion: ODataVersion.v3
        };

        let siteCollections: ISiteCollection[] = [];

        return new Promise<ISiteCollection[]>(async(resolve, reject) => {

            context.spHttpClient
                .get(restApiUrl, SPHttpClient.configurations.v1.overrideWith(spSearchConfig))
                .then((response: SPHttpClientResponse) => {
                    response.json().then((results: any) => {

                        console.log(restApiUrl);
                        console.log(results);
                       
                        results.value.map((result: any) => {

                            siteCollections.push({
                                Title: result.Title,
                                SPSiteUrl: result.Url,
                            });
                        });

                        console.log(siteCollections);
                        resolve(siteCollections);                    
                    });
                }, (error: any:( void => {

                    reject("error occured " + error);
                });
        })
    }
 
Search Site Collections Results empty.PNG
 
Thank you for help.
 
With best regards
Ladislav Stupak
best response confirmed by LadislavStupak (Brass Contributor)
Solution

This method is working well:

 

public GetAllSiteCollections5(context: WebPartContext:( Promise<ISiteCollection[]> {
        
        let restApiUrl: string = context.pageContext.web.absoluteUrl + "/_api/search/query?querytext='contentclass:sts_site'";

        let siteCollections: ISiteCollection[] = [];

        let config: SPHttpClientConfiguration = new SPHttpClientConfiguration({
            defaultODataVersion: ODataVersion.v3
        });

        return new Promise<ISiteCollection[]>(async(resolve, reject) => {

            context.spHttpClient
            .get(restApiUrl, config, {headers: { Accept: "application/json;odata=minimalmetadata;charset=utf-8"}})
            .then((response: SPHttpClientResponse) => {

                console.log("response contains: " + JSON.stringify(response));

                response.json().then((results: any) => {

                    console.log(restApiUrl);
                    console.log("results contains: " + JSON.stringify(results));
                    
                    let resultsList = results.PrimaryQueryResult.RelevantResults.Table.Rows;
                    
                    console.log(resultsList);
                    
                    resultsList.map((result: any) => {

                        console.log(result);

                        let cell3 = result.Cells[3];
                        console.log("cell3: " + JSON.stringify(cell3));

                        let cell6 = result.Cells[6];
                        console.log("cell6: " + JSON.stringify(cell6));

                        let cell3Value = cell3.Value;
                        console.log(cell3Value);

                        let cell6Value = cell6.Value;
                        console.log(cell6Value);

                        siteCollections.push({
                            Title: cell3Value,
                            SPSiteUrl: cell6Value,
                        });
                    });

                    console.log(siteCollections);
                    resolve(siteCollections);
                });
            }, (error: any:( void => {

                reject("error occured " + error);
            });
        })
    }

This method is better, because in case the restApiUrl contains some additional parameters, the position of Title and path in the cells array can change:

 

public GetAllSiteCollections5(context: WebPartContext:( Promise<ISiteCollection[]> {
        
        let restApiUrl: string = context.pageContext.web.absoluteUrl + "/_api/search/query?querytext='contentclass:sts_site'";
        
        let siteCollections: ISiteCollection[] = [];

        let config: SPHttpClientConfiguration = new SPHttpClientConfiguration({
            defaultODataVersion: ODataVersion.v3
        });

        return new Promise<ISiteCollection[]>(async(resolve, reject) => {

            context.spHttpClient
            .get(restApiUrl, config, {headers: { Accept: "application/json;odata=minimalmetadata;charset=utf-8"}})
            .then((response: SPHttpClientResponse) => {

                console.log("response contains: " + JSON.stringify(response));

                response.json().then((results: any) => {

                    console.log(restApiUrl);
                    console.log("results contains: " + JSON.stringify(results));
                    
                    let resultsList = results.PrimaryQueryResult.RelevantResults.Table.Rows;
                    
                    console.log(resultsList);
                    
                    resultsList.map((result: any) => {                        

                        let cells = result.Cells;
                        console.log("cells: " + JSON.stringify(cells));

                        let title: string = "";
                        let path: string = "";

                        cells.map((cell: any) => {

                            console.log("cell: " + JSON.stringify(cell));

                            let key = cell.Key;

                            if (key == "Title"{

                                title = cell.Value;
                            } else if (key == "Path"{

                                path = cell.Value;
                            }                         
                        });

                        siteCollections.push({
                            Title: title,
                            SPSiteUrl: path,
                        });
                    });

                    console.log(siteCollections);
                    resolve(siteCollections);
                });
            }, (error: any:( void => {

                reject("error occured " + error);
            });
        })
    }
1 best response

Accepted Solutions
best response confirmed by LadislavStupak (Brass Contributor)
Solution

This method is working well:

 

public GetAllSiteCollections5(context: WebPartContext:( Promise<ISiteCollection[]> {
        
        let restApiUrl: string = context.pageContext.web.absoluteUrl + "/_api/search/query?querytext='contentclass:sts_site'";

        let siteCollections: ISiteCollection[] = [];

        let config: SPHttpClientConfiguration = new SPHttpClientConfiguration({
            defaultODataVersion: ODataVersion.v3
        });

        return new Promise<ISiteCollection[]>(async(resolve, reject) => {

            context.spHttpClient
            .get(restApiUrl, config, {headers: { Accept: "application/json;odata=minimalmetadata;charset=utf-8"}})
            .then((response: SPHttpClientResponse) => {

                console.log("response contains: " + JSON.stringify(response));

                response.json().then((results: any) => {

                    console.log(restApiUrl);
                    console.log("results contains: " + JSON.stringify(results));
                    
                    let resultsList = results.PrimaryQueryResult.RelevantResults.Table.Rows;
                    
                    console.log(resultsList);
                    
                    resultsList.map((result: any) => {

                        console.log(result);

                        let cell3 = result.Cells[3];
                        console.log("cell3: " + JSON.stringify(cell3));

                        let cell6 = result.Cells[6];
                        console.log("cell6: " + JSON.stringify(cell6));

                        let cell3Value = cell3.Value;
                        console.log(cell3Value);

                        let cell6Value = cell6.Value;
                        console.log(cell6Value);

                        siteCollections.push({
                            Title: cell3Value,
                            SPSiteUrl: cell6Value,
                        });
                    });

                    console.log(siteCollections);
                    resolve(siteCollections);
                });
            }, (error: any:( void => {

                reject("error occured " + error);
            });
        })
    }

View solution in original post