Connecting to Gong
To authenticate to Gong, you can use API Key authentication with your Gong API Key and API Secret.
Authentication
To authenticate to Gong, you must provide your Gong API Key and API Secret, along with your tenant Domain. These credentials are combined and Base64-encoded to form the Basic authentication header used for all API requests.
Using API Key Authentication
To authenticate using an API Key, you need to obtain your API Key and API Secret from your Gong account settings.
You can then connect by setting the AuthScheme to APIKey and providing your credentials:
- AuthScheme: Set this to APIKey.
- APIKey: Set this to your Gong API Key.
- APISecret: Set this to your Gong API Secret.
- Domain: Set this to your Gong tenant domain (e.g., us-36533.api.gong.io).
Example connection string
Profile=C:\profiles\Gong.apip;AuthScheme=APIKey;ProfileSettings='APIKey=your_api_key;APISecret=your_api_secret;Domain=your-tenant.api.gong.io';
Usage Examples
AnsweredScorecards:
SELECT * FROM AnsweredScorecards
CallOutcomes:
SELECT * FROM CallOutcomes
CallTranscripts:
SELECT * FROM CallTranscripts WHERE FromDateTime = '2024-01-01 00:00:00'
Calls:
SELECT * FROM Calls
CallsExtensive:
SELECT * FROM CallsExtensive WHERE FromDateTime = '2024-01-01 00:00:00'
CoachingMetrics:
SELECT * FROM CoachingMetrics WHERE WorkspaceId = '623457276584334' AND ManagerId = '234599484848423' AND From = '2024-01-01 00:00:00' AND To = '2024-01-31 23:59:59'
CRMIntegrations:
SELECT * FROM CRMIntegrations
DataPrivacyEmail:
SELECT * FROM DataPrivacyEmail WHERE EmailAddress = '[email protected]'
DataPrivacyPhone:
SELECT * FROM DataPrivacyPhone WHERE PhoneNumber = '+11234567890'
FlowBulkAssignments:
SELECT * FROM FlowBulkAssignments WHERE Id = '7782342274025937902'
FlowFolders:
SELECT * FROM FlowFolders WHERE FlowFolderOwnerEmail = '[email protected]'
FlowProspects:
SELECT * FROM FlowProspects WHERE CrmProspectsIds = 'crm_id_123'
Flows:
SELECT * FROM Flows WHERE FlowOwnerEmail = '[email protected]'
IntegrationSettings:
SELECT * FROM IntegrationSettings
InteractionStats:
SELECT * FROM InteractionStats WHERE FromDate = '2024-01-01' AND ToDate = '2024-01-31'
LibraryFolderContent:
SELECT * FROM LibraryFolderContent WHERE FolderId = '7782342274025937902'
LibraryFolders:
SELECT * FROM LibraryFolders WHERE WorkspaceId = '623457276584334'
Logs:
SELECT * FROM Logs WHERE LogType = 'AccessLog' AND FromDateTime = '2024-01-01 00:00:00'
PermissionProfileUsers:
SELECT * FROM PermissionProfileUsers WHERE ProfileId = '7782342274025937902'
PermissionProfiles:
SELECT * FROM PermissionProfiles WHERE WorkspaceId = '623457276584334'
Scorecards:
SELECT * FROM Scorecards
Tasks:
SELECT * FROM Tasks WHERE UserId = '234599484848423' AND Types = 'FLOW,MANUAL' AND TaskActions = 'CALL' AND Statuses = 'OPEN'
Trackers:
SELECT * FROM Trackers WHERE WorkspaceId = '623457276584334'
UserActivity:
SELECT * FROM UserActivity WHERE FromDate = '2024-01-01' AND ToDate = '2024-01-31'
UserActivityByPeriod:
SELECT * FROM UserActivityByPeriod WHERE FromDate = '2024-01-01' AND ToDate = '2024-01-31' AND AggregationPeriod = 'MONTH'
UserDailyActivity:
SELECT * FROM UserDailyActivity WHERE FromDate = '2024-01-01' AND ToDate = '2024-01-31'
UserSettingsHistory:
SELECT * FROM UserSettingsHistory WHERE UserId = '234599484848423'
Users:
SELECT * FROM Users
Workspaces:
SELECT * FROM Workspaces
Connection Properties
The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider.
| Property | Description |
| APIKey | Your Gong API key used to authenticate requests to the Gong API. |
| APISecret | Your Gong API secret used together with the API Key to authenticate requests to the Gong API. |
| AuthScheme | The scheme used for authentication. Accepted entries are APIKey. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT |
| Domain | Your Gong tenant domain used to construct API endpoint URLs. |