airbyte icon indicating copy to clipboard operation
airbyte copied to clipboard

[source-hubspot]append + deduped not marking as "archived" the deleted records

Open nimuriel opened this issue 1 year ago • 1 comments

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

nimuriel avatar Feb 08 '24 13:02 nimuriel

The records has archived set to true?

marcosmarxm avatar Mar 25 '24 21:03 marcosmarxm

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.

jtruty avatar Jul 11 '24 16:07 jtruty