A few pieces are missing from the fivetran connector that have been keeping us from fully adopting it for quite a while.

CSAT responses - these are surveys associated with a ticket that are sent out when closed

https://api.freshservice.com/#view_csat_response

Ticket stats - these are additional details on a ticket that can be brought in with the api, in particular, we're looking for the resolved at and first responded times to use with SLA calculations

https://api.freshservice.com/#view_a_ticket

/api/v2/tickets/[id]?include=stats

SLA Policies - these don't change too often, but should indicate the timeframe something should be responded/closed based on the values in the ticket stats.

https://api.freshservice.com/#sla-policies