topic Re: How do I get the Company ID by searching by Company name? in APIs & Integrations

How do I get the Company ID by searching by Company name?

Bronette — Thu, 25 Apr 2024 14:42:13 GMT

I'm trying to get a Company Id via searching by Company name via so I can add Company engagement notes however; when I query the companies search object API via the name, it just returns individual contact objects for that company and NOT the company actual company ID.

I am using the API:

https://api.hubapi.com/crm/v3/objects/companies/search

My search query looks like this:

{ "filterGroups": [ { "filters": [ { "propertyName": "name", "operator": "EQ", "value": "McChicken Inc" } ] } ] }

What I get is an array of indiviudal "contact" objects related to that particular comapny and NOT the company ID. The response looks like this:

This is just a contact for that company. If I search in Hubspot (UI) with that ID, it's just the contact object. The "hs_object_id" is just the contact ID. There is NO company ID in there.

{ "id": "122253", "properties": { "createdate": "2022-01-29T00:37:01.894Z", "email": "jim_bob@mcchicken.com", "firstname": "Jim", "hs_object_id": "122253", "lastmodifieddate": "2023-04-11T15:48:24.009Z", "lastname": "Bob" }, "createdAt": "2023-01-29T00:27:01.894Z", "updatedAt": "2023-04-12T12:48:24.009Z", "archived": false }

How do I get the company ID??

Re: How do I get the Company ID by searching by Company name?

Jaycee_Lewis — Thu, 25 Apr 2024 17:07:30 GMT

Hey, @Bronette 👋 Are you using Postman to test with? You might try again from scratch. I used your request body and created a matching company and associated contact in my test portal. When I test using Postman, I get the expected result.

Example:

Company + Contact

Request

POST https://api.hubapi.com/crm/v3/objects/companies/search

Body

{ "filterGroups": [ { "filters": [ { "propertyName": "name", "operator": "EQ", "value": "McChicken Inc" } ] } ] }

Response

{ "total": 1, "results": [ { "id": "20461937810", "properties": { "createdate": "2024-04-25T16:33:48.608Z", "domain": null, "hs_lastmodifieddate": "2024-04-25T16:34:56.068Z", "hs_object_id": "20461937810", "name": "McChicken Inc" }, "createdAt": "2024-04-25T16:33:48.608Z", "updatedAt": "2024-04-25T16:34:56.068Z", "archived": false } ] }

Postman

I hope this helps get you moving forward. — Jaycee

Re: How do I get the Company ID by searching by Company name?

Bronette — Fri, 26 Apr 2024 13:01:14 GMT

It was in fact working. I had the call in a Python script and I was calling the wrong URL because I had two functions of the same name. User error on my part. Thank you for replying and verifying.

Re: How do I get the Company ID by searching by Company name?

Jaycee_Lewis — Fri, 26 Apr 2024 15:22:40 GMT

Awesome. Thanks for the update, @Bronette! Have a great weekend. — Jaycee

Re: How do I get the Company ID by searching by Company name?

GSkidmore — Fri, 31 May 2024 04:30:55 GMT

This helped as I also was using a mis-typed URL.

I had the v2 url and simply replaced v2 with v3 and had this bad url

https://api.hubapi.com/companies/v3/objects/companies/search

when it should be as you noted and I know from the examples:

https://api.hubapi.com/crm/v3/objects/companies/search

So, using curl to get company ID from propertyName used the following command

Also, thought back to a previous post to use \" to delimit and pass a doublequote..

curl.exe -X POST "https://api.hubapi.com/crm/v3/objects/companies/search/" -H "authorization:Bearer myTokenHere" -H "Content-Type: application/json" -d "{\"filterGroups\":[{\"filters\":[{\"propertyName\":\"gss_company_code\",\"operator\":\"EQ\",\"value\":\"ASPDUN\"}]}]}" -o F:\Users\mypath\Documents\Consulting\ZHL\Hubspot\Company_byAcct_ASPDUN.json