I am using AEM Forms and connecting form elements to Microsoft Dynamics 365.
I use the Form Data Model to create API endpoints to connect with the specific Dynamics 365 entities I am interested in.
The problem I am facing is that the data returned from a Dynamics 365 entity is not in the order I require. The data coming back has a default sort order by created date; I need the data sorted alphabetically to populate a drop-down list.
The APIs in Microsoft Dynamics 365 allow for an Order By parameter; however, I do not know how to specify the Order By parameter in the Form Data Model API. The Form Data Model API allows for a filtering parameter but I cannot seem to get an Order By parameter to work.