Request for Review of Table and HubSpot Column Errors | Clay

Request for Review of Table and HubSpot Column Errors

Could you please help me review this table? https://app.clay.com/workspaces/10839/workbooks/wb_0sxomo0vx9mkD8DBdp9/tables/t_0sxoqc9iwRTBwqu3QZc/views/gv_0sxoqcaPRau9moXZXs3 I mapped the field i want to enrich but it still gives me error in the hubspot colums. Thanks in advance

25 comments

Channeled
APP
·
·
There could be several reasons for HubSpot column errors: 1. If you're using a lookup column, make sure you're using the HubSpot Record ID as input for your Update Object enrichment rather than another identifier like LinkedIn URL. 2. You might be experiencing a "failed to parse body" error if there's incorrect formatting in your data. Could you copy and paste the exact error message or the JSON you're using so I can help troubleshoot further?
Sources: HTTP API integration overview | Documentation | Clay University HTTP API with JWT authentication | Documentation | Clay University FAQ: Why am I seeing the "failed to parse body" error when using the HTTP API enrichment?
Muhammad S.
·
·
whats the error?
Ticiana G.
·
·
Muhammad S.
·
·
Can you click on error and share screenshot?
Ticiana G.
·
·
Muhammad S.
·
·
In the update column you will need to provide atleast 1 field which you want to update, currently its empty.
Ticiana G.
·
·
where should i add it?
Muhammad S.
·
·
Follow the steps
find the object first - before updating anything, you need to locate the specific object in hubspot
do a lookup using unique identifier - search for the object using a unique property like:
email address (for contacts)
company domain (for companies)
deal name (for deals)
get the unique id - when the lookup is successful, hubspot will return a unique id number for that object
use the id for updates - take that unique id and put it in the "hubspot object id" field
update the field - now you can modify any property/field for that object
example with contacts:
search contact by email → get unique contact id → use id to update contact fields
this ensures hubspot knows exactly which object you want to modify instead of creating duplicates or updating the wrong record.
Ticiana G.
·
·
find the object first - before updating anything, you need to locate the specific object in hubspot
what is it meant by object? a list?
Muhammad S.
·
·
Nope, Object is a deal, contact, company etc.
Ticiana G.
·
·
isnt that mapped here already?
Muhammad S.
·
·
You need to find the contact ID of the contact you want to update
Ticiana G.
·
·
I still get error
Muhammad S.
·
·
Great, you told hubspot which contact to update but you still need to specify what property to update for that contact?
Ticiana G.
·
·
correct
Ticiana G.
·
·
where can i do that?
Muhammad S.
·
·
right below the object ID, you are seeing all the fields that you can update
Ticiana G.
·
·
It does not show a column, I wrote First name last time and it created a mess updating the first name to 'First name'
Ticiana G.
·
·
what should I write there?
Ticiana G.
·
·
I think I found out, I need to type /
Ticiana G.
·
·
and it shows the column
Muhammad S.
·
·
sweet
Ticiana G.
·
·
thank you
Bo (.
·
·
Hey, thanks for the help here!!! :) Looks like it ended up being fixed. Let me know if you have more questions.
Ticiana G.
·
·
all good thanks a lot!:)