Home

Project OData/API

%3CLINGO-SUB%20id%3D%22lingo-sub-218694%22%20slang%3D%22en-US%22%3EProject%20OData%2FAPI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218694%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20Has%20anyone%20got%20any%20idea%20if%20there%20has%20been%20any%20recent%20changes%20in%26nbsp%3Bthe%20API%20space%26nbsp%3Bfor%20Project.%20To%20be%20more%20specific%20in%20terms%20of%20EnterpriseResources%20like%20any%20metadata%20changes%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219425%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20OData%2FAPI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219425%22%20slang%3D%22en-US%22%3EThanks!%20Ian%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219350%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20OData%2FAPI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219350%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20not%26nbsp%3Bwell%20versed%20in%20the%20structure%20of%20the%20query%20you%20provided.%20I've%20typically%20queried%20against%26nbsp%3B_api%2FProjectData%20instead%20of%20%2FProjectServer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efor%20example%3A%3C%2FP%3E%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Fxyz.sharepoint.com%2Fsites%2Fpwa%2F_api%2FProjectData%2FResources%3F%24filter%3DResourceIsActive%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fxyz.sharepoint.com%2Fsites%2Fpwa%2F_api%2FProjectData%2FResources%3F%24filter%3DResourceIsActive%3C%2FA%3E%20eq%20false%20and%20ResourceID%20eq%20'guid'%3CBR%20%2F%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EHere's%20the%20reference%3C%2FP%3E%3CP%3Eall%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fprevious-versions%2Foffice%2Fproject-odata%2Fjj163015(v%253doffice.15)%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fprevious-versions%2Foffice%2Fproject-odata%2Fjj163015(v%253doffice.15)%3C%2FA%3E%3C%2FP%3E%3CP%3Eresource%20type%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fprevious-versions%2Foffice%2Fproject-odata%2Fjj163027(v%253doffice.15)%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fprevious-versions%2Foffice%2Fproject-odata%2Fjj163027(v%253doffice.15)%3C%2FA%3E%3C%2FP%3E%3CP%3EValid%20Resource%20Types%3A%20%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fjj232846%2528v%3Doffice.15%2529%3Ff%3D255%26amp%3BMSPPError%3D-2147217396%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fjj232846%2528v%3Doffice.15%2529%3Ff%3D255%26amp%3BMSPPError%3D-2147217396%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219043%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20OData%2FAPI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219043%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Ian%2C%20thanks%20your%20quick%20response.%20The%20input%20data%20is%3CBR%20%2F%3E%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22Id%22%3A%20%22ResourceGUID%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22IsActive%22%3A%20%22false%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22__metadata%22%3A%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22type%22%3A%20%22PS.EnterpriseResource%22%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%3CBR%20%2F%3E%7D%3C%2FP%3E%3CP%3EWhich%20is%20being%20sent%20to%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fxxxx.sharepoint.com%2Fsites%2Fpwa%2F_api%2FProjectServer%2FEnterpriseResources%2FGetById('ResourceGUID%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fxxxx.sharepoint.com%2Fsites%2Fpwa%2F_api%2FProjectServer%2FEnterpriseResources%2FGetById('ResourceGUID%3C%2FA%3E')%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3EWhich%20produced%20the%20error%20response%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E%7B%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22odata.error%22%3A%20%7B%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22code%22%3A%20%22-1%2C%20Microsoft.SharePoint.Client.InvalidClientQueryException%22%2C%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22message%22%3A%20%7B%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22lang%22%3A%20%22en-US%22%2C%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22value%22%3A%20%22A%20value%20without%20a%20type%20name%20was%20found%20and%20no%20expected%20type%20is%20available.%20When%20the%20model%20is%20specified%2C%20each%20value%20in%20the%20payload%20must%20have%20a%20type%20which%20can%20be%20either%20specified%20in%20the%20payload%2C%20explicitly%20by%20the%20caller%20or%20implicitly%20inferred%20from%20the%20parent%20value.%22%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219038%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20OData%2FAPI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219038%22%20slang%3D%22en-US%22%3EI%20haven't%20noticed%20filters%20not%20working.%20If%20you%20care%20to%20be%20more%20specific%20about%20the%20query%20that's%20no%20longer%20working%20for%20you%2C%20I'd%20be%20happy%20to%20try%20a%20similar%20one.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219037%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20OData%2FAPI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219037%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20integration%20team%20who%20has%20come%20to%20me%20and%20raised%20a%20concern%20that%20the%20code%20in%20place%20which%20was%20working%20earlier%20is%20failing%20now.%20I%20then%20checked%20what%20is%20being%20sent%20to%20query%20the%20data%20and%20found%20one%20of%20the%20metadata%20property%20sent%20as%20a%20filter%20doesnt%20exist%20in%20the%20metadata%20structure.%20Hence%20upon%20modifying%20their%20query%20to%20remove%20that%20worked.%20Thats%20the%20reason%20just%20wondering%20if%20anything%20has%20changed%20in%20this%20context.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-218815%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20OData%2FAPI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218815%22%20slang%3D%22en-US%22%3E%3CP%3EAre%20you%20hoping%20for%20some%20new%20things%3F%20or%20something%20in%20particular%20isn't%20the%20same%20for%20you%20anymore%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
yaminiradhamani
Occasional Contributor

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

 

6 Replies

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

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.

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.

Hey Ian, thanks your quick response. The input data is
{
               "Id": "ResourceGUID",
               "IsActive": "false",
               "__metadata": {
                              "type": "PS.EnterpriseResource"
               }
}

Which is being sent to
https://xxxx.sharepoint.com/sites/pwa/_api/ProjectServer/EnterpriseResources/GetById('ResourceGUID')

 

Which produced the error response

{

               "odata.error": {

                              "code": "-1, Microsoft.SharePoint.Client.InvalidClientQueryException",

                              "message": {

                                             "lang": "en-US",

                                             "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."

                              }

               }

I'm not well versed in the structure of the query you provided. I've typically queried against _api/ProjectData instead of /ProjectServer.

 

for example:

Here's the reference

all: 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&MSPPError=-2147217396

 

 

Thanks! Ian
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies