When working with nested data, the structure each service returns will often be unique and difficult to universally apply code examples to. @Bill_Waring if you are able to provide some examples of what the data structure looks like (the left panel opened in the top middle of the editor, is really useful for visualizing the data inside components) and any errors you're getting in trying to apply the examples to we can help debug from there!
I'd like to know the same thing as I wish I knew of this limitation before signing up. No queries or transformers I have tried work. I use this same API in other systems and it doesn't have this issue only retool does.