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.
Table-Specific Information
SELECT
The driver uses the Twilio API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver.
| Column | Supported Operators |
| DomainSid | = |
| Sid | = |
For example:
SELECT * FROM SIPIpAccessControlListMapping WHERE DomainSid = 'SDabc123def456'
SELECT * FROM SIPIpAccessControlListMapping WHERE DomainSid = 'SDabc123def456' AND Sid = 'ALabc123def456'
INSERT
DomainSid and IpAccessControlListSid are required for INSERT.
INSERT INTO SIPIpAccessControlListMapping(DomainSid, IpAccessControlListSid) VALUES ('SDabc123def456', 'ALabc123def456')
DELETE
DELETE FROM SIPIpAccessControlListMapping WHERE DomainSid = 'SDabc123def456' AND Sid = 'ALabc123def456'
Columns
| Name | Type | ReadOnly | References | Description |
| Sid [KEY] | String | True |
A 34 character string that uniquely identifies this IpAccessControlListMapping resource. | |
| DomainSid [KEY] | String | False |
SIPDomain.Sid |
The unique ID of the SIP Domain that contains this IpAccessControlListMapping. |
| AccountSid | String | True |
Accounts.Sid |
The unique ID of the Account responsible for this resource. |
| FriendlyName | String | True |
A human-readable description of the mapped IpAccessControlList. | |
| DateCreated | Datetime | True |
The date and time in GMT that the resource was created specified in RFC 2822 format. | |
| DateUpdated | Datetime | True |
The date and time in GMT that the resource was last updated specified in RFC 2822 format. |
Pseudocolumns
Pseudocolumn fields can be used in SELECT, INSERT, and UPDATE statements to provide additional control over data retrieval and modification in the data source.
| Name | Type | Description |
| IpAccessControlListSid | String |
The SID of the IpAccessControlList resource to map to the SIP Domain. Required on INSERT. |