How to add data from an API object to a table, using transformer or anything else

so the "results" key has an array of Objects as your value.

This would work as columns in the table if the Objects contents are in the format of "Key" : "Value"

e.g {"Car" : "BMW", "Miles" : 1000, "Color" : "green"}

If this is not in this format, then you can use the transformer to format the data
The Transformer is JS Code

Here is documentation on transformers that would be of help

https://docs.retool.com/docs/transformers

http://community.retool.com/t/api-transformer-sql-query/13485/5