Audit History for Data Connector Operations

Updated 

You can access a comprehensive summary of each connector's execution. This summary aggregates results half-hourly for all automated connector runs and is also available for each run triggered manually by the user. The audit history provides detailed information at the record level, including the success or failure status, failure reason (if applicable), created or modified entity ID (if available), and the timestamp of task completion. Additionally, you can download this record for your reference.

Audit Log for Connector Configuration Changes

When the connector configuration is edited, the following actions are logged:

  • Name

  • Description

  • Account

  • Default Language

  • Enable/Disable Transcription

  • Integration Type

  • Entity Source

  • Source File, Metadata File, Message File Prefix

  • Metadata File, Message File, Voice File Extension

  • CSV Delimiter Type

Activity Log Details

The activity log contains the following information for each connector run:

  • Name of the Connector

  • Source of the Connector (SFTP/S3/File Upload/API/SQL)

  • Timestamp of Activity

  • Filters for Scheduled vs. Manual Run

  • Date and Time Filters for Logs

  • Sort by Creation Timestamp

  • Export Logs Button

  • Refresh Logs Button

Recurring Connector Audit

For recurring connectors, the system logs half-hourly updates. Depending on the type of entity:

Standard or Custom Entity (File Based - Excel)

  • URL to download a zip file containing processed excel files.

  • Columns appended to each excel file:

    • Timestamp of Task Completion

    • Outcome (Success/Fail)

    • Entity ID (Success)

    • Error Reason (Failure)

System Entity (Case - Zip Files/API Based)

  • URL to download an excel file with the report of each processed file.

  • Report columns:

    • Unique Identifier (Ticket ID/File Name)

    • Timestamp of Task Completion

    • Source of the Connector

    • Outcome (Success/Fail)

    • Case Number in Sprinklr (Success) / Entity ID (Other Entities)

    • Error Reason (Failure)

Non-Recurring Connector Audit

For non-recurring connectors, the system logs data for every trigger instance similarly to recurring connectors.

Edge Cases Handling

For bulk uploads, if an activity is logged while the process is partially complete, the log will include all tasks processed up to the logging time. Remaining tasks will appear in the next log iteration.

This structured audit ensures comprehensive tracking and optimization of data connector processes.