Share via

How to query custom fields from Microsoft Project server via OData for Excel?

Anonymous
2020-10-07T21:57:25+00:00

Hello,

I need to bring in custom task fields from Project Server.  I cannot find where the values are stored to be able to link them to the task table via OData feed  in Power Query for Excel.

Any thoughts?

Thank you!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-12-12T17:28:09+00:00

    Hi Neha, i´m with a similar issue. I can get the task table with the standrad fields, bu ti need to get some Customs fields that i´m using for aditional Task Data (In project, usually they are the fields Text2, Text 2, etc.) Is there any way to expand the fileds selection?

    thnaks in advance

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-10-14T06:53:03+00:00

    Hi Joel.Schaefer,

    That seems to be Project online. Once you query, you should see the tasks in the navigator window along with the column, as shown below.

    Thanks,

    Neha

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-10-13T19:54:39+00:00

    I might be calling it the wrong thing.  The Project Server is at https://ourdomain.sharepoint.com/sites/pwa/ .  Would this be considered Project Online or Project Server?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-10-13T18:22:13+00:00

    I am actually able to query the tables in Project Server via OData.  I am having a hard time identifying where Custom Fields for tasks are stored.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2020-10-08T09:01:57+00:00

    Hi Joel.Schaefer,

    Usually, when connecting Project Online with Excel via OData, url can be found by navigating to the PWA site. Paste the copied URL in the OData Feed dialog box and add “/_api/projectdata” to the end. Click OK.

    Here’s an article related to Project online and Excel. You can check the following article, see if this applies in Project Server scenario.

    Project Online: Updating OData connections in Excel for different PWA instances

    Since you are using Project server, the URL might differ and if you still need help, we’ll request your post in Microsoft Q & A forum for assistance.

    The reason we request you to post a new thread is that in Answers forum, we have limited resources and very little knowledge about Project Server, as we deal with Microsoft 365/Project online services and in Microsoft Q & A forum, you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction.

    Thanks for your understanding and co-operation.

    With sincerest regards,

    Neha

    Was this answer helpful?

    0 comments