I have a question about showing data from multiple site collections in SharePoint online.

I want each customer to have it's own site. This should be a site collection because if I make it a normal site and I create a task list, the customer is able to see other customers when assigning a task.

What I want to do is the following. Every customer has a site collection with a question list in it. On the root site I want to show all questions for all customers. I've already done such a thing with a keywordquery in a farm solution.

To show data from multiple site collections in sharepoint online sandboxed solution I've tried:

  • using a keywordquery
  • using the search.asmx webservice

But unfortunately both can't be used in a sandboxed solution. What would be the easiest way to accomplish this?

3 Answers 3


Use the Lists.asmx web service and the GetListItems method. (I know it's an old question but it came up as one of the top search results so figured it might be worth answering)


For the scope you require you can't use sand boxed solutions, this is because by the very nature of your requirement it is a farm level task.

Here is a great post on scopes and solutions

Workflows updating across site collections this should work fine with office365 however it isn't as fast as using the object model, so use with care.

  • thanks for your answer. I don't understand why it is a farm level task. I want a simple webpart that shows data from a list (for example questions) that is in multiple site collections. In my webpart I want to show all questions. Looks like it is possible here but I don't want to use silverlight.
    – Marlou
    Sep 4, 2012 at 14:54
  • changed my post a little bit to explain why I want to aggregate the data :)
    – Marlou
    Sep 4, 2012 at 15:01
  • If the lists are on separate site collections the scope becomes farm level as apposed to site level ( on one site collection ). You can delegate and spoof yourself as the farm administrator and deploy a single farm level web part to do this. However the solution is still farm level because of the requirement of where the code should be stored. Can I ask why it needs to be a sandbox solution? Created properly farm level isn't a problem.
    – Hugh Wood
    Sep 4, 2012 at 15:02
  • It needs to be a sandbox solution because of SharePoint online (Office365).
    – Marlou
    Sep 4, 2012 at 15:13
  • Sharepoint online does not support Full Trust Coded (FTC) solutions at all. This means that site collections are protected from each other by a layer of security and you shouldn't try and circumvent it. However you may be able to use workflows to achieve what you require, take a look here spdactivities.codeplex.com
    – Hugh Wood
    Sep 4, 2012 at 15:18

Luckily we have a content search web part now and it is possible to add that keywordquery in there.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.