GET api/utlStateProvinceCode
Get all values from the StateProvinceCodes table
Request Information
URI Parameters
None.
Body Parameters
None.
Response Information
Resource Description
utlStateProvinceCodeDb| Name | Description | Type | Additional information |
|---|---|---|---|
| StateProvinceID | integer |
None. |
|
| StateProvinceCode | string |
Required Max length: 2 |
|
| StateProvinceName | string |
Required Max length: 50 |
|
| CountryCodeA3 | string |
Required Max length: 3 |
|
| IsActive | boolean |
None. |
|
| CreatedBy | integer |
None. |
|
| CreatedDate | date |
None. |
|
| UpdatedBy | integer |
None. |
|
| UpdatedDate | date |
None. |
|
| results | Collection of ValidationResult |
None. |
Response Formats
application/json, text/json
Sample:
{
"results": null,
"StateProvinceID": 1,
"StateProvinceCode": "sample string 2",
"StateProvinceName": "sample string 3",
"CountryCodeA3": "sample string 4",
"IsActive": true,
"CreatedBy": 6,
"CreatedDate": "2025-12-06T23:37:54.8347676+00:00",
"UpdatedBy": 8,
"UpdatedDate": "2025-12-06T23:37:54.8347676+00:00"
}
application/xml, text/xml
Sample:
<utlStateProvinceCodeDb xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Tables">
<results xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.ComponentModel.DataAnnotations" i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Utility" />
<CountryCodeA3>sample string 4</CountryCodeA3>
<CreatedBy>6</CreatedBy>
<CreatedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:37:54.8347676Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</CreatedDate>
<IsActive>true</IsActive>
<StateProvinceCode>sample string 2</StateProvinceCode>
<StateProvinceID>1</StateProvinceID>
<StateProvinceName>sample string 3</StateProvinceName>
<UpdatedBy>8</UpdatedBy>
<UpdatedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:37:54.8347676Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</UpdatedDate>
</utlStateProvinceCodeDb>