I need to insert rows to top of the table using api. So then i can get last one row with query as last row added to table that have specific column value. But as i see i can only add values to bottom and get only from top, so for big data it can be costly
Hi @Timofey_Bolgarin - Unfortunately the API doesn’t provide the ability to add rows to the top of a table, nor change the order of existing rows. Coda tables do have a natural sort order, but most often tables and views are sorted by a column value instead. You could consider adding a column that contains the date the row was added, and then sort on that column’s value (descending) to get the newest rows to appear at the top.