Forum Discussion
netmarcos
Jul 27, 2022Copper Contributor
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...
- Jul 27, 2022
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.
Paul
netmarcos
Jul 29, 2022Copper Contributor
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.
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
Jul 29, 2022MVP
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
- netmarcosJul 29, 2022Copper ContributorI'll go sit in my corner. There are probably a lot of things that I have done that are not supported.
- Paul_MatherJul 29, 2022MVP
haha, opps netmarcos