[HUBDB API] Get foreignid value instead of id

[Uther]

Hi,

i need to get the value from my foreignids, right now the HudDB API only returns the id and type field, if the field is foreign.

Is there a way to get the value from foreign fields?

Talking about this endpoint: "https://api.hubapi.com/hubdb/api/v2/tables/*/rows?portalId=*"

BR

[ben-duchy · Accepted solution]

It's not the method I use, but this may help you...

https://community.hubspot.com/t5/APIs-Integrations/HubDB-API-how-to-add-Foreign-ID-type-columns-to-t... 

[ben-duchy]

Hi @Uther,

Your link is not working so I'm unsure if this is what you're looking for.

When creating bespoke web modules that require 2 HubDB tables, this may help you...

{% set example = hubdb_table_rows(1234567) %}
{% for row in example %}

  <!-- Step 1: Setup foreign ID column in your main HubDB table and link in HubL -->
  {% for foreign_row in row.bridge %}
 
    <!-- Step 2: Specify the foreign column that you want to lift -->
    {{ foreign_row["column_name"] }} -->

  {% endfor %}

{% endfor %}

Hope that helps

Ben

[Uther]

Hi @BEN ,

the link was just an example of the api endpoint. i dont want to expose the portalId or the tableId here. 

I also cant use HubL and need to use the HubSpot API.

[ben-duchy · Accepted solution]

It's not the method I use, but this may help you...

https://community.hubspot.com/t5/APIs-Integrations/HubDB-API-how-to-add-Foreign-ID-type-columns-to-t... 

[Uther]

Its not exactly what i meant, i dont want to create foreign ids. I just want to receive the data from an HubDB Table. The rows dont display foreign values with thier value, instead they display the id of the value in the referenced table. My question was, if it is possible to receive the value with the same api call. 

[ben-duchy]

As I'm not familar with this, are you able to share the code you have (hiding the table / key information) ? It may help others to have a crack at it too.

[Uther · Accepted solution]

Hey, 

i found a solution which involes another api call:

/cms/v3/hubdb/tables/{tableIdOrName}

This Endpoint returns the details of the published table and with the parameter 

includeForeignIds

all foreign ID values will be populated.

So we can fetch the table details and get all of the foreign id values, after that we fetch all of our rows that we need and map the foregin ids with the values we received.

BR

[ben-duchy]

Excellent 👍

[Jaycee_Lewis]

Hi, @Uther 👋 Thanks for reaching out. Hey, @ben-duchy @BarryGrennan @Gonzalo, do you have any experience here? Thank you! — Jaycee