Custom Object to Custom Object - join records retrieved from API

aawadhwa — Mon, 08 Aug 2022 22:45:06 GMT

Hello,

We are begnining to work with custom object to extend the capabilities, I have been able to create custom objects and retrieve the data that we put in it.

There is this case, however, where we have custom_object_2 associated with custom_object_1.

I use GET crm/v3/objects/custom_object_2&properties=name to get all the records with properties

The response returned looks like this

"results": [

{

"id": "2090784302",

"properties": {

"hs_createdate": "2022-08-04T20:53:06.993Z",

"hs_lastmodifieddate": "2022-08-04T20:53:06.993Z",

"hs_object_id": "2090784302"

"createdAt": "2022-08-04T20:53:06.993Z",

"updatedAt": "2022-08-04T20:53:06.993Z",

"archived": false

} ]

The above response doesn't contain any identifier which can be used to link it to the custom_object_1.

Does anyone know what parameters needs be passed where this API can return some identifier to associate the records of custom_object_2 with that of custom_object_1? Or is there any other way or exta API call that needs to be made?

Thank you in advance!

Re: Custom Object to Custom Object - join records retrieved from API

Teun — Tue, 09 Aug 2022 08:54:13 GMT

Hi @aawadhwa ,

You can call the associations endpoint to list all the associations for your current object. So in the case of 'custom_object_2' the URL could look something like this:

https://api.hubapi.com/crm/v3/objects/custom_object_2/2090784302/associations/custom_object_2?limit=500

Re: Custom Object to Custom Object - join records retrieved from API

aawadhwa — Wed, 10 Aug 2022 13:18:56 GMT

Thank you @Teun , this worked!

topic Re: Custom Object to Custom Object - join records retrieved from API in APIs & Integrations

Custom Object to Custom Object - join records retrieved from API

Re: Custom Object to Custom Object - join records retrieved from API

Re: Custom Object to Custom Object - join records retrieved from API