Example 1:

Request for filter query having Select and Order By clause

[APIM URI]/datainsights/odata/dbo_Activity?$filter=contains(ActivityList, 'Tlst2')&Select=ActivityID,ActivityList,Code&Orderby=Code desc