Retrieves all db_address
Request Information
URI Parameters :
None.
Body Parameters :
None.
Response Information
Resource Description :
IHttpActionResult
db_addressName | Description | Type | Additional information |
---|---|---|---|
id |
Primary key |
globally unique identifier | |
company_id |
The company owner of this address |
globally unique identifier |
Optionally required : company_id, company_code or company must be provided |
company_code |
Embedded entity "company" using ERP PK when adding/updating address |
string |
Optionally required : company_id, company_code or company must be provided |
company |
Embedded entity "company" when adding/updating address |
company |
Optionally required : company_id, company_code or company must be provided |
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 | |
code |
Field used for Embedded entity (store there your ERP PK) |
string | |
archived |
You cannot delete an address. The only way is to archive it. |
boolean | |
name |
Name of the address |
string | |
street |
Street |
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 | |
mobile |
Cell phone number |
string | |
fax |
Fax number |
string | |
Email address |
string |
Max length: 250 |
|
url |
Url |
string | |
db_country_id |
Foreign key to table Country |
globally unique identifier | |
db_country_code |
CountryCode entity using international code when adding/updating company |
string | |
street2 |
Additional information on the address not part of the postal address |
string |
Max length: 50 |
modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |
Response Formats
application/json, text/json
{ "id": "55fa21aa-397e-4080-ac6f-a864c1bdd612", "company_id": "e582a684-4311-4dcd-9873-ffacf7665a74", "company_code": "sample string 3", "db_address_type_id": "9c0c8dc8-16dd-4246-b2ba-a5ffc0362d7c", "code": "sample string 5", "archived": true, "name": "sample string 7", "street": "sample string 8", "street_number": "sample string 9", "zip": "sample string 10", "city": "sample string 11", "phone": "sample string 12", "mobile": "sample string 13", "fax": "sample string 14", "email": "sample string 15", "url": "sample string 16", "db_country_id": "4da3ad4c-b4f3-4c60-9537-aaac3c03811e", "db_country_code": "sample string 18", "street2": "sample string 19", "modified_dateutc": "2025-07-06T22:14:41.5472527+00:00" }