The add-in models entities in the Talkdesk API as an easy-to-use SQL database, using views and stored procedures. These objects are defined in schema files, which are simple, easy-to-read text files that describe the structure and organization of the data. Live connectivity to these objects means any changes to your Talkdesk account are immediately reflected when using the add-in.

Views

The Views section describes the available views. Views model entities you can query with SQL.

Common views include:

Report Views

Report views are a subset of this add-in's views. Each report name ends with Report. Report views are still queried with normal SQL.

Available Report Views

Filters

Every report view exposes three pseudocolumns that map to the timespan inputs accepted by Talkdesk:

• TimespanFrom: The inclusive start of the time range. Supports the >= operator.
• TimespanTo: The exclusive end of the time range. Supports the < operator.
• Timezone: An IANA timezone (for example, America/New_York) used by the API when bucketing time-sensitive values. Supports the = operator.

Whenever the query does not supply both bounds, the add-in defaults the missing bound so that the time range is always a single 31-day (one month) window, anchored on whichever bound was supplied. If both TimespanFrom and TimespanTo are omitted, the range defaults to the last 31 days (TimespanFrom is set to 31 days before the current time and TimespanTo to the current time). If only TimespanFrom is supplied, TimespanTo is set to 31 days after it. If only TimespanTo is supplied, TimespanFrom is set to 31 days before it.

If TimespanFrom or TimespanTo is used with an operator other than the one listed above, the query will not be executed and an error is thrown.

If Timezone is omitted from the query, the add-in uses the system's default timezone.

How a Report Query Is Executed

Report views are backed by the Talkdesk asynchronous reporting API rather than a direct query. When you SELECT from a report view, the add-in submits one or more report jobs, waits for each to finish generating, and downloads the results. Rows are always returned in chronological order.

The reporting API accepts a window of at most 31 days per job. When a query requests a wider range with the TimespanFrom and TimespanTo filters, the add-in automatically splits it into consecutive slices of 31 days or fewer and creates one report job per slice. The following connection properties control this process:

• MaxBatchReportJobs: How many report jobs are created at a time. The jobs in a batch are generated concurrently on the server, but are downloaded strictly in order, one at a time; once a batch is fully consumed, the next batch is fetched. A higher value can reduce the overall wait when querying large date ranges. The default is 5.
• ReportPollingInterval: How many seconds the add-in waits between status checks while a report job is still generating. The default is 5.
• ReportQueryTimeout: The maximum time, in seconds, a single report query may run, measured across all of its report jobs. The default is -1, which lets the query run without a timeout.

Depending on the amount of data and the size of the requested time window, generating a report can take a long time. If you set ReportQueryTimeout to a positive value and encounter timeouts on large date ranges, increase it or leave it at the default of -1 to run without a timeout.

Stored Procedures

Stored Procedures are scripts that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, and can be used to search, update, and modify information in Talkdesk.