When viewing the Appsheet Database, there are empty rows. However, when the same table is extracted using Appsheet API, using the same account for the credentials, the supposed empty rows have the expected data.
I’d call that a bug. Please report to Support.
Thanks @Steve,
@ralph.christian, I must clarify that standard Support is technically unavailable for users on Free licenses, I agree though that coordinating with them is the most effective way to get your query resolved.
Just to confirm, are you using [_RowNumber] as the KEY column for your table?
No, I use [Primary Key] as the key for my table.
Update: I have contacted customer support, apparently it was a cache issue. I restarted my browser and saw all the records fine.
Thank you for all the response !!