How to query table columns and types?

Hey there!

In my front-end I am having a few select-inputs for which the select options are the table columns. This is fine when the table has data, I could simply get the keys of the table object that Xano sends through a 'Get' API.

However, if a table has no data (no rows), then I am at a loss. There is nothing for me to fetch on my front-end, and when attempting to make a custom API for it in Xano I cannot find a way to return the field names / column names / keys of an empty table using the API functions.

Could someone please help me out?

Additionally, if there is an easy way to return these values, is it possible to query the field/column types as well (text,integer,json etc..)?

Thanks in advance!

1 reply