# HubDB Get Joined tables with api

**URL:** <https://community.hubspot.com/t/hubdb-get-joined-tables-with-api/75209>\
**Category:** APIs & Integrations\
**Tags:** cms-content\
**Created:** [February 14, 2023, 8:56pm UTC](https://community.hubspot.com/t/hubdb-get-joined-tables-with-api/75209 "2023-02-14T20:56:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![EJacobson](https://avatars.discourse-cdn.com/v4/letter/e/cdc98d/32.png) [@EJacobson](https://community.hubspot.com/u/EJacobson)\
**Post date:** [February 14, 2023, 8:56pm UTC](https://community.hubspot.com/t/hubdb-get-joined-tables-with-api/75209/1 "2023-02-14T20:56:12Z")

</div>

Hi,

I have two HubDB tables that are linked by a Foreign ID column.

When I pull the data from one table using the HubDB api

(This endpoint: /cms/v3/hubdb/tables/{tableIdOrName}/rows)

it only pulls the table I am calling, including the foreign ids that are in the foreign id column. It returns the foreign id itself.

It doesn’t join the tables and pull the related data from the other table.

Is there an api that will allow me to get the joined table?

Thank you.

---

<div class="post-metadata">

**Author:** ![Jaycee\_Lewis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jaycee_lewis/32/61352_2.png) [@Jaycee\_Lewis](https://community.hubspot.com/u/Jaycee_Lewis)\
**Post date:** [February 15, 2023, 6:17pm UTC](https://community.hubspot.com/t/hubdb-get-joined-tables-with-api/75209/2 "2023-02-15T18:17:13Z")

</div>

Hi, @EJacobson 👋 Thanks for your question. Let’s see if we can get the conversation started — hey @Stephanie-OG @ChristinaKay @albertsg do you have any HubDB wisdom you can share with @EJacobson?

Thank you! — Jaycee