Data Model
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.
API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.
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.