Input - 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

Validate Address takes an address as input. All addresses use this format regardless of the address's country. See Address Line Processing for U.S. Addresses for important information about how address line data is processed for U.S. addresses.

Table 1. Input Format

Field Name

Format

Description

AddressLine1

String [50]

The first address line.

AddressLine2

String [50]

The second address line.

City

String [50]

The city name.

For U.S. addresses only, you may put the city, state, and ZIP Code™ in the City field. If you do this, you must leave the StateProvince and PostalCode fields blank.

StateProvince

String [50]

The state or province.

For U.S. addresses only, you may put the state in the City field instead of the StateProvince field.

PostalCode

String [10]

The postal code for the address in one of the following formats:

99999
99999-9999
A9A9A9
A9A 9A9
9999 999

For U.S. addresses only, you may put the ZIP Code™ in the City field.

For U.S. addresses only, if the city/state/ZIP Code™ is in the PostalCode field, Validate Address may parse the data and successfully process the address. For best results, put this data in the appropriate fields (City, StateProvince, and PostalCode).

Country

String [50]

The country code or name, in any of the following formats:

  • Two-character ISO 3166-1 Alpha 2 country code
  • Three-character ISO 3166-1 Alpha 3 country code
  • English country name
  • French country name
  • German country name
  • Spanish country name

FirmName

String [50]

The company or firm name.

USUrbanName

String [50]

The U.S. address urbanization name. This is used primarily for Puerto Rico addresses.

CanLanguage

String

For Canadian addresses only, indicates whether the address is in English or French, if the option the Determine language using field on the Canadian Address Options tab is set to CanLanguage input field.

If this field is blank, the address is formatted in English. If the field contains any non-blank value, the address is formatted in French. Note that addresses in Quebec are always formatted in French regardless of the value in this field.