Project OData/API

Question

Hi! Has anyone got any idea if there has been any recent changes in&nbsp;the API space&nbsp;for Project. To be more specific in terms of EnterpriseResources like any metadata changes?&nbsp;

ian bruckner · Answer

Are you hoping for some new things? or something in particular isn't the same for you anymore?

yaminiradhamani · Answer

I have an integration team who has come to me and raised a concern that the code in place which was working earlier is failing now. I then checked what is being sent to query the data and found one of the metadata property sent as a filter doesnt exist in the metadata structure. Hence upon modifying their query to remove that worked. Thats the reason just wondering if anything has changed in this context.

ian bruckner · Answer

I haven't noticed filters not working. If you care to be more specific about the query that's no longer working for you, I'd be happy to try a similar one.

yaminiradhamani · Answer

Hey Ian, thanks your quick response. The input data is{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Id": "ResourceGUID",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "IsActive": "false",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "__metadata": {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "type": "PS.EnterpriseResource"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }}Which is being sent tohttps://xxxx.sharepoint.com/sites/pwa/_api/ProjectServer/EnterpriseResources/GetById('ResourceGUID')&nbsp;Which produced the error response{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "odata.error": {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "code": "-1, Microsoft.SharePoint.Client.InvalidClientQueryException",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "message": {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "lang": "en-US",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "value": "A value without a type name was found and no expected type is available. When the model is specified, each value in the payload must have a type which can be either specified in the payload, explicitly by the caller or implicitly inferred from the parent value."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }

ian bruckner · Answer

I'm not&nbsp;well versed in the structure of the query you provided. I've typically queried against&nbsp;_api/ProjectData instead of /ProjectServer.&nbsp;for example:https://xyz.sharepoint.com/sites/pwa/_api/ProjectData/Resources?$filter=ResourceIsActive eq false and ResourceID eq 'guid'&nbsp;Here's the referenceall: https://docs.microsoft.com/en-us/previous-versions/office/project-odata/jj163015(v%3doffice.15)resource type: https://docs.microsoft.com/en-us/previous-versions/office/project-odata/jj163027(v%3doffice.15)Valid Resource Types: https://msdn.microsoft.com/en-us/library/jj232846%28v=office.15%29?f=255&amp;MSPPError=-2147217396&nbsp;&nbsp;

Forum Discussion

Project OData/API

6 Replies

Resources