API Results in a Table

App Building
1

Hi folks,

New to API, so no doubt this question has probably been asked, but just in case. I've setup an API to pull data into a table. So far so good. The problem comes in, when the data is displayed in the table - it doesn't seem to split the data into the relevant columns and rows (screenshot 1) - UNLESS - I go down to a single record level, and then, the data will be displayed as it's needed (screenshot 2)

Any ideas as to how I can the data displayed for all records, as per the second screenshot?

Thanks.

Screenshot 1:

image
image2734×912 317 KB

Screenshot 2:

image
image2140×926 135 KB

2

Hello.

My suggestion is to use a transformer (Transformers) on the query to prepare the returned data in the format you need it in for the table.