Retrieves all company addresses, optionally filtered via OData query options.
Request Information
URI Parameters :
None.
Body Parameters :
None.
Response Information
Resource Description :
IHttpActionResult containing the list of company addresses.
db_address_company| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary key |
globally unique identifier | |
| name |
Name of the address |
string |
Max length: 50 |
| street |
Street |
string |
Max length: 100 |
| street2 |
Bus |
string |
Max length: 100 |
| street_number |
Street number. Can be not used |
string |
Max length: 50 |
| zip |
Zip code |
string |
Max length: 50 |
| city |
City |
string |
Max length: 50 |
| phone |
Phone number |
string |
Max length: 50 |
| mobile |
Cell phone number |
string |
Max length: 50 |
| fax |
Fax number |
string |
Max length: 50 |
|
Email address |
string |
Max length: 250 |
|
| url |
Url |
string |
Max length: 255 |
| db_country_id |
Foreign key to table Country |
globally unique identifier | |
| latitude_decimal |
Latitude of the address, used for map display and route optimization. |
decimal number | |
| longitude_decimal |
Longitude of the address, used for map display and route optimization. |
decimal number | |
| archived |
You cannot delete an address. The only way is to archive it. |
boolean | |
| company_id |
Foreign key of the company this address belongs to. |
globally unique identifier | |
| db_address_type_id |
Foreign key to the db_address_type. Please use controller DbAddressType to find the correct it to use |
globally unique identifier | |
| db_state_id |
Foreign key to the db_state |
globally unique identifier | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |
Response Formats
application/json, text/json
{
"id": "edac378e-97e2-46b5-a8e2-c5c56191c954",
"name": "sample string 2",
"street": "sample string 3",
"street2": "sample string 4",
"street_number": "sample string 5",
"zip": "sample string 6",
"city": "sample string 7",
"phone": "sample string 8",
"mobile": "sample string 9",
"fax": "sample string 10",
"email": "sample string 11",
"url": "sample string 12",
"db_country_id": "ea649451-12aa-4556-a01c-a344fac9ff87",
"latitude_decimal": 14.0,
"longitude_decimal": 15.0,
"archived": true,
"company_id": "9aa1c4f7-52ac-41b6-9f3f-2aa12d049db7",
"db_address_type_id": "23fbb5aa-902d-4b03-af81-d5ae9ea8e43d",
"db_state_id": "ba3e262a-b928-4ab9-a08b-d008aa465e71",
"modified_dateutc": "2026-11-12T14:28:15.2284943+00:00"
}
application/xml, text/xml
<db_address_company xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Odyssee.ServiceAppAPI.Models"> <archived>true</archived> <city>sample string 7</city> <company_id>9aa1c4f7-52ac-41b6-9f3f-2aa12d049db7</company_id> <db_address_type_id>23fbb5aa-902d-4b03-af81-d5ae9ea8e43d</db_address_type_id> <db_country_id>ea649451-12aa-4556-a01c-a344fac9ff87</db_country_id> <db_state_id>ba3e262a-b928-4ab9-a08b-d008aa465e71</db_state_id> <email>sample string 11</email> <fax>sample string 10</fax> <id>edac378e-97e2-46b5-a8e2-c5c56191c954</id> <latitude_decimal>14</latitude_decimal> <longitude_decimal>15</longitude_decimal> <mobile>sample string 9</mobile> <modified_dateutc>2026-11-12T14:28:15.228Z</modified_dateutc> <name>sample string 2</name> <phone>sample string 8</phone> <street>sample string 3</street> <street2>sample string 4</street2> <street_number>sample string 5</street_number> <url>sample string 12</url> <zip>sample string 6</zip> </db_address_company>