Loading...

Expanding Lookup and filtering based on a value in related Entity - Web API roadblock

Expanding Lookup and filtering based on a value in related Entity - Web API roadblock

If you're looking to expand lookup and filtering based on a value in a related entity, this tutorial might be helpful. However, the author encountered a roadblock while achieving this through Web API, and had to use fetchxml to get the expected output. The author posted about this issue on Stack Overflow and raised a Github issue. Microsoft provided active support for their queries and confirmed it as expected behavior. In summary, the scenario involves getting all the Entity A records with an expected attribute value (filter) in related Entity B lookup, and it should work in a way like INNER JOIN, to filter out Entity A records with blank lookup. However, the result turns out to be LEFT OUTER JOIN, and even blank records without filter attribute value are returned. The post provides the Web API Query and both the expected and actual output. But they note that Web API endpoint cannot help in this case and instead you should use fetchxml for getting this expected output.

Published on:

Learn more
Arun Vinoth @ Dynamics
Arun Vinoth @ Dynamics

Share post:

Related posts

Query Data Using Web API

If you're looking to leverage web APIs to query data, this post is a great place to start. In this article, you'll explore how to use web APIs...

2 years ago

SQL OUTER JOIN: Detailed Guide With Examples

SQL is the universal language of databases and is crucial for combining data from multiple tables in a relational database to gain valuable in...

11 months ago

Dynamics CRM Web API C# Auto Refresh Access Token while performing API request to CDS

If you're working with Dynamics CRM Web API in C# and accessing it from your application, you might run into the issue of your access token ex...

1 year ago

Power Pages WEB API | Perform CRUD Operation in Dataverse using Power Pages WEB API | Portal WEB API

Learn how to perform CRUD operations in Dataverse using the Power Pages WEB API in this informative tutorial. The Power Pages WEB API is an es...

1 year ago

How to ⟕ Left Join SharePoint Lists?

If you have been wondering how to left join SharePoint lists, this YouTube video tutorial can be your guide. The video discusses the step-by-s...

1 year ago

Tag and Shared Variable Custom Values in Web Api Plugins

If you're working with Dynamics 365 Power Apps Web API and need to pass along a custom value with the request, this tutorial is for you. For i...

1 year ago

GET THE WEB API URL FOR A DYNAMICS 365 ORGANIZATION

If you need to retrieve the Web API URL for your Dynamics 365 organization, you're in the right place. This post provides quick and easy-to-fo...

2 years ago

Working web api endpoint & payload for RetrieveEntityRibbon CRM function

If you have ever faced issues working with the CRM web API to get the proper endpoint and payload, you are not alone. The documentation can be...

2 years ago

What's The Deal with Schedule API? (Dynamics 365 Project Operations)

Want to explore the Schedule API in Dynamics 365 Project Operations? This post provides an in-depth look at the inner workings of Schedule API...

2 years ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy