none
Get list all projects project web RRS feed

  • Question

  • Hi all
    Couple months ago, I started to administer a project server 2016 migrated from 2010, but I didn't take part of migration.

    Now I trying to do a Power Bi report using api rest http://myshpsite/pwa/_api/ProjectServer/Projects
    This returns all default information about project, custom enterprise fields are not returned. 

    How can I get a list of all project with custom fields using rest api?

    Douglas Filipe http://douglasfilipe.wordpress.com

    Tuesday, September 15, 2020 7:58 PM

All replies

  • Hello,

    For reports, use the Project Data reporting API as this is API is designed for reporting so the data is easily accessible. The Reporting API root is {pwaSite}/_api/ProjectData. Projects are available at {pwaSite}/_api/ProjectData/Projects

    Hope that helps

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Saturday, September 26, 2020 7:03 PM
    Moderator
  • Thanks for reply Paul.
    But, when I try to access this url in my environment an error is shown:

    http://mysharepointsite/pwa/_api/ProjectData/

    <m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
    <m:code>500</m:code>
    <m:message xml:lang="en-US">An error occurred while trying to write an error payload.</m:message>
    </m:error>


    Douglas Filipe http://douglasfilipe.wordpress.com

    Saturday, September 26, 2020 9:29 PM
  • Hello,

    Anything in the SharePoint ULS logs for this or even the IIS logs? I don't recall any specific Project Server 2016 patches for this but what build version is your Project Server 2016 farm? 

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Sunday, September 27, 2020 8:35 AM
    Moderator