Schema Information for Kapture Report Table

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

Need help with something?

Talk to data expert

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

 

data structure metadata

Related Articles

Table of Contents

Tables/APIs Generic Report Fields