SharePoint CSOM, retrieving site collections. Limited to 300

csomsharepoint

I am trying to retrieve the site collections list from a SharePoint Online domain.

I am using C# and client object model.

The following code returns only 300 site collections.

var tenant = new Tenant(ctx);
spp = tenant.GetSiteProperties(0, true);
ctx.Load(spp);
ctx.ExecuteQuery();

Any idea on how to retrieve ALL site collections with CSOM ?

Thanks

Best Answer

I found the answer to this question,

the first parameter of the method GetSiteProperties is the index from which site collection retrieval starts.

I tried the the following command spp = tenant.GetSiteProperties(300, true);

which returned site collections from index 300.

So here is my code to get all site collections from sharepoint online

SPOSitePropertiesEnumerable spp = null;
var tenant = new Tenant(ctx);
int startIndex = 0;

while (spp == null || spp.Count > 0)
{
    spp = tenant.GetSiteProperties(startIndex, true);
    ctx.Load(spp);
    ctx.ExecuteQuery();

    foreach (SiteProperties sp in spp)
    siteCols.Add(new SiteCol(sp.Title, sp.Url));

    startIndex += spp.Count;
}

By the way, site collections are currently limited to 10000.

Related Solutions

Javascript – Getting Sharepoint selected list item by using Client Side Object Model (CSOM)

SP.ListOperation.Selection Class Provides methods for selecting lists or list items, in particular SP.ListOperation.Selection.getSelectedItems() method Gets the list items being selected

Example 1: Get selected items

function getSelectedItems()
{
    var context = SP.ClientContext.get_current();
    var selectedItems = SP.ListOperation.Selection.getSelectedItems(context);
    return selectedItems;
}

Note: Method SP.ListOperation.Selection.getSelectedItems returns the key/value collection > that contains the list items being selected (not SP.ListItem collection!)

Example 2. Get selected SP.ListItem collection

function getSelectedItems(OnSuccess,OnError)
{
    var context = SP.ClientContext.get_current();
    var listId = SP.ListOperation.Selection.getSelectedList(); //selected list Id
    var selectedItemIds = SP.ListOperation.Selection.getSelectedItems(context); //selected Items Ids

    var list = context.get_web().get_lists().getById(listId);
    var listItems = [];
    for (idx in selectedItemIds)
    {
        var item = list.getItemById(parseInt(selectedItemIds[idx].id));
        listItems.push(item);
        context.load(item);
    }
    context.executeQueryAsync(
       function() {
          OnSuccess(listItems);       
       },
       OnError
    ); 

}

//Usage
getSelectedItems(function(items){
    for (var i =0 ; i < items.length;i++)
    {
       console.log(items[i].get_item('Title'));  
    }  
},function(sender,args){
    console.log('An error occured: ' + args.get_message());
});

Best Answer

Related Solutions

Javascript – Getting Sharepoint selected list item by using Client Side Object Model (CSOM)

Related Topic