General Purge API?
I'm interested to know if there is a fast way to delete all records in a table when dealing with high record counts.
There is an unpublished API to Purge all records in a table. Basically all you do is like
mycompany.quickbase.com/xxxxxxxx?a=GenPurge
But that comes back to the screen for user interaction to "confirm".
The difference in performance when deleting all records in a table with high record counts between ?a=GenPurge and ?act=PurgeRecords is that the former will delete say 1 million records in a second, and the other is like watching paint dry, even when there are no relationships. It would take minutes to complete.
My question is does anyone know if there is syntax to run that ?a=GenPurge without the user interaction so it can be used in a URL formula button as I want chain to then reload the table with new data.
There is an unpublished API to Purge all records in a table. Basically all you do is like
mycompany.quickbase.com/xxxxxxxx?a=GenPurge
But that comes back to the screen for user interaction to "confirm".
The difference in performance when deleting all records in a table with high record counts between ?a=GenPurge and ?act=PurgeRecords is that the former will delete say 1 million records in a second, and the other is like watching paint dry, even when there are no relationships. It would take minutes to complete.
My question is does anyone know if there is syntax to run that ?a=GenPurge without the user interaction so it can be used in a URL formula button as I want chain to then reload the table with new data.