Get records by view, but records with wrong order are returned

I use the following request to get list of records by view.
In this view, records are sorted by id DESC.
But the API returned list of records, which are sorted by id ASC
https://api.airtable.com/v0/mybasekey/mytable?api_key=my_key&view=my_view

This problem just happened in today.

Please help me to resolve this problem.

3 Likes

We, here, have the same problem. Urgent situation.

3 Likes

Hi there,

I can support what has been flagged above - I have the same issue. Please advise on a solution - this is REALLY important for our users considering that some apps are built on data viewer based on Airtable. Thanks!

3 Likes
2 Likes

Hi there, I think this issue arose earlier today. Just like everyone else this is super urgent… Very unexpected. Did anyone find a fix for this?

  • Dirty Fix:
    1. Create a new column, name it “Order Name” or something like that
    2. Sort the view into desired order
    3. Change the column to AutoNumber
    4. Now you can sort the view by the AutoNumber through the API
    5. This is obviously not a long-term fix and not scalable, but might address some people’s issues
  • This seems to be a core Airtable API issue.
  • The API returns records by a record’s created_date regardless of the View’s sorting order.
  • Filtering by view still works (only items visible in the View will appear in the data)
  • Using ‘sort’ with the API still works, meaning we can still sort by Asc / Desc
1 Like

Hi everyone, this should now be resolved. We detected the issue and made the fix on April 12, 2021. Thank you for the reports, and please let us know if you continue to see issues here.

Thanks,
Richard

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.