none
Field names for Excel report in PowerPivot (Project Online) RRS feed

  • Question

  • Hello,

    Where can we find the true labels of field names? I'm trying to build a connection file.

    Thanks

    Saturday, August 10, 2013 2:24 PM

Answers

  • You need to use the ProjectBaselines feed rather than the Projects feed to get the baseline fields. You would need to join the two tables together in Excel using the relationship functionality. You would have ProjectId in both feeds / tables and join on that field. Paul

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

    • Marked as answer by WLID1966 Sunday, August 11, 2013 7:15 AM
    Saturday, August 10, 2013 10:41 PM
    Moderator

All replies

  • For example, what would be  the names for "Project Baseline Cost" and for "Project Baseline Work" that I need to add in the following query ?

    Thanks for your help

    Data Source=https://asoft.sharepoint.com/sites/pwa/_api/ProjectData/[en-US]/Projects;Namespaces to Include=*;Integrated Security=SSPI;Persist Security Info=false;Base Url="https://asoft.sharepoint.com/sites/pwa/_api/ProjectData/[en-US]/Projects?$select=ProjectId,EnterpriseProjectTypeName,ParentProjectId,ProjectFinishDate,ProjectName,ProjectOwnerId,ProjectWork,ProjectCost,ProjectOwnerName,ProjectPercentCompleted,ProjectStartDate,ProjectEnterpriseFeatures"

    Saturday, August 10, 2013 7:03 PM
  • You need to use the ProjectBaselines feed rather than the Projects feed to get the baseline fields. You would need to join the two tables together in Excel using the relationship functionality. You would have ProjectId in both feeds / tables and join on that field. Paul

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

    • Marked as answer by WLID1966 Sunday, August 11, 2013 7:15 AM
    Saturday, August 10, 2013 10:41 PM
    Moderator