Empty table columns for Rest API call?

[mmays77]

Hi, relative noob here, running community version 2.32.3 self hosted on Linux 22.04. I hope this isn't a dumb question.

I have a data provider that is accessing a rest api query. The query is a custom python flask rest service that provides pivoted data, and it's working fine. I can pass query parameters that select the data rows to be displayed, by dates or value filters. I can slosh the data into different formats using pandas in the python rest server code, controlled by the parms.

For example, a rest query might provide a column for the month and the default pivot columns A, B, C, D, if no selection is made. These columns are configured in the rest query data section as text columns.

The user can select a parm that tells the rest query to only provide data for columns B and C in the Budibase query, and no data for columns A and D. When it does this, the table connected to the data provider shows all 4 columns, with columns A and D empty. No data are provided by the rest query to budibase for columns A or D. They are displayed as empty, rather than being omitted.

Is there a way to dynamically suppress the display of those empty columns in the data provider or table, based on the fact that no data for these columns are provided?

Thanks in advance for the help.