How to update Contacts from SQLServer


#1

I have users database in SQLServer, and I want to import into my Hubspot Contacts directory with basic info (name, email, phone) each time a new user is added to the database. What is the best way to achieve this? Using the POST contacts/v1/contact/createOrUpdate/email/testingapis@hubspot.com/?hapikey=demo looks like a good start but i'm unsure how to proceed from there, any advice would be appreciated!


#2

Hi @Gautum_Suresh,

You'll need to write some middleware that takes new records from your SQLServer, formats them correctly, and then POSTs them to HubSpot. you'll also need to host this middleware somewhere. There are a number of resources out there related to spinning up lightweight services that can make requests like this. If you have any HubSpot-specific questions going forward, I'm happy to help out!