web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / O Data Expand & Fi...
Microsoft Dynamics CRM (Archived)
Suggested Answer

O Data Expand & Filter

(0) ShareShare
ReportReport
Posted on by ganesh198715 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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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

  • Suggested answer
    Andreas Cieslik Profile Picture
    Andreas Cieslik 9,267 on at

    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

  • Suggested answer
    manuel_rdza Profile Picture
    manuel_rdza 5 on at

    Inside the $expand, try separating the clauses with semicolons:

     api/data/v8.2/products?$expand=product_price_levels($select=amount;$filter=_uomid_value)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Varsha deshpande Profile Picture

Varsha deshpande 5

#2
JS-09031509-0 Profile Picture

JS-09031509-0 3

#3
Ciprian P Profile Picture

Ciprian P 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans