tap-hubspot
tap-hubspot copied to clipboard
singer-io
Detect contact deletion
For Deals there is an isdeleted flag but for Contacts there doesn't appear to be anything similar. How are we supposed to filter out contacts which have been deleted in Hubspot?
@esetnik After doing some further research on the HubSpot API it looks like the only way to get information about deleted contacts is via webhooks. Unfortunately, the Singer tap works via polling the REST APIs. I don't see any clear ways to get something like an isdeleted value from the REST APIs.
One solution would be to wipe out the data and periodically do a full resync of contacts. That wouldn't give you an isdeleted flag but would at least eliminate any deleted contacts from the result set.
@briansloane I figured it wasn't possible. Since you are polling the REST APIs it looks like there's no way to do this unless you had access to the previous run of sync data. I suggest anyone else who would also like to see this feature should leave a comment on this question on Hubspot developer forums.
Additionally after further reviewing the Hubspot REST apis I found that isDeleted for deals is actually not a valid property so it won't work as intended. I suggest that we remove it from the tap to avoid confusion.
"isDeleted": false,
// Boolean; Whether or not the record is deleted. In practice this will always be false as deleted records will not appear in the API.
@briansloane It hate to say it, but this is a major flaw in this tap. I know Hubspot is not making it easy for anyone to work with their api - but we need to figure out a way to get this built it in to this tap.
Does Stitch have some clout with hubspot to figure this out?
