Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Connector Improvement: Capture deletes for Help Scout customer_website_history table

Answered
Dylan Ray User

Capture deletes for customer_website_history table. And any/all others, if possible. Deleted data is important for auditing, so being able to capture this data (or lack thereof), is an important component of the connector and adds business value.

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Ray User

    Hi Dylan,

    This should be possible today. History tables capture deletes via a record's absence at a given datetime. So for example, if you query for records at midnight, March 15, 2022, anything that doesn't show up can be considered deleted at that time.

    select * from customer_website_history
    where '2022-03-15' between _fivetran_start and _fivetran_end

    If you want to write a query that returns what records looked like before they were deleted, you'll need to do something a little more complex. To do that, you'll want to fetch the latest version of each record and filter for only the inactive records.