topic Re: [HUBDB API] Get foreignid value instead of id in APIs & Integrations

[HUBDB API] Get foreignid value instead of id

Uther — Mon, 05 Dec 2022 16:23:58 GMT

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=*"

Re: [HUBDB API] Get foreignid value instead of id

Jaycee_Lewis — Tue, 06 Dec 2022 19:21:27 GMT

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

Re: [HUBDB API] Get foreignid value instead of id

ben-duchy — Wed, 07 Dec 2022 09:52:10 GMT

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 %}  {% for foreign_row in row.bridge %}  {{ foreign_row["column_name"] }} --> {% endfor %} {% endfor %}

Hope that helps

Ben

Re: [HUBDB API] Get foreignid value instead of id

Uther — Wed, 07 Dec 2022 10:04:41 GMT

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.

Re: [HUBDB API] Get foreignid value instead of id

ben-duchy — Wed, 07 Dec 2022 10:13:03 GMT

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-table/m-p/554675

Re: [HUBDB API] Get foreignid value instead of id

Uther — Wed, 07 Dec 2022 10:17:03 GMT

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.

Re: [HUBDB API] Get foreignid value instead of id

ben-duchy — Wed, 07 Dec 2022 10:38:32 GMT

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.

Re: [HUBDB API] Get foreignid value instead of id

Uther — Wed, 07 Dec 2022 14:39:35 GMT

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.

Re: [HUBDB API] Get foreignid value instead of id

ben-duchy — Thu, 08 Dec 2022 09:05:51 GMT

Excellent 👍