Share
Report
10I am trying to build a query that will retrieve the list of absolute URL of documents linked to products. I validated that there are documents, and can see them from Dynamics. I built a simple fetch XML like this one, and it doesn't return anything for the absolute URL, it's blank:
<fetch top="50">
<entity name="product">
<attribute name="anca_productdisplayname" />
<attribute name="anca_productname" />
<attribute name="productid" />
<filter>
<condition attribute="productid" operator="eq" value="00000000-0000-0000-0000-000000000000" />
</filter>
<link-entity name="sharepointdocument" from="regardingobjectid" to="productid" link-type="outer" alias="sp">
<attribute name="absoluteurl" />
<attribute name="filetype" />
</link-entity>
</entity>
</fetch>
I also noticed that expanding the 'sharepointdocument' entity works fine when querying the WebAPI directly to a record, but not when using a filter, which technically returns the same thing:
Works
/api/data/v9.0/products(00000000-0000-0000-0000-000000000000)?$select=productid&$expand=Product_SharepointDocument($select=sharepointdocumentid,fullname,absoluteurl,documentid,filetype),Product_SharepointDocument($top=1)
Doesn't work
/api/data/v9.0/products?$filter=productid eq 00000000-0000-0000-0000-000000000000&$select=productid&$expand=Product_SharepointDocument($select=sharepointdocumentid,fullname,absoluteurl,documentid,filetype),Product_SharepointDocument($top=1)
Is this a known limitation of the API, or am I doing something wrong with my queries?
Categories:
I have the same question (0)
All responses (
Answers (
