[View:/cfs-file/__key/communityserver-discussions-components-files/758/Incorrect_5F00_SO_5F00_Response_5F00_BC.json:320:240]
Hi All,
The standard Salesorder API is returning an incorrect response with duplicate data along with incorrect ordering than what is requested in the query parameter
https://api.businesscentral.dynamics.com/v2.0/Production/api/v2.0/companies(c444da1c-c2b7-4e53-80ce-e3ecb21de4dc)/salesOrders?$filter=lastModifiedDateTime ge 2023-02-09T09:35:19Z&$orderby=lastModifiedDateTime+asc&$top=1000&$skip=0&$expand=salesOrderLines($filter=lineType eq 'Comment' or lineType eq 'Item' or lineType eq 'Account';$orderby=sequence)
I noticed that this behavior only happens in a handful of times a day. I tried sending the same request via the postman a few times continually, and to my surprise the response was correct now. Seems to have something with caching I think.
Response is attached for reference.
Have anyone experienced this issue as well?
Does anyone have thoughts on it?
