Using Clay API with HubSpot: Interpreting Contact Results

Does anyone have experience using Clay to look up contacts in HubSpot via API? I’ve successfully connected Clay to HubSpot and can send requests, but I’m struggling to understand how to read the results.

The API request returns a 200 status, but I’m unsure how to interpret the response.
I’m trying to check whether a contact exists in HubSpot using email or first & last name before proceeding with enrichment.

How can I translate the API response into something clear like:

"Contact exists"
"Contact does not exist"

Any help or insights would be greatly appreciated!

46 comments

Muhammad S.
·
·
You will get a list of contacts matching your filters via the api. If you click on 200, you should see records array containing the list of contacts that match your condition This indicates that a contact is present in HS or not. Summiya B. thoughts?
Muhammad S.
·
·
means no contacts are present in your HS that are matching the filters
Muhammad S.
·
·
This means you have found a match in your HS
Fabian G.
·
·
First of all, thanks!! But hwat if it says results for example 11? When I go look into the different results it says
Fabian G.
·
·
Achieved False..
Fabian G.
·
·
But I now the contact is in HubSpot
Fabian G.
·
·
Thats the result I am getting when doing it with email
Muhammad S.
·
·
Total: 11 means - You have 11 records in your HS that are matching the criteria Your filters are not right, they are too generic
Muhammad S.
·
·
can you share screenshot of your API call body?
Fabian G.
·
·
Email:
Fabian G.
·
·
Muhammad S.
·
·
there is an extra e right next to your email which is causing this issue
1
Fabian G.
·
·
Thanks, but the name is right? Because I am currently letting it double check with email and first/last name
Fabian G.
·
·
However I am still uncertain how to identify it with the name:
Muhammad S.
·
·
yeah that should be good
Muhammad S.
·
·
you can double check it by hardcording he name of a person that exists in your HS to see if it works just fine
Fabian G.
·
·
But what is telling me it exists?
Fabian G.
·
·
From the total 11 screenshot
Muhammad S.
·
·
yeah, it tells you 11 people exists
Muhammad S.
·
·
Click on results array and you will see details of those 10 people
Fabian G.
·
·
Still getting the same return..
Fabian G.
·
·
The 11 Results are not the Result I am looking for
Fabian G.
·
·
The first name only matches
Muhammad S.
·
·
{ "filterGroups": [ { "filters": [ { "propertyName": "firstname", "operator": "EQ", "value": "Hello" }, { "propertyName": "lastname", "operator": "EQ", "value": "World" } ] } ] } Try this body
🧵1
Fabian G.
·
·
Thank you so much
Fabian G.
·
·
ALso for email, I find the same results for all of them
Fabian G.
·
·
am I missing the "operator": "EQ", as well?
Fabian G.
·
·
Lets gooo - Thank you so much! The Name is already working now
Fabian G.
·
·
Thank you again. I got it for the other one as well.
Muhammad S.
·
·
great
Fabian G.
·
·
One last question - sorry to bother you, Do you know why sometimes it says Result = 1 but when I go into HS there is no result?
Muhammad S.
·
·
ideally it should, need to see that specific edge case to answer it
Fabian G.
·
·
It happens several times one second
Fabian G.
·
·
So I had to black out some parts... but I am getting all of this information and now when I take the email (or Name) whatever there is no contact in hubspot to it?
Fabian G.
·
·
Muhammad S.
·
·
this is not possible tbh
Muhammad S.
·
·
the data is being pulled from ypur HS
Muhammad S.
·
·
search the record id of contact in hs
Fabian G.
·
·
I should use this id right? There is no result in hubspt
Muhammad S.
·
·
yes
Muhammad S.
·
·
then you check if you are in the right HS instance
Fabian G.
·
·
omg that was so dumb got damn it
Fabian G.
·
·
sorry about that
Muhammad S.
·
·
😄
Muhammad S.
·
·
love it
Fabian G.
·
·