Genesys

Setting up the Genesys connector

No	Item	Required	Example	Notes
1	Client ID	Yes		Your OAuth user Client ID
2	Client Secret	Yes		Your OAuth user Client Secret
3	Tenant Endpoint Location	Yes		Please choose the right endpoint where your Tenant is located. More info by this Link
4	Start Date	Yes		Start Date in format: YYYY-MM-DD

Tables in the Genesys connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	telephony_providers_edges	39		Full Refresh
2	telephony_locations	15		Full Refresh
3	telephony_providers_edges_phones	26		Full Refresh
4	routing_outbound_events	10		Full Refresh
5	telephony_providers_edges_outboundroutes	19		Full Refresh
6	telephony_providers_edges_dids	17		Full Refresh
7	routing_routing_queues	22		Full Refresh
8	telephony_providers_edges_sites	27		Full Refresh
9	telephony_stations	15		Full Refresh
10	telephony_providers_edges_didpools	17		Full Refresh
11	telephony_providers_edges_extensions	17		Full Refresh
12	telephony_providers_edges_trunks	26		Full Refresh
13	telephony_providers_edges_lines	19		Full Refresh
14	user_users	15		Full Refresh
15	routing_routing_assessments	7		Full Refresh
16	user_groups	12		Full Refresh

Table: telephony_providers_edges

No	Column Name	Type	Notes
1	fullSoftwareVersion	VARCHAR
2	webRtcForceTurn	VARCHAR
3	onlineStatus	VARCHAR
4	callDrainingState	VARCHAR
5	createdByApp	VARCHAR
6	descriptions	VARCHAR
7	division	VARCHAR
8	patch	VARCHAR
9	dateCreated	VARCHAR
10	apiVersion	VARCHAR
11	managed	BOOLEAN
12	conversationCount	DOUBLE
13	fingerprint	VARCHAR
14	modifiedBy	VARCHAR
15	model	VARCHAR
16	id	VARCHAR
17	state	VARCHAR
18	make	VARCHAR
19	stagedVersion	VARCHAR
20	edgeDeploymentType	VARCHAR
21	serialNumber	VARCHAR
22	softwareVersionConfiguration	VARCHAR
23	physicalEdge	BOOLEAN
24	selfUri	VARCHAR
25	offlineConfigCalled	BOOLEAN
26	dateModified	VARCHAR
27	osName	VARCHAR
28	version	DOUBLE
29	currentVersion	VARCHAR
30	proxy	VARCHAR
31	softwareVersionPlatform	VARCHAR
32	fingerprintHint	VARCHAR
33	createdBy	VARCHAR
34	softwareVersionTimestamp	VARCHAR
35	pairingId	VARCHAR
36	name	VARCHAR
37	modifiedByApp	VARCHAR
38	softwareVersion	VARCHAR
39	statusCode	VARCHAR

Table: telephony_locations

No	Column Name	Type	Notes
1	images	VARCHAR
2	address	VARCHAR
3	notes	VARCHAR
4	floorplanImage	VARCHAR
5	addressVerificationDetails	VARCHAR
6	selfUri	VARCHAR
7	profileImage	VARCHAR
8	emergencyNumber	VARCHAR
9	version	DOUBLE
10	contactuser	VARCHAR
11	addressStored	BOOLEAN
12	name	VARCHAR
13	id	VARCHAR
14	state	VARCHAR
15	addressVerified	BOOLEAN

Table: telephony_providers_edges_phones

No	Column Name	Type	Notes
1	createdByApp	VARCHAR
2	descriptions	VARCHAR
3	division	VARCHAR
4	dateCreated	VARCHAR
5	managed	BOOLEAN
6	modifiedBy	VARCHAR
7	id	VARCHAR
8	state	VARCHAR
9	lines	VARCHAR
10	primaryEdge	VARCHAR
11	phoneBaseSettings	VARCHAR
12	capabilities	VARCHAR
13	selfUri	VARCHAR
14	dateModified	VARCHAR
15	phoneMetaBase	VARCHAR
16	version	DOUBLE
17	userAgentInfo	VARCHAR
18	site	VARCHAR
19	createdBy	VARCHAR
20	secondaryEdge	VARCHAR
21	secondaryStatus	VARCHAR
22	name	VARCHAR
23	modifiedByApp	VARCHAR
24	webRtcUser	VARCHAR
25	lineBaseSettings	VARCHAR
26	status	VARCHAR

Table: routing_outbound_events

