topic Re: HubDB API - Add Row With Foreign Key in APIs & Integrations

HubDB API - Add Row With Foreign Key

SirHubalot — Tue, 12 Jan 2021 12:48:05 GMT

Hi,

I have been working quite alot in implementing Hubspots API in sending data to my HubDB tables. I have come across an issue where one of my table fields is a Foreign Key.

I can't find anywhere in the documentation what the value type is for the response when sending it to the API. The Create row endpoint list all field types minus a Foreign key: https://legacydocs.hubspot.com/docs/methods/hubdb/v2/create_row

Is this something the API cannot do? If it can, I would be grateful for an example.

Re: HubDB API - Add Row With Foreign Key

dennisedson — Tue, 12 Jan 2021 19:15:26 GMT

Hello @SirHubalot

I believe the question @DavidFJones asked is what you are also asking. @WendyGoh provided an answer.

Re: HubDB API - Add Row With Foreign Key

SirHubalot — Mon, 18 Jan 2021 18:03:49 GMT

Hi dennisedson.

That was one of the first posts I saw but that didn't help me. But I managed to find the solution. All I needed to do was to send over my foreign keys to my table column in the following JSON Structure:

[ { id: 123456789, type: "foreignid" }, { id: 988765434, type: "foreignid" }, { id: 4645645644, type: "foreignid" } ]

Re: HubDB API - Add Row With Foreign Key

skylightipv — Thu, 20 Jul 2023 09:13:10 GMT

I'd be interested to know if you had the same issue as I have when inserting a foreign id via API

https://community.hubspot.com/t5/APIs-Integrations/HUBDB-foreign-ID-insertion-via-API-doesn-t-work/m-p/816774#M65489