locked
CRM Online 2015 Update 1 - Web API Preview - fetching Navigation properties for a EntitySet gives error RRS feed

  • Question

  • Hi All,

    I enabled the Web API Preview for CRM online 2015 Update 1.

    When tried to run a OData query using Organization service -  to get EntitySet with navigation properties it works ok.

    However the same query (with change in syntax) when run using Web API gave error.

    Example:

    https://..serviceurl/api/data/Entity$select=columns...$expand=relatedEntity($select=relatedFieldName)$filter=....

    The above query gives error

    However if i change this to just fetch only one entity i.e.

    https://..serviceurl/api/data/Entity(...Guid here for one entity...)$select=columns...$expand=relatedEntity($select=relateFieldName)$filter=....

    The exact same query works.

    So the question is "How do we get a entityset with fields from related entities using CRM online Web API."

    Given that organization service is now deprecated (still available but in future it will go away) in CRM 2016.

    I even tried FetchXMLwith Web API  - that also gave error. One possibility I see is that the Preview Web API in CRM online 2015 update 1 does not support these.

    Has anyone tried this scenario in CRM Online 2016 and if they work ok?

    Please advise.

    Mohan


    -- Mohan | My Blog

    Friday, January 8, 2016 10:25 PM

All replies

  • This is the same in 2016. Using an expand operating when retrieving multiple records is supported at the moment. It should be supported in a future release. The current organization service (SOAP) isn't deprecated, only the 2011 OData-REST / organization data service is deprecated. So the interim you'll still need to use the endpoint or the SOAP based organization service endpoint to make such a query. 

    https://msdn.microsoft.com/en-us/library/mt628816.aspx#bkmk_246253


    Jason Lattimer
    My Blog -  Follow me on Twitter -  LinkedIn

    Saturday, January 9, 2016 3:06 AM
    Moderator