topic Re: Using Both Company / Contact Batch Read APIs in APIs & Integrations

Using Both Company / Contact Batch Read APIs

KLeswing — Mon, 26 Feb 2024 19:13:46 GMT

I am having an issue using the endpoint:

https://api.hubapi.com/crm/v3/objects/companies/batch/read

My problem is that using this simple JSON request:

{ "properties": [ "domain" ], "idProperty": "domain", "inputs": [ { "id": "aspencot.co.uk" } ] }

I always seem to get this response...

{ "status": "COMPLETE", "results": [], "numErrors": 1, "errors": [ { "status": "error", "category": "OBJECT_NOT_FOUND", "message": "Could not get some COMPANY objects, they may be deleted or not exist. Check that ids are valid.", "context": { "ids": [ "aspencot.co.uk" ] } } ], "startedAt": "2024-02-26T18:49:55.761Z", "completedAt": "2024-02-26T18:49:55.790Z" }

Now I checked the "hasUniqueValue" property of the domain property of the customer and it is presently set to false. Reading a different post here on the forums, it appears that in order for me to use this endpoint with that 'idProperty' within the JSON request that this attribute needs to be set to true. (I checked the object using the properties API).

HOWEVER, I can successfully use the same batch read contact API endpoint below with the email id property where the "hasUniqueValue" is false and get a successful response when passing the email address in the inputs array.

https://api.hubapi.com/crm/v3/objects/contact/batch/read

Is there something else here I am missing in a configuration with HubSpot to turn on the ability to search a company object by domain and/or name?

If my only possible way of doing this is to set the 'hasUniqueValue' attribute to true, what are the existing rammifications to my data already captured in the 60K company records I have in HubSpot?

Any guidance here is greatly appreciated.

Re: Using Both Company / Contact Batch Read APIs

hli6 — Tue, 27 Feb 2024 06:38:47 GMT

What is the maximum capacity of this batch of calls at one time?

Re: Using Both Company / Contact Batch Read APIs

GRajput — Tue, 27 Feb 2024 08:54:37 GMT

Hi @KLeswing

To read the company use the following API curl, where hs_object_id

reference - hs_Object_id = company_id

curl --location 'https://api.hubapi.com/crm/v3/objects/companies/batch/read?archived=false' \ --header 'authorization: Bearer ACCESS TOKEN' \ --header 'content-type: application/json' \ --data '{ "idProperty": "hs_object_id", "inputs": [ { "id": "1234567" } ], "properties": [ "domain" ] }'

To read the contact use the following API curl,

curl --location 'https://api.hubapi.com/crm/v3/objects/contacts/batch/read?archived=false' \ --header 'authorization: Bearer ACCESS TOKEN' \ --header 'content-type: application/json' \ --data '{ "idProperty": "email", "inputs": [ { "id": "email address" } ], "properties": [ "email","firstname","lastname" ] }'

I hope this will help you out. Please mark it as Solution Accepted and upvote to help another Community member.
Thanks!

Re: Using Both Company / Contact Batch Read APIs

KLeswing — Tue, 27 Feb 2024 15:20:44 GMT

@hli6 I am only making one batch call at a time looking to pass one domain value to find the one company object.

Re: Using Both Company / Contact Batch Read APIs

KLeswing — Tue, 27 Feb 2024 15:22:42 GMT

@GRajput Thank you for your two examples but I need the ability to find the Company object (hs_object_id) by passing the domain name to the batch read; not the other way around. And, when I try by using the aforementioned JSON structure where I am passing the domain and setting the idProperty : "domain". I get nothing.