API Results in a Table

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?


Screenshot 1:

Screenshot 2:


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.