Solved

Through web api not able get vendor order by LastModifiedDateTime.

  • 31 July 2023
  • 2 replies
  • 59 views

Through web api not able get vendor order by LastModifiedDateTime.

icon

Best answer by Leonardo Justiniano 31 July 2023, 16:23

View original

2 replies

Userlevel 7
Badge +11

Hi @DharmandarKumar 

The API result set returned by the data view is always sorted by the 'OrderBy' clause specified in the type of the data view object.

If you wish to sort the data differently, you can create a simple Generic Inquiry (GI) with the desired sort order. Then, create a custom endpoint for the GI and use a GET call. This way, you will receive the data according to your specific request and sorting preference."

Userlevel 6
Badge +4

Hi @DharmandarKumar 

 

You can leverage using OData V4 which allows you to set OData filtering and sorting clauses:

https://<site>/odatav4/<instance>/Vendor?$skip=0&$top=10&$orderby=LastModifiedDateTime desc

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved