.png){kind=logo}
Enhancing HubSpot Search: Access Contacts by Any Property
Hello, it will be great to look up contacts and companies on Hubspot by any property, and not only email (for contacts), domain or ID (for companies).
Hello, it will be great to look up contacts and companies on Hubspot by any property, and not only email (for contacts), domain or ID (for companies).
In my case i also have Linkedin Org ID for companies so I can easily match the duplicates. And for contacts, if I pull a list of linkedin urls i have to enrich the mails before match them on Hubspot (bc its imposible to have the contact ID and i can't match them by the linkedin url). And here I have two problems:
I don't have the mail, or the same mail that i enriched on Clay. In this case I'll duplicate the contact.
I don't get the mail on Clay so there's no way to see if it's already on Hubspot or not
Hey, thanks for reaching out Daniel. Totally agree - That's something that can be done with the HTTP API. You can use any LLM to set up the Body if you want to change it but typically that would be like this: GET https://api.hubapi.com/crm/v3/objects/contacts/search Authorization: Bearer YOUR_ACCESS_TOKEN Content-Type: application/json { "filterGroups": [ { "filters": [ { "propertyName": "YOURPROPRIETY", "operator": "EQ", "value": "YOURPROPRIETY VALUE" } ] } ], "properties": ["PROPRITETY", "email", "firstname", "lastname"], "limit": 100 }
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
the link you have sent me does not take me to any site btw (https://api.hubapi.com/crm/v3/objects/contacts/search)
Hello Daniel! That is not a website link, it is an endpoint url for making a HTTP API call. An API call makes a request to a particular source. Often times, sources have different types of data and 'endpoint urls' are ways to ask for a particular type of data from a particular source. In this case, Bo described all the parameters to make an HTTP API call to a source using this enrichment: https://downloads.intercomcdn.com/i/o/w28k1kwz/1273410699/902f542cb8d7d2cbf8088efb4c86/CleanShot+2024-12-02+at+09_58_49.gif?expires=1733153400&signature=b1b2793ee00b1c8b1dc11f521c872f5d9a9157b524975f1c53cc9d60c367421c&req=dSIgFc1%2FnYdWUPMW1HO4zZZtpcNRE5iUfOd4iFLdN3AfXQKb01oavkQdyix%2B%0AAVZA%0A Let me know if you'd like me to help further in setting up the enrichment.
Hii Tomi, thanks for your help. I'm on the enrichment, but i still can't make it work
It will be so helpful if you could tell me more about how to run this properly
Got it. Do you mind sending the link to the table so I can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1733157000&signature=6c35de86316d109fa4f47884d6e53e8f841523d9d36bae73c65f651c69504a54&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSj9A5AW2BKsam%2FhVPt15g%3D%3D%0A
This column is almost set up. I added some more to the configuration, do you mind adding your hubspot API key here https://downloads.intercomcdn.com/i/o/w28k1kwz/1273561750/e3a0ea7822584dcb14fbe96ac862/CleanShot+2024-12-02+at+11_29_29%402x.png?expires=1733158800&signature=73bb74c329c953a57b949eb372dd62945f66f30d0316a365a889b11b041fedec&req=dSIgFcx4nIZaWfMW1HO4zTFgp%2BcZaECraymGitsOFsZ%2F7fCCHmlpQQZhwdF1%0A76kf%0A
It keeps giving me an error
No worries, I just wanted to further troubleshoot. It looks like I was able to get the proper set up, the first cell run successfully https://downloads.intercomcdn.com/i/o/w28k1kwz/1273598367/04367a6a5acb006daae9e375cdc9/CleanShot+2024-12-02+at+11_53_16%402x.png?expires=1733160600&signature=138de1bc85c2ab5ebf4611e1f63afe2c0b27bfb4f4e915d6cb7800b6e913df7d&req=dSIgFcx3lYJZXvMW1HO4zROFoCTR9Fpjl6ITPodTWl0Nljz%2B8Q2i5omd2uL9%0ApbbP%0A Feel free to run more cells and let me know if you reach the desired outcome.
Thank you very much Tomas! You are really helping me a lot. It seems to be working but it is not giving me anything back.
Hey Daniel! Quick check - was this search meant to return values? 1. Are you matching the right properties? 2. Are we looking for company contacts specifically? What's your end goal here? Let me know so I can help get this working right!
Hello Bo! Yes, It will be so helpful if it could give me back at least the company's husbpot id, and if i could do the same search with contacts and companys. Basically, what i'm trying is to keep clean my database giving to every contact and every company its unique linkedin ID, so I can match duplicates easier, than by comparing just the domain. So, if I have a new company list with its linkedin unique IDs, with this search i could look up for them on hubspot and give me back the Hubspot's ID
I think i found the problem, i was looking for companies and the endpoint said 'contacts'
Hey Daniel! Thanks for the message. Let me know if you're still experiencing any issue with your HTTP request. Happy to help✨.
