Views:

Applies to Product – Microsoft Dataverse


What’s happening?
The Suggest and Query APIs are not functioning as expected when multiple entity names are included in the request body along with filters. The APIs return records that do not align with the provided search text and filters.


Reason:
This appears to be related to how filters are applied when querying multiple entities. It may be due to the filter attribute being different across entities or the way the filter is constructed.


Resolution:

  1. Ensure that the filter is applied correctly for each entity. 
  2. If the above filter does not yield the expected results, try the following:
    • Check if the API query works as expected with a single entity.
    • Test the API query by passing the filter as null ("filter": null) to see if it returns the expected results.
    • Verify if the attribute is present on both the account and contact entities.
Refer to the documentation for proper filter usage: Filter String Documentation.