No	Column Name	Type	Notes
1	eventMessage	VARCHAR
2	level	VARCHAR
3	relatedEntity	VARCHAR
4	selfUri	VARCHAR
5	name	VARCHAR
6	errorEntity	VARCHAR
7	correlationId	VARCHAR
8	id	VARCHAR
9	category	VARCHAR
10	timestamp	VARCHAR

Table: telephony_providers_edges_outboundroutes

No	Column Name	Type	Notes
1	classificationTypes	VARCHAR
2	selfUri	VARCHAR
3	dateModified	VARCHAR
4	createdByApp	VARCHAR
5	distribution	VARCHAR
6	descriptions	VARCHAR
7	version	DOUBLE
8	enabled	BOOLEAN
9	division	VARCHAR
10	site	VARCHAR
11	dateCreated	VARCHAR
12	createdBy	VARCHAR
13	managed	BOOLEAN
14	name	VARCHAR
15	modifiedByApp	VARCHAR
16	modifiedBy	VARCHAR
17	externalTrunkBases	VARCHAR
18	id	VARCHAR
19	state	VARCHAR

Table: telephony_providers_edges_dids

No	Column Name	Type	Notes
1	owner	VARCHAR
2	ownerType	VARCHAR
3	selfUri	VARCHAR
4	dateModified	VARCHAR
5	createdByApp	VARCHAR
6	descriptions	VARCHAR
7	version	DOUBLE
8	division	VARCHAR
9	dateCreated	VARCHAR
10	phoneNumber	VARCHAR
11	createdBy	VARCHAR
12	name	VARCHAR
13	modifiedByApp	VARCHAR
14	didPool	VARCHAR
15	modifiedBy	VARCHAR
16	id	VARCHAR
17	state	VARCHAR

Table: routing_routing_queues

No	Column Name	Type	Notes
1	callingPartyName	VARCHAR
2	peerId	VARCHAR
3	memberCount	DOUBLE
4	enableManualAssignment	BOOLEAN
5	selfUri	VARCHAR
6	dateModified	VARCHAR
7	autoAnswerOnly	BOOLEAN
8	enableTranscription	BOOLEAN
9	descriptions	VARCHAR
10	skillEvaluationMethod	VARCHAR
11	defaultScripts	VARCHAR
12	division	VARCHAR
13	dateCreated	VARCHAR
14	queueFlow	VARCHAR
15	createdBy	VARCHAR
16	callingPartyNumber	VARCHAR
17	name	VARCHAR
18	userMemberCount	DOUBLE
19	modifiedBy	VARCHAR
20	id	VARCHAR
21	memberGroups	VARCHAR
22	joinedMemberCount	DOUBLE

Table: telephony_providers_edges_sites

No	Column Name	Type	Notes
1	primarySites	VARCHAR
2	secondaryEdges	VARCHAR
3	createdByApp	VARCHAR
4	descriptions	VARCHAR
5	division	VARCHAR
6	dateCreated	VARCHAR
7	primaryEdges	VARCHAR
8	managed	BOOLEAN
9	modifiedBy	VARCHAR
10	id	VARCHAR
11	state	VARCHAR
12	addraddressesess	VARCHAR
13	coreSite	BOOLEAN
14	selfUri	VARCHAR
15	edges	VARCHAR
16	dateModified	VARCHAR
17	version	DOUBLE
18	mediaRegionsUseLatencyBased	BOOLEAN
19	ntpSettings	VARCHAR
20	createdBy	VARCHAR
21	secondarySites	VARCHAR
22	name	VARCHAR
23	modifiedByApp	VARCHAR
24	location	VARCHAR
25	mediaModel	VARCHAR
26	siteConnections	VARCHAR
27	edgeAutoUpdateConfig	VARCHAR

Table: telephony_stations

No	Column Name	Type	Notes
1	webRtcCallAppearances	DOUBLE
2	webRtcMediaDscp	DOUBLE
3	webRtcForceTurn	BOOLEAN
4	selfUri	VARCHAR
5	webRtcUserId	VARCHAR
6	type	VARCHAR
7	descriptions	VARCHAR
8	userId	VARCHAR
9	secondaryEdge	VARCHAR
10	webRtcPersistentEnabled	BOOLEAN
11	name	VARCHAR
12	lineAppearanceId	VARCHAR
13	id	VARCHAR
14	primaryEdge	VARCHAR
15	status	VARCHAR

Table: telephony_providers_edges_didpools

