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": "7daf54a0-fa81-44a9-b211-885b3a32378f",
"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": "2c826384-c24a-4cc1-bca9-820dbd2def21",
"latitude_decimal": 14.0,
"longitude_decimal": 15.0,
"archived": true,
"company_id": "88d71ed4-b232-4765-98bd-d6d14e09784b",
"db_address_type_id": "a5772945-8f91-481d-898f-0aa47355d9e2",
"db_state_id": "3ee45728-bf25-475f-9238-0801cef117c7",
"modified_dateutc": "2026-09-16T08:35:23.1615646+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>88d71ed4-b232-4765-98bd-d6d14e09784b</company_id> <db_address_type_id>a5772945-8f91-481d-898f-0aa47355d9e2</db_address_type_id> <db_country_id>2c826384-c24a-4cc1-bca9-820dbd2def21</db_country_id> <db_state_id>3ee45728-bf25-475f-9238-0801cef117c7</db_state_id> <email>sample string 11</email> <fax>sample string 10</fax> <id>7daf54a0-fa81-44a9-b211-885b3a32378f</id> <latitude_decimal>14</latitude_decimal> <longitude_decimal>15</longitude_decimal> <mobile>sample string 9</mobile> <modified_dateutc>2026-09-16T08:35:23.161Z</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>