[source-hubspot]append + deduped not marking as "archived" the deleted records
Connector Name
Hubspot - BigQuery
Connector Version
0.50.33
What step the error happened?
During the sync
Relevant information
I have been testing the "archived" field from engagements_meetings stream, I have created some meetings and deleted them after a couple of hours.
The records are loaded, but then they're not marked as archived when I delete them.
Relevant log output
No response
Contribute
- [ ] Yes, I want to contribute
The records has archived set to true?
I see this as well, archived records in hubspot don't trigger an update in the associated airbyte incremental stream. I imagine this is because they aren't returned by the api search used to find updated records (this looks like a hubspot limitation), so the only way to actually get at them once they are deleted is to use the deals_archived stream. To workaround this issue, I have had to cross check the deals_archived records after a sync.