I need a custom web part that aggregates list data across web applications. I would like to keep it sandboxed if at all possible.
I first tried to use the out of the box SharePoint web services (listdata.svc) for Data Access, but encountered this error (I think this has to do with the sandbox code service running with partial trust.):
Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Net.WebPermission, System, Version=18.104.22.168, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Is there a configuration I could change on the sandbox code service to allow web requests? If not, what would you recommend as the best way to perform the data access (while staying sandboxed)?