Tables
The add-in models the data in Twilio as a list of tables in a relational database that can be queried using standard SQL statements.
CData Excel Add-In for Twilio Tables
| Name | Description |
| Accounts | Create, update, and query Twilio Accounts belonging to the authenticated Account. |
| Addresses | An Address resource represents a physical address that can be used with Twilio phone numbers. |
| Applications | Create, update, delete, and query the available Applications in Twilio. |
| ByocTrunk | A ByocTrunk resource describes a trunk that can be configured to send and receive voice traffic to and from a PSTN Carrier via Bring Your Own Carrier (BYOC). |
| CallAnnotation | Fetch and update the Annotation for a specific call. |
| Calls | Create, query, update, and delete calls between phones and Twilio. |
| ConferenceParticipants | Lists all the participants in an active conference. |
| Conferences | The Conferences resource allows you to query and manage the state of conferences on your Twilio account. |
| ConnectionPolicy | A ConnectionPolicy resource describes a set of routing rules for outbound calls made using Twilio's BYOC feature. |
| ConnectionPolicyTarget | A ConnectionPolicyTarget resource describes a destination for voice traffic for a Connection Policy. |
| ContentTemplates | Create, update, delete, and query Content templates in Twilio. |
| IncomingPhoneNumbers | Create, update, delete, and query phone numbers purchased from Twilio. |
| IpRecord | An IpRecord resource represents a static IP address used to address the BYOC Trunk's Termination SIP Domain via an IP address instead of an FQDN (Fully Qualified Domain Name). |
| Media | Delete and query Media in Twilio. |
| Messages | Create, update, delete, and query SMS and MMS Messages in Twilio. |
| OutgoingCallerIds | Represents verified phone numbers that can be used as a caller Id when making outgoing calls. |
| QueueMembers | Members is a subresource of Queues and represents a single call in a call queue. |
| Queues | A Queue resource describes a call queue that contains individual calls. |
| RealTimeTranscriptionForVideo | A RealTimeTranscriptionForVideo resource represents the configuration and state of real-time speech-to-text transcriptions for a Video Room. |
| Recordings | Delete and query the available Recordings in Twilio. |
| Rooms | A Room resource represents a Programmable Video communication session among multiple endpoints using Twilio's Video SDKs. When listing Rooms, the API returns only Rooms with a status of in-progress. |
| ServiceLists | Create, update, delete, and query the available Lists for a specific Service in Twilio Sync. |
| Services | A Service (or Verification Service) is the set of common configurations used to create and check verifications. Services contain Lists. |
| SIPCredential | A SIP Credential resource represents a username and password used to authenticate SIP Endpoints to a SIP Domain. |
| SIPCredentialList | A SIP CredentialList resource manages lists of users authorized to access a SIP Domain. Each CredentialList can contain up to 1,000 Credential resources. |
| SIPCredentialListMapping | A SIP CredentialListMapping resource associates a CredentialList with a SIP Domain for call authentication. Requests to the domain are challenged and authenticated against the mapped credential lists. |
| SIPDomain | A SIP Domain resource describes a custom DNS hostname that can accept SIP traffic for your account. SIP requests to the domain are routed to Twilio and authenticated before TwiML is requested. |
| SIPDomainRegistrationCredentialListMapping | A SIP Domain Registration CredentialListMapping resource links CredentialLists to a SIP Domain for registration authentication. Incoming SIP registrations are challenged and must match credentials in a mapped list. |
| SIPIpAccessControlList | A SIP IpAccessControlList resource contains IP addresses authorized to access a SIP Domain. Each account can have up to 1,000 IpAccessControlList resources, each containing up to 100 IP address entries. |
| SIPIpAccessControlListMapping | A SIP IpAccessControlListMapping resource associates an IpAccessControlList with a SIP Domain for call authentication. Incoming SIP INVITE requests must originate from an IP address in a mapped access control list. |
| SIPIpAddress | A SIP IpAddress resource represents an IP address entry within an IpAccessControlList. SIP requests from allowed IP addresses are permitted access to the associated SIP Domain. Each IpAccessControlList can contain up to 100 IP address entries. |
| SourceIpMapping | A SourceIpMapping resource associates an IP Record with a SIP Domain, allowing you to control which IP addresses are allowed to send traffic to your SIP infrastructure. |
| Transcriptions | Query the available Transcriptions in Twilio. |
| Triggers | Create, update, delete, and query usage Triggers in Twilio. |
| VerificationServices | A Verification Service is the set of common configurations used to create and check verifications. |
| VoiceInsightsSettings | Query and update the Voice Insights monitoring configuration for an account. |