No	Column Name	Type	Notes
1	comments	VARCHAR
2	selfUri	VARCHAR
3	dateModified	VARCHAR
4	createdByApp	VARCHAR
5	descriptions	VARCHAR
6	version	DOUBLE
7	division	VARCHAR
8	dateCreated	VARCHAR
9	createdBy	VARCHAR
10	provider	VARCHAR
11	startPhoneNumber	VARCHAR
12	name	VARCHAR
13	modifiedByApp	VARCHAR
14	modifiedBy	VARCHAR
15	id	VARCHAR
16	state	VARCHAR
17	endPhoneNumber	VARCHAR

Table: telephony_providers_edges_extensions

No	Column Name	Type	Notes
1	owner	VARCHAR
2	ownerType	VARCHAR
3	selfUri	VARCHAR
4	dateModified	VARCHAR
5	createdByApp	VARCHAR
6	descriptions	VARCHAR
7	version	DOUBLE
8	division	VARCHAR
9	number	VARCHAR
10	dateCreated	VARCHAR
11	createdBy	VARCHAR
12	extensionPool	VARCHAR
13	name	VARCHAR
14	modifiedByApp	VARCHAR
15	modifiedBy	VARCHAR
16	id	VARCHAR
17	state	VARCHAR

Table: telephony_providers_edges_trunks

No	Column Name	Type	Notes
1	proxyAddressList	VARCHAR
2	createdByApp	VARCHAR
3	trunkType	VARCHAR
4	edgeGroup	VARCHAR
5	descriptions	VARCHAR
6	enabled	BOOLEAN
7	registersEnabledStatus	VARCHAR
8	division	VARCHAR
9	edge	VARCHAR
10	dateCreated	VARCHAR
11	logicalInterface	VARCHAR
12	connectedStatus	VARCHAR
13	modifiedBy	VARCHAR
14	trunkMetabase	VARCHAR
15	id	VARCHAR
16	state	VARCHAR
17	trunkBase	VARCHAR
18	inService	BOOLEAN
19	selfUri	VARCHAR
20	dateModified	VARCHAR
21	version	DOUBLE
22	optionsEnabledStatus	VARCHAR
23	createdBy	VARCHAR
24	name	VARCHAR
25	modifiedByApp	VARCHAR
26	family	DOUBLE

Table: telephony_providers_edges_lines

No	Column Name	Type	Notes
1	template	VARCHAR
2	selfUri	VARCHAR
3	dateModified	VARCHAR
4	createdByApp	VARCHAR
5	edgeGroup	VARCHAR
6	descriptions	VARCHAR
7	version	DOUBLE
8	division	VARCHAR
9	site	VARCHAR
10	dateCreated	VARCHAR
11	createdBy	VARCHAR
12	secondaryEdge	VARCHAR
13	name	VARCHAR
14	modifiedByApp	VARCHAR
15	modifiedBy	VARCHAR
16	id	VARCHAR
17	state	VARCHAR
18	primaryEdge	VARCHAR
19	lineBaseSettings	VARCHAR

Table: user_users

No	Column Name	Type	Notes
1	addresses	VARCHAR
2	selfUri	VARCHAR
3	primaryContactInfo	VARCHAR
4	acdAutoAnswer	BOOLEAN
5	title	VARCHAR
6	version	DOUBLE
7	division	VARCHAR
8	chat	VARCHAR
9	name	VARCHAR
10	dateLastLogin	VARCHAR
11	id	VARCHAR
12	state	VARCHAR
13	department	VARCHAR
14	email	VARCHAR
15	username	VARCHAR

Table: routing_routing_assessments

No	Column Name	Type	Notes
1	dateCreated	VARCHAR
2	queues	VARCHAR
3	selfUri	VARCHAR
4	dateModified	VARCHAR
5	id	VARCHAR
6	state	VARCHAR
7	kpiAssessments	VARCHAR

Table: user_groups

No	Column Name	Type	Notes
1	addresses	VARCHAR
2	visibility	VARCHAR
3	rulesVisible	BOOLEAN
4	chat	VARCHAR
5	memberCount	DOUBLE
6	selfUri	VARCHAR
7	name	VARCHAR
8	dateModified	VARCHAR
9	id	VARCHAR
10	state	VARCHAR
11	type	VARCHAR
12	version	DOUBLE

External Resources

• Genesys
• Json Rest Apis
• Api Credentials
• Oauth Admin Page
• Locations
• Routing
• Stations
• Telephony
• Users

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.