How do I sort, filter, or retrieve ordered records in the API?

To retrieve records in the same order as they appear in a specific table view, you can pass in the "view" parameter in the list records request (see the API docs).

Additionally, you can filter and sort records by passing in the "filterByFormula" parameter. See here for an example of this.