API Data Provider - Online Help
HelpScout Profile
Connecting to HelpScout
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
Categories
CategoryArticles
CollectionArticles
Collections
CompanyCustomersHelpedReport
CompanyDrillDownReport
CompanyOverallReport
Conversations
ConversationsBusiestTimeReport
ConversationsDrillDownByFieldsReport
ConversationsDrillDownReport
ConversationsNewConversationDrillDownReport
ConversationsNewConversationReport
ConversationsOverallReport
ConversationsReceivedMessageStatisticReport
ConversationsVolumesByChannel
CustomerAddress
CustomerChatHandles
CustomerEmails
CustomerPhones
Customers
CustomerSocialProfiles
CustomerWebsites
DocsOverallReport
HappinessOverallReport
HappinessRatingReport
Mailboxes
MailboxFolders
Me
ProductivityFirstResponseTimeReport
ProductivityOverallReport
ProductivityRepliesSentReport
ProductivityResolutionTimeReport
ProductivityResolvedReport
ProductivityResponseTimeReport
Redirects
Revisions
SearchArticles
Sites
Tags
Threads
UserConversationHistoryReport
UserCustomerHelpedReport
UserDrillDownReport
UserHappinessDrillDownReport
UserHappinessReport
UserOverallReport
UserRepliesReport
UserResolutionReport
Users
Webhooks
Workflows
CompanyCustomersHelpedReport
List of customer who want helps by company
Columns
Name
Type
References
Date
Datetime
Customers
Integer