"Cannot deserialize the current JSON array ... " error when refreshing table

If you receive and error "Cannot deserialize the current JSON array ... " similar to the one below when attempting  to load of refresh a custom table, it is likely that the column preferences have become corrupted for that table. In order to reset the column preferences, please follow the steps below.

Resetting Column Preferences File

  • Press the Windows Start button, and in the search bar, type the following line and press Enter to open the Tables4Act configuration folder:

    %appdata%\Tables4Act\Layouts\

  • Inside this folder, you will find several files which are in the format: DatabaseName-TableName-ViewType-Columns.json
  • Find and delete the columns settings file for the database and table you are looking for.
  • Once deleted, attempt refreshing the table again.