addresses
Address records for units and buildings in client workspaces. Results are a UNION of unit addresses and building addresses.
| Column | Description |
|---|---|
id |
Unique identifier for the address record |
post_code |
Postal or ZIP code of the address |
lat |
Latitude coordinate of the address location |
lng |
Longitude coordinate of the address location |
country |
Name of the country where the address is located |
country_code |
ISO country code for the address location |
street1 |
Primary street address line |
street2 |
Secondary street address line |
city |
City or town name where the address is located |
region |
State, province, or region name |
addressable_type |
Type of entity that this address belongs to |
addressable_id |
Identifier of the entity that this address belongs to |
addressable_scope |
Scope or context of the address relationship |
created_at |
Timestamp indicating when the address record was created |
updated_at |
Timestamp indicating when the address record was last updated |
timezone |
Time zone of the address location |
floor |
Floor number or level in the building |
timestamp |
Date when the table was last synchronized |