Output - 23.1

Spectrum Dataflow Designer Guide

Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Dataflow Designer Guide
First publish date
2007
Last updated
2024-05-09
Published on
2024-05-09T23:01:03.226155

Get City State Province returns the matching city and state/province for the input postal code as well as a code to indicate the success or failure of the match attempt. If more than one city/state or city/province matches the input postal code, multiple output records are returned.

Table 1. Get City State Province Output

Field Name

Description

City

The matched city name.

City.Type

The USPS® standardized city name type (U.S. addresses only).

V
Vanity (non-mailing) city name.
P
Primary. The city name is the primary mailing city name.
S
Secondary. The city name is an alternate city name but is acceptable. A city can have multiple secondary city names.

PostalCode

The input postal code.

ProcessedBy

Indicates which address coder processed the address. One of the following:

USA
The U.S. address coder processed the address.
CAN
The Canadian address coder processed the address.

StateProvince

The validated state/province or its abbreviated value.

Status

Reports the success or failure of the match attempt.

null
Success
F
Failure

Status.Code

The reason for failure, if there is one. The only valid value is:

  • DisabledCoder
  • UnrecognizedPostalCode

Status.Description

The description of the failure. The valid values are:

Postal code not found
This value will appear if Status.Code=UnrecognizedPostalCode.
PerformUSProcessing disabled
This value will appear if Status.Code=DisabledCoder.
PerformCanadianProcessing disabled
This value will appear if Status.Code=DisabledCoder.