CODEWITHSUNDEEP
ms-project-server-2016
Maxcot
Maxcot

Reputation: 1617

Is there a way to get a list of all Project from MS Project Online (PWA)

MS Project is a bucket of bolts... but sometimes we have to work with what we've got.

I have a MS Project online, Project Web Access (PWA) with no reporting capabilities like PowerBI or anything.

Is there any way to use VBA to get a list of all the projects in the online environment? PowerShell would be great, but I have no admin rights to use them. https://learn.microsoft.com/en-us/projectonline/export-user-data-from-project-online

Upvotes: 1

Views: 1168

Answers (2)

Bianca Vilanova
Bianca Vilanova

Reputation: 1

You just use Project's native API:

URLPWA/_api/ProjectData/Projects

Upvotes: 0

Maxcot
Maxcot

Reputation: 1617

OData does the trick.

PowerBI and excel both have PowerQuery functionality with a OData connector, and it solves the problem.

Upvotes: 0

Related Questions