You’re offline. This is a read only version of the page.
545
I am using following URL, api/data/v8.2/products?$expand=product_price_levels($select=amount&$filter=_uomid_value)
its giving me Error code as Found an unbalanced expression.
I tried with values of product & UOMID too, still the same
*This post is locked for comments
Inside the $expand, try separating the clauses with semicolons:
api/data/v8.2/products?$expand=product_price_levels($select=amount;$filter=_uomid_value)
Hi Ganesh,
the syntax of your query is wrong. In an expand query you can only use $select.
More Details here:
msdn.microsoft.com/.../gg334767.aspx
Your query would work with this URL:
/api/data/v8.2/products?$expand=product_price_levels($select=amount)
or this if you query by the product ID:
/api/data/v8.2/products(A54BB1D0-6BC0-E611-80F5-5065F38BD4F1)?$expand=product_price_levels($select=amount)
Results will have odata.nextLink properties:
Unless you specify a smaller page size, a maximum of 5000 entities will be returned for each request. If there are more entities that match the query filter criteria, a @odata.nextLink property will be returned with the results. Use the value of the @odata.nextLink property with a new GET request to return the next page of data.
Depending on what result you would like to get it might make more sense to completely change the URL query to query by the Price Levels on the product field via its ID.
Cheers,
Andreas
Unfortunately it is not possible to build OData query that will include expand on related entity and filter on it . Either you can reverse the query or
You work with Dynamics CRM 2016 new WebApi can use clear FetchXml for data querying. Recheck following articles:
debajmecrm.com/.../leverage-web-api-to-execute-your-system-views-personal-views-and-custom-fetchxml-in-dynamic-crm-2016 community.dynamics.com/.../execute-fetchxml-using-web-api-in-dynamics-crm-2016
#1
André Arnaud de Cal...
291,965
Super User 2025 Season 1
#2
Martin Dráb
230,817
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
