Working with Relationships & Foreign Keys

Heya!

I'm playing with Xano for the first time and here's the table structure with relationships.

Here's the function stack break-down

What I'm trying to do is, when the API endpoint /library_books is called by an authenticated user (who happens to be the library owner), I'd like only books that belong to the libraries that are owned by this users to be returned.

With the current setup, it returns all the books from all the libraries owned by all users.

Please let me know how to achieve this desired result in Xano.

Thank you

2 replies