TDV Adapter for Google Directory

Build 22.0.8462

UserAddresses

Lists the addresses for a user.

Table Specific Information

Select

To get a list of addresses for a user, the UserId column is required. It can be set in the connection string or in the WHERE clause condition. Otherwise, the adapter will automatically use the UserId of the first user from the Users table.

For example, the following query is processed server side by the Google Directory APIs:

SELECT * FROM UserAddresses

Columns

Name Type Description
UserId String The unique identifier for the user.
Type String The address type.
CustomType String The custom type of the address.
FormattedAddress String The full unstructured postal address.
PoBox String Post office box of the address.
ExtendedAddress String The extended address
StreetAddress String The street address
Locality String The town or city of the address.
Region String The abbreviated province or state.
PostalCode String The ZIP or postal code, if applicable.
Country String Country in the address.
CountryCode String The country code. Uses the ISO 3166-1 standard.
IsPrimary Boolean Indicates if this is the primary address of the user

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462