Auto Import Contacts from external database

CKnowles7 — Fri, 19 May 2023 13:41:10 GMT

hi,

I want to use an API call to pull contact data into Hubspot to fill in our "contact" table.

This inforamtion is currently stored on an external database that i have access to.

however im struggling on the hubspot side on how to set this up.

ive only seen options to import via csv manually.

Is there a way to do this autoamically?

Say every day/week where it will pull in the new records in our external DB and populate it in our HubSpot "Contacts" table?

thank you

Re: Auto Import Contacts from external database

Jaycee_Lewis — Sat, 20 May 2023 19:34:34 GMT

Hey, @CKnowles7 👋 Welcome to our community!

It will be helpful to know about the developer resources you have access to, as well as your level of comfortability with building something like this yourself. Or will you use a tool like Zapier, for example, to handle the connections?

Here is one high-level approach to consider:

Build a script or application that fetches data from your external database
Use the Contacts API endpoints to create or update Contacts
Set the script or application to run on a schedule
Include error handling and retries
Consider how you'll manage rate limiting

API you would use:

Contacts
Create a Contact — POST/crm/v3/objects/contacts
Update a Contact — PATCH/crm/v3/objects/contacts/{contactId}

Knowing more about your resources and possible limitations helps our community understand how they can assist you.

Best,

Jaycee

topic Re: Auto Import Contacts from external database in APIs & Integrations

Auto Import Contacts from external database

Re: Auto Import Contacts from external database