Hi all - I'm very much new to Retool, but trying my best to learn! I was able to configure my resource correctly, but it looks like my API query response is formatted as JSON, so I know i need to turn the response into an array of values that can work with a table.
It looks like the SmartSheet API endpoint you are using only returns a single sheet object. A table is probably not the best way to display the data returned from the API in this case. Have you looked at the new Key/Value component? When you query for a specific sheet it'll display results like this:
If you can offload all of the sheet data to a Retool DB or your own local server then you would be better served by a table displaying that data, or you might want to use a List View component instead.