Addresses

An Address resource represents a physical address that can be used with Twilio phone numbers.

Table-Specific Information

SELECT

Returns a list of Address resource representations, each representing an address within your account.

The provider 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 provider.


Column	Supported Operators
Sid	`=`
CustomerName	`=`
Name	`=`
EmergencyEnabled	`=`
IsoCountry	`=`

For example, the following queries are processed server-side:

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

The following columns 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.