Company
Date Published
Author
Lukas Schwab
Word count
1839
Language
English
Hacker News points
None

Summary

Sequin offers a solution for developers looking to integrate HubSpot data with their Postgres databases, which can be challenging due to HubSpot's Webhooks API limitations. Webhooks are useful for subscribing to events without exceeding API rate limits but have drawbacks, such as limited retries and insufficient event coverage for certain CRM objects. HubSpot's Webhooks API only supports Contacts, Companies, and Deals, leaving out other CRM types and custom objects, and each subscription tracks only one property change, necessitating additional polling for comprehensive updates. Workflows, while offering broader object support, are not a full replacement for Webhooks due to their limitations and enrollment restrictions. An alternative approach is optimized polling using HubSpot's CRM search endpoints to manage data changes without exceeding rate limits, though this can miss intermediate updates. Sequin simplifies these processes by handling the complexities of syncing HubSpot data to Postgres, including managing cursors, rate limits, and schema conversion, allowing developers to maintain up-to-date data without the need for extensive manual configurations.