Recently we had an issue while trying to Query Retrieve Multiple for (Audit Entity) ,
Error Message: ” Expected value between 1 and 1 inclusive”.
Root Cause: Microsoft has moved Audit table to Cosmo DB, due to which Distinct & Aggregate, Group by function are no more supported from retrieve multiple query.
Fix: Remove distinct , aggregate , group by in your retrieve multiple query will resolve your issue.
Hello Parthiban.. Hope you’re well.. can you share the resolution code for this.