HelpScout
Helpscout ETL connector for data replication
Snapshot
Features
Details
Release Status
Released
Source API Version
v2
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Helpscout Email Helpscout password
Replication Type
Key based Replication
Replication Key
DATE
Suggested Replication Frequency
24 hrs
Tables/APIs Supported --- | --- Conversations | Customers Tags | ConversationsReceivedMessages ConversationsDrilldownReport | CompanyOverallReport ConversationsVolumesByChannelReport | DocsOverallReport CompanyConversationsReport | CustomerHappinessOverallReport ProductivityOverallReport | ConversationsOverallReport Users | Emailreport Chatreport | UserOverallReport UserConversationHistoryReport | UserConversationReport UserHappinessReport | UserHappinessDrilldown CustomerHappinessRatingsReport
Integrate Helpscout with Daton
Signin to Daton
Select Helpscout from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your Helpscout account Email and Password.
After providing the Email,password to authorize Daton to periodically extract data from Helpscout.
Post successful authentication you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration.
Workflow
Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Helpscout Data
Conversations
Purpose: List and filter conversations.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/conversations/list/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
embed
STRING
status
STRING
id
NUMERIC
number
NUMERIC
threads
NUMERIC
type
STRING
folderId
NUMERIC
status
STRING
state
STRING
subject
STRING
preview
STRING
mailboxId
NUMERIC
assignee
RECORD
createdBy
RECORD
createdAt
TIMESTAMP
closedBy
NUMERIC
closedByUser
RECORD
userUpdatedAt
TIMESTAMP
customerWaitingSince
RECORD
source
RECORD
tags
RECORD
cc
STRING
bcc
STRING
primaryCustomer
RECORD
customFields
STRING
_embedded
RECORD
_links
RECORD
Customers
Purpose:Request parameters can be used to filter customers.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/customers/list/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
id
NUMERIC
firstName
STRING
lastName
STRING
gender
STRING
jobTitle
STRING
location
STRING
organization
STRING
photoType
STRING
photoUrl
STRING
createdAt
TIMESTAMP
updatedAt
TIMESTAMP
background
STRING
_embedded
RECORD
_links
RECORD
Tags
Purpose:Returns a list of tags used across all mailboxes. Tags are returned in alphabetical order.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/tags/list/
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
NUMERIC
slug
STRING
name
STRING
color
STRING
createdAt
TIMESTAMP
ticketCount
NUMERIC
ConversationsReceivedMessages
Purpose: The received messages report provides a summary of the volume of received messages over a given time range. Only messages from customers are counted.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/conversations/reports-conversations-received-messages/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
viewBy
STRING
channelType
STRING
date
TIMESTAMP
messages
NUMERIC
ConversationsDrilldownReport
Purpose:This report is similar to the Conversations Report, but instead of returning statistics about conversation volume, it drills down and returns the conversation data that makes up the Conversations Report.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/conversations/reports-conversations-drilldown/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
startDate
TIMESTAMP
endDate
TIMESTAMP
channelType
STRING
id
NUMERIC
number
NUMERIC
attachments
BOOLEAN
subject
STRING
status
STRING
threadCount
NUMERIC
preview
STRING
customerName
STRING
customerEmail
STRING
customerIds
STRING
tags
RECORD
modifiedAt
TIMESTAMP
type
STRING
waitingSince
TIMESTAMP
waitingSinceType
NUMERIC
mailboxid
NUMERIC
assignedid
NUMERIC
CompanyOverallReport
Purpose: The company report provides statistics about your company performance over a given time range. You may optionally specify two time ranges to see how performance changed between the two ranges.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/company/reports-company-overall/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
channelType
STRING
filterTags
STRING
current
RECORD
users
RECORD
ConversationsVolumesByChannelReport
Purpose:This report shows conversation volumes split by chat, phone and email channels.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/conversations/reports-conversations-volume-by-channel/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
viewBy
STRING
channelType
STRING
date
TIMESTAMP
chat
NUMERIC
NUMERIC
phone
NUMERIC
DocsOverallReport
Purpose: The Docs report provides statistics about Docs usage (searches, top articles, etc.) over a given time range.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/docs/reports-docs-overall/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
startDate
TIMESTAMP
endDate
TIMESTAMP
current
RECORD
topCategories
STRING
topArticles
STRING
popularSearches
STRING
failedSearches
RECORD
CompanyConversationsReport
Purpose:This report is similar to the Company Report, but instead of returning statistics about the company, it drills down and returns the conversation data that makes up the Company Report.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/company/reports-company-drilldown/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
range
STRING
startDate
TIMESTAMP
endDate
TIMESTAMP
channelType
STRING
id
NUMERIC
number
NUMERIC
attachments
BOOLEAN
subject
STRING
status
STRING
threadCount
NUMERIC
preview
STRING
customerName
STRING
customerEmail
STRING
customerIds
STRING
modifiedAt
TIMESTAMP
type
STRING
waitingSince
TIMESTAMP
waitingSinceType
NUMERIC
closedAt
TIMESTAMP
mailboxid
NUMERIC
assignedid
NUMERIC
CustomerHappinessOverallReport
Purpose:The happiness report provides information about how many Great, Okay, and Not Good ratings your company received for each period in a specified time range.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/happiness/reports-happiness-overall/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
startDate
TIMESTAMP
endDate
TIMESTAMP
channelType
STRING
okay
NUMERIC
notGoodCount
NUMERIC
happinessScore
NUMERIC
totalConversationsWithRatings
NUMERIC
ratingsCount
NUMERIC
ratingsPercent
NUMERIC
notGood
NUMERIC
great
NUMERIC
greatCount
NUMERIC
okayCount
NUMERIC
ProductivityOverallReport
Purpose: The productivity report provides a snapshot of productivity over a given time range.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/productivity/reports-productivity-overall/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
startDate
TIMESTAMP
endDate
TIMESTAMP
officeHours
STRING
channelType
STRING
current
RECORD
responseTime
RECORD
handleTime
RECORD
firstResponseTime
RECORD
resolutionTime
RECORD
repliesToResolve
RECORD
ConversationsOverallReport
Purpose:The conversations report provides statistics about conversation volume over a given time range.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/conversations/reports-conversations-overall/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
channelType
STRING
startDate
TIMESTAMP
endDate
TIMESTAMP
workflows
RECORD
replies
RECORD
tags
RECORD
customers
RECORD
filterTags
RECORD
busiestDay
RECORD
busyTimeEnd
NUMERIC
busyTimeStart
NUMERIC
customFields
RECORD
current
RECORD
tagIds
STRING
Users
Purpose: To get all the users.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/users/list/
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
NUMERIC
firstName
STRING
lastName
STRING
STRING
role
STRING
timezone
STRING
createdAt
STRING
updatedAt
STRING
type
STRING
mention
STRING
initials
STRING
jobTitle
STRING
phone
STRING
alternateEmails
STRING
_links
RECORD
Emailreport
Purpose:Our Email report measures efficiency working with email conversations.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/email/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
officeHours
STRING
filterTags
STRING
current
RECORD
responseTime
RECORD
handleTime
RECORD
firstResponseTime
RECORD
resolutionTime
RECORD
repliesToResolve
RECORD
Chatreport
Purpose:The Chat report is all about seeing volume, efficiency, and team productivity when using Beacon with live chat over time.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/chat/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
officeHours
STRING
current
RECORD
waitTime
RECORD
responseTime
RECORD
messagesPerChat
RECORD
duration
RECORD
UserOverallReport
Purpose:The report provides a snapshot of a user or team activity over a specified time range.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/user/reports-user/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
officeHours
STRING
channelType
STRING
filterTags
STRING
user
RECORD
current
RECORD
UserConversationHistoryReport
Purpose:The conversation history report provides details about a user’s conversations for over a specified time range.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/user/reports-user-conversation-history/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
startDate
TIMESTAMP
endDate
TIMESTAMP
officeHours
STRING
channelType
STRING
status
STRING
id
NUMERIC
type
STRING
number
NUMERIC
customers
RECORD
UserConversationReport
Purpose:This report is similar to the User Report, but instead of returning statistics about users, it drills down and returns the conversation data that makes up the User Report.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/user/reports-user-drilldown/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
startDate
TIMESTAMP
endDate
TIMESTAMP
channelType
STRING
id
NUMERIC
number
NUMERIC
attachments
BOOLEAN
subject
STRING
status
STRING
threadCount
NUMERIC
preview
STRING
customerName
STRING
customerEmail
STRING
customerIds
STRING
tags
RECORD
modifiedAt
TIMESTAMP
type
STRING
waitingSince
TIMESTAMP
waitingSinceType
NUMERIC
mailboxid
NUMERIC
assignedid
NUMERIC
UserHappinessReport
Purpose:The happiness report provides information about how many Great, Okay, and Not Good ratings a user received for each period in a specified time range.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/user/reports-user-happiness/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
startDate
TIMESTAMP
endDate
TIMESTAMP
channelType
STRING
current
RECORD
UserHappinessDrilldown
Purpose:The user ratings report provides a user’s ratings for over a specified time range.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/user/reports-user-happiness-drilldown/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
startDate
TIMESTAMP
endDate
TIMESTAMP
ratingType
STRING
channelType
STRING
number
NUMERIC
threadid
NUMERIC
threadCreatedAt
TIMESTAMP
id
NUMERIC
type
STRING
ratingId
NUMERIC
ratingCustomerId
NUMERIC
ratingComments
STRING
ratingCreatedAt
TIMESTAMP
ratingCustomerName
STRING
ratingUserId
NUMERIC
ratingUserName
STRING
CustomerHappinessRatingsReport
Purpose:The happiness ratings report provides a company’s ratings for over a specified time range.
Source API Documentation https://developer.helpscout.com/mailbox-api/endpoints/reports/happiness/reports-happiness-ratings/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
rating
STRING
startDate
TIMESTAMP
endDate
TIMESTAMP
channelType
STRING
number
NUMERIC
threadid
NUMERIC
threadCreatedAt
TIMESTAMP
id
NUMERIC
type
STRING
ratingId
NUMERIC
ratingCustomerId
NUMERIC
ratingComments
STRING
ratingCreatedAt
TIMESTAMP
ratingCustomerName
STRING
ratingUserId
NUMERIC
ratingUserName
STRING
Last updated