Schema Information for Kapture Report Table

Discover essential information about schemas, their types, and how they can improve website search results and user experience.

Schema Information for Kapture Report Table

Discover essential information about schemas, their types, and how they can improve website search results and user experience.

Tables/APIs

The following is the list of tables or APIs associated with the Kapture CRM connector:

Generic Report

Generic Report

This Report allows you to pull data from Kapture CRM's generic report based on specified parameters.
Source API Documentation: https://dev.kapture.cx/kapture-api/reference/api-reference

Replication: Key-Based Replication
Replication Key: Start_Date

Fields

Field Name	Target Datatype
ticketId	STRING
createDate	STRING
createTime	TIME
assignedTo	STRING
empCode	STRING
sourceType	STRING
lastConversationDate	STRING
lastConversationTime	TIME
landingFolder	STRING
firstResponseTime	STRING
avgAgentResponseTime	TIME
avgHandlingTime	TIME
ftr	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC
dispositionFolderLevel	RECORD
createReason	STRING
resolvedDate	DATE
resolveTime	TIME
avgHandlingTime_st	STRING
avgAgentResponseTime_st	STRING
createdBy	STRING
resolvedDate_st	STRING
Ticket	RECORD
Customer	RECORD
Contact	RECORD

Table of Contents

Tables/APIs Generic Report Fields

Schema Information for Kapture Report Table

Saras Pulse

Saras Daton