Forum Discussion

netmarcos's avatar
netmarcos
Copper Contributor
Jul 27, 2022

API reporting data fields and limitations

The API feed for projects only includes the last modified date for baselines [ProjectBaselineModifiedDate] and not the actual date that the baseline was established. To get to that, I need to open MS...
Paul_Mather's avatar
Paul_Mather
MVP

Hello netmarcos ,

This wont be added to the Project Online Odata API. You could have a new Enterprise Custom fields in Project Online and programmatically write the baseline saved dates to those fields. I wrote a simple example many years ago for on-premises but the same concept will work for Project Online for baselines created in the Project Client. For baselines created in PWA, this approach wont work.

https://pwmather.wordpress.com/2011/08/20/report-on-project-server-baseline-save-dates-projectserver-ps2003-ps2007-ps2010-msproject-epm/ 

Paul

netmarcos's avatar
netmarcos
Copper Contributor
Jul 29, 2022
Messy but I guess effective. It would be an enormous challenge to get a client-side macro approved in our (Government) environment.

Curious though: for on premise installations, I would simply pull this data from draft.MSP_TASK_BASELINES_PUBLISHED_VIEW or Pub.MSP_TASK_BASELINES. I suppose those days are gone.
  • Paul_Mather's avatar
    Paul_Mather
    MVP
    Jul 29, 2022

    Hello netmarcos ,

    On premises it is not supported to query the pub schema with T-SQL, it is only supported to query the reporting schema (pjrep).

    Paul

    • netmarcos's avatar
      netmarcos
      Copper Contributor
      Jul 29, 2022
      I'll go sit in my corner. There are probably a lot of things that I have done that are not supported.