app-daktela

ex-daktela

Daktela contact center is a cloud-based solution of call center with native support for many communication channels “OmniChannel” in one Web application - phone, email, helpdesk, webchat, SMS and social networks.

This application extracts and transforms data from Daktela using the Daktela API.

The extractor was built according to the Daktela API v6 docs.

Operation

Inputs:

• Credentials
• Time scope
• List of tables

Output tables:

• accounts
• users
• groups
• pauses
• queues
• contacts
• tickets
• statuses
• templates
• npsSurveys
• attempts
• timeConditions
• ticketsCategories
• campaignsRecords
• loginSessions
• readySessions
• pauseSessions
• queueSessions
• activitiesCall
• activitiesChat
• activitiesEmail
• activitiesFbm
• activities
• activities_statuses

Incremental load:

All tables contain an id column which serves as a unique primary key. In reality, it is an MD5 hash of the actual primary keys. For most tables, the attribute name serves as the primary key. The exceptions are the ‘Activity’ item tables (Calls, Emails, Chats etc. ), where the primary keys are columns activities_name and item_name.

Configuration

• Username, Password: Identical to credentials for daktela dashboard.
• URL: Daktela server address. This is usually something like https://myDaktelaServer.daktela.com, or if you use a custom server, it could be https://123.45.6.78:910 or https://a9B8c7D6e5.vpn2keboola.com:12345.
• Server: The name of your Daktela server, serves as a prefix for all tables and keys in tables. Example: myDaktelaServer.
• Start Date, End Date: Fixed dates in the format YYYY-MM-DD, dynamic number of days in the format -N where N is a non-negative integer, or the word today. For example, a configuration with "Start date": -7 and "End date": today will extract data from one week to the past.
• Incremental: Check the box if the data should be loaded to Keboola Storage incrementally. See Keboola docs for more information.
• List of Tables: Names of tables to be extracted, separated by a comma; default set to all tables possible. Choose from tables listed above.

All extracted tables can be configured to include other columns or to be filtered in a different way. Contact us for further details at support@revolt.bi

Data issues

• Sometimes, Daktela returns orphaned items. Activities of type “Call” can exist without any call associated to them. These items are deleted by the app to keep referential integrity.
• The app only downloads records created at least 30 minutes ago to avoid downloading unfinished calls.

Data transformation

• All rows in key columns have a Daktela server name prefix, e.g. myDaktelaServer_activities_573dj57.
• All table names have a Daktela server name prefix, e.g. myDaktelaServer_activities.csv.
• The extractor usually downloads only the first level of attributes returned as a nested JSON. Other attributes among hundreds from lower levels were chosen manually.
• The script omits items without an activity from the operator. These include mostly spam emails or abandoned calls.

Need help?

If you have any questions, feel free to contact us at support@revolt.bi, check our other solutions at our website or find other components at https://components.keboola.com/components

Prepared by