Magento 2.3 V1/Search with sortOrders not working in REST API

Question

Magento 2.3 Search Criteria with REST API, SortOrders not working in V1/Search API.

I am trying to fetch Category products using Magento REST API by below request URL.

http://127.0.0.1/magento230ee/rest/V1/search?searchCriteria[requestName]=quick_search_container&searchCriteria[filterGroups][0][filters][0][field]=category_ids&searchCriteria[filterGroups][0][filters][0][value]=4&searchCriteria[sortOrders][0][field]=name&searchCriteria[sortOrders][0][direction]=ASC

Using Above query I have to get the same result whether a name field is ASC or DESC Order in Query.

Only SortOrder is not working for the above query. How to apply sortOrders filter in product collection using the above query.

• fmsthird: did you try asc and desc ? I mean in small caps instead of all caps
• Rakesh Jesadiya: I have tried using ASC and DESC
• fmsthird: that's weird, have you tried DESC or both not working?
• Rakesh Jesadiya: None of working. Its not consideration for sortOrdres
• Ramkishan Suthar: I also faced this issue and found that magento sorts the result according to relevance value. At the end mobile team handled this at their end ; )

Answer 1

Please try with below api, I hope its working for you.

http://127.0.0.1/magento230ee/rest/V1/search?searchCriteria[requestName]=quick_search_container&searchCriteria[filterGroups][0][filters][0][field]=search_term&searchCriteria[filterGroups][0][filters][0][value]=Test&searchCriteria[sortOrders][0][field]=created_at&searchCriteria[sortOrders][0][direction]=DESC&searchCriteria[pageSize]=10

• Roshan Rakesh Yadav: I created custom API to update details but I want to update detail based on store code and store code is collected from payload any idea?