Sorting by idVisit doesn't seem to work properly

General questions
1

Can someone explain to me why this might happen? I’m attempting to sort my visits by idVisit which is an auto-incrementing integer. I’d assume I should get the records back in the correct order, the filtering params I’m using are:

  • filter_sort_column=idVisit
  • filter_sort_order=asc
  • filter_limit=10

Here’s the call I’m making and the output from jq. Note 2594 is definitely out of order

curl 'https://my.matomohost.com/index.php?module=API&format=JSON&idSite=1&period=day&date=today&method=Live.getLastVisitsDetails&expanded=1&format_metrics=1&translateColumnNames=1&language=en&token_auth=abcd&filter_sort_column=idVisit&filter_sort_order=asc&filter_limit=10&filter_offset=0' \
| jq '.[] | .idVisit'

"2595"
"2596"
"2597"
"2598"
"2594"
"2599"
"2600"
"2601"
"2602"
"2603"