SIPCredential
A SIP Credential resource represents a username and password used to authenticate SIP Endpoints to a SIP Domain.
Table-Specific Information
SELECT
The connector 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 connector.
| Column | Supported Operators |
| CredentialListSid | = |
| Sid | = |
For example:
SELECT * FROM SIPCredential WHERE CredentialListSid = 'CLabc123def456'
SELECT * FROM SIPCredential WHERE CredentialListSid = 'CLabc123def456' AND Sid = 'CRabc123def456'
INSERT
CredentialListSid, Username, and Password are required for INSERT. The password must be a minimum of 12 characters, contain at least 1 digit, and have mixed case.
INSERT INTO SIPCredential (CredentialListSid, Username, Password) VALUES ('CLabc123def456', 'myuser', 'MyPassword123')
UPDATE
UPDATE SIPCredential SET Password = 'NewPassword123' WHERE CredentialListSid = 'CLabc123def456' AND Sid = 'CRabc123def456'
DELETE
DELETE FROM SIPCredential WHERE CredentialListSid = 'CLabc123def456' AND Sid = 'CRabc123def456'
Columns
| Name | Type | ReadOnly | References | Description |
| Sid [KEY] | String | True |
A 34 character string that uniquely identifies this Credential resource. | |
| AccountSid | String | True |
Accounts.Sid |
The unique ID of the Account responsible for this resource. |
| CredentialListSid [KEY] | String | False |
The unique ID of the CredentialList that contains this Credential. | |
| Username | String | False |
The username used to identify this Credential. | |
| 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. | |
| Uri | String | True |
The URI of this resource relative to https://api.twilio.com. |
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 |
| Password | String |
The password used to authenticate the username. The password must be a minimum of 12 characters, contain at least 1 digit, and have mixed case. Not returned by the API. Used in INSERT/UPDATE statements. |