This is a sample app for the hubspot-python SDK. Currently, this app focuses on demonstrating the functionality of Webhooks API, contact creation/deletion in particular.

Please note that the Webhooks events are not sent in chronological order with respect to the creation time. Events might be sent in large numbers, for example when the user imports large number of contacts or deletes a large list of contacts. The application demonstrates the use of Queues (Kafka in case of this application - see kafka.py) to process webhooks events. Common webhook processing practice consists of few steps:

1. Handle methods receive the request sent by the webook and immediately place payload on the queue handle.php
2. Message consumer instance(s) is running in a separate process, typically on multiple nodes in a cloud, such as AWS
3. Consumer stores webhook events in the database potentially calling an API to get full record of the object that triggered the event
   • This application uses MySQL, SQLAlchemy ORM
4. Other services/objects fetch the events data from the database sorted by timestamp of the event

Please see the documentation on Creating an app in HubSpot

HubSpot Public API links used in this application

• Read a batch of contact objects by ID

Note on the Data Base

This application uses MySQL database to store the events coming from Webhooks. There is a single events table:

create table if not exists events
(
    id              INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    event_type      VARCHAR(255),
    object_id       int             default null,
    event_id        bigint          default null,
    occurred_at     bigint          default null,
    property_name   varchar(255)    default null,
    property_value  varchar(255)    default null,
    created_at      datetime        default CURRENT_TIMESTAMP
);

Please note that event_id sent by HubSpot needs to be stored as int

Setup App

Make sure you have Docker Compose and Ngrok installed.

Configure

1. Copy .env.template to .env
2. Paste your HUBSPOT_CLIENT_ID, HUBSPOT_CLIENT_SECRET, HUBSPOT_APPLICATION_ID and HUBSPOT_DEVELOPER_API_KEY

Running

The best way to run this project (with the least configuration), is using docker compose. Change to the webroot and start it

docker-compose up --build

Copy Ngrok url from console. Now you should now be able to navigate to that url and use the application.

NOTE about Ngrok Too Many Connections error

If you are using Ngrok free plan and testing the application with large amount of import/deletions of Contacts you are likely to see Ngrok "Too Many Connections" error. This is caused by a large amount of weebhooks events being sent to Ngrok tunnel. To avoid it you can deploy sample applications on your server w/o Ngrok or upgrade to Ngrok Enterprise version

HubSpot Signature

To help improve security, HubSpot webhooks are sent with signature so you can verify that it came from HubSpot. This sample application shows how to do that verification. You can read more about validation in general here: https://developers.hubspot.com/docs/api/webhooks/validating-requests. The source code for validating webhooks is at hubspot\utils\webhooks and an usage example.