MS CRM OData Query Order By Desc not working [SOLVED]
Yeah, I am still working on the CRM application that needs to communicate with T24 core banking application. It's being lovely until I needed to order the results queried from CRM endpoint in descending order. I tried everything possible with what was provided in the documentation but was getting no results.
Below is what the documentation specified we do to get our result in descending order:
/OpportunitySet?$orderby=ActualCloseDate desc
After so much trial, I realised to get this to work you need to add the encode symbol of space not just a blank space. It would work this way below:
/OpportunitySet?$orderby=ActualCloseDate%20desc
Hope this helps someone grealty.