Hi all, i'm trying to join tables using the REST api (postgrest resource embedding). Goal: get the projects.name and something.externalId in a single request. Tried: /rest/v1/projects?id='0805c7c6-ebdf-4d51-84fe-feaa50a17b05'&select=\*,something(externalId). Response: PGRST200 - could not find a relationship between projects and something in the schema cache. Question: how to join the table projects & something when the table workspaces is __not__ a join table. Thanks! any input is very much appreciated 🙂

Hello @unknown1337! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

fixed! https://postgrest.org/en/v9.0/api.html#nested-embedding

Thread was archived by @unknown1337. Anyone can send a message to unarchive it.