The CData Excel Add-In for Twilio models the Twilio API as relational tables and views. These are defined in schema files, which are simple, text-based configuration files.

The add-in uses the Twilio API to process supported filters. The add-in processes other filters client-side within the add-in.

Tables

The add-in models the data in tables so that it can be easily queried and updated with standard SQL.

Views

Views are tables that cannot be modified. Typically, data that are read-only and cannot be updated are shown as views.

Stored Procedures

Stored Procedures are function-like interfaces that you invoke with SQL queries. They perform tasks beyond standard create, read, update, and delete (CRUD) operations, such as sending messages, downloading media, managing call recordings, and managing conference participants.