My boss has been looking for a way to do this for a while, I figured I might as well ask around instead of telling him it can't be done without multiple queries to the server.
During a Project Server deployment it is common to add fields to the native Issues and Risks lists that stay inside each Project site. Project Server natively exports Risk and Issue information to its Reporting database, however, it does not take the fields that were added during the deployment.
We want to build a report using Excel Services containing this information without having to query each project site that exists on the server, using the REST API so that it can be used in SPO.
I am aware that I can use the REST query of
But what I want would be the equivalent of
/PWA/ProjectSiteA/_api/web/lists/getbytitle('Risks')/Items UNION /PWA/ProjectSiteB/_api/web/lists/getbytitle('Risks')/Items UNION /PWA/ProjectSiteC/_api/web/lists/getbytitle('Risks')/Items
For those not familiar with Project Server, all Project sites are subsites of the Project Server instance's site collection.
Is there a way (SPSiteDataQuery?) to query all these lists without iterating all the sites through the REST(or CSOM) api?