Addresses
An Address resource represents a physical address that can be used with Twilio phone numbers.
Table-Specific Information
Select
Twilio allows only a small subset of columns to be used in the WHERE clause of a SELECT query. The provider uses the Twilio api to process WHERE clause conditions built with the following columns with the = operator: Sid, CustomerName, Name, EmergencyEnabled, and IsoCountry.
Select
Returns a list of Address resource representations, each representing an address within your account.
SELECT * FROM Addresses;
SELECT * FROM Addresses WHERE Sid = 'X123456789'
Insert
To add an Address, you must specify the following parameters: CustomerName, Street, City, Region, PostalCode, and IsoCountry.
INSERT INTO Addresses (Name, customername, street, city, region, postalcode, isocountry) VALUES ('Sample Address', 'twilio', 'ChapelHill', 'SF', 'CA','94019', 'US')
Update
Following fields can be updated: Name, CustomerName, Street, City, Region, PostalCode, EmergencyEnabled, AutoCorrectAddress, StreetSecondary
UPDATE Addresses SET NAME = 'CustomerAddress' WHERE sid='AD46c6bd5385d1c58e51163f1488247d74'
Delete
DELETE FROM Addresses WHERE Sid = 'AD46c6bd5385d1c58e51163f1488247d74'
Columns
| Name | Type | ReadOnly | References | Description |
| Sid [KEY] | String | True |
The unique string that Twilio created to identify this Address resource. | |
| AccountSid | String | True |
The Account SID that created this Address resource. | |
| Name | String | False |
A human-readable name for the address. | |
| CustomerName | String | False |
The name of the customer associated with the address. | |
| Street | String | False |
The street address. | |
| City | String | False |
The city of the address. | |
| Region | String | False |
The state or region of the address. | |
| PostalCode | String | False |
The postal or ZIP code. | |
| IsoCountry | String | False |
The ISO country code (e.g., US, IN). | |
| EmergencyEnabled | Boolean | False |
Whether the address is enabled for emergency services. | |
| DateCreated | Datetime | True |
The date and time when the address was created. | |
| DateUpdated | Datetime | True |
The date and time when the address was last updated. | |
| Uri | String | True |
The URI of this Address resource. | |
| StreetSecondary | String | False |
The additional number and street address of the address. | |
| Verified | Boolean | True |
Whether the address has been verified to comply with regulation. | |
| Validated | Boolean | True |
Whether the address has been validated to comply with local regulation. |