Budibase does not return all columns if some fields are empty

[gravyplaya]

Checklist

• [X ] I have searched budibase discussions and github issues to check if my issue already exists

Hosting
Self-hosted - Docker - Budibase latest version

Describe the bug
Budibase does not return all columns if some fields are empty.

To Reproduce
Steps to reproduce the behavior:

1. Go to database and see there are values in the Outcome column
2. Switch to design view and output the rows on the screen. Notice no Outcome value exists.

Expected behavior
Outcome column and values should exist

Screenshots
Outputted json data (page search for "Outcome" returns no results)
<< Screenshot removed because it contained private info >>

View from design screen (Note the Outcome values)

Desktop (please complete the following information):

• MacOS, Chrome

[linear]

BUDI-8915 Budibase does not return all columns if some fields are empty

[hilton]

I’m experiencing what sounds like the same behaviour, but with a different cause, because none of the missing columns’ values are empty. Maybe the component isn’t using the query’s transformer as expected.

Reproduce:

1. Create a new app
2. Add a REST API data source, with a query for GET https://cdn.githubraw.com/Juriy/swapi/refs/heads/master/resources/fixtures/films.json
3. In the query, add a transformer return data.map(film => film.fields)
4. Save the query
5. In the Design view, add a Blank screen
6. On the new screen, add a Table component, and set the Data to the query saved in step 4

Expected:

• Table component has the columns that are enabled in the table configuration sidebar

Observed:

• The sidebar lists the expected columns, but the table component only includes the pk column values

[mikesealey]

Hey @gravyplaya could you just go over the steps to reproduce?

From what you've discussed in the overall report I've tried to recreate but been unable to. Please provide more detailed steps to reproduce, and if possible, an app-export of the issue happening.

[gravyplaya]

Hey @gravyplaya could you just go over the steps to reproduce?

From what you've discussed in the overall report I've tried to recreate but been unable to. Please provide more detailed steps to reproduce, and if possible, an app-export of the issue happening.

Steps to reproduce is in the OP.