The adapter models the data in Twilio into a list of tables that can be queried using standard SQL statements.
Generally, querying Twilio tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
Twilio Adapter Tables
|Accounts||Create, update, and query Twilio Accounts belonging to the authenticated Account.|
|Applications||Create, update, delete, and query the available Applications in Twilio.|
|Calls||Delete and query connections between phones and Twilio.|
|Feedback||Create and query Feedback on a Call in Twilio.|
|FeedbackSummary||Create, delete, and query Feedback Summaries in Twilio.|
|IncomingPhoneNumbers||Create, update, delete, and query phone numbers purchased from Twilio.|
|Media||Delete and query Media in Twilio.|
|Messages||Create, update, delete, and query SMS and MMS Messages in Twilio.|
|OutgoingCallerIds||Insert, update, and query the verified numbers that may be used as a caller Id when making outgoing calls in Twilio.|
|Recordings||Delete and query the available Recordings in Twilio.|
|ServiceLists||Create, update, delete, and query the available Lists for a specific Service in Twilio Sync.|
|Transcriptions||Query the available Transcriptions in Twilio.|
|Triggers||Create, update, delete, and query usage Triggers in Twilio.|