UserInfo

Shows OpenID Connect user profile information for standard claims.

Table Specific Information

The connector processes all filters client side within the connector.

SELECT * FROM UserInfo


Name	Type	References	Description
UserId	String		The user ID of the user.
Sub	String		The subject ID for the end user at the issuer.
Name	String		The full name of the user.
GivenName	String		The given, or first, name of the user.
FamilyName	String		The surname or family name of the user. Also known as the last name.
MiddleName	String		The middle name of the user.
Picture	String		The URL of the profile picture of the user.
Email	String		The internationalized email address.
EmailVerified	Boolean		Indicates whether the user's email address is verified.
Gender	String		The user's gender.
Birthdate	Datetime		The user's birthday, in YYYY-MM-DD format.
ZoneInfo	String		The time zone of the user.
Locale	String		The locale of the user.
PhoneNumber	String		The preferred telephone number of the user.
StreetAddress	String		The full street address. Can include the house number and street name.
Locality	String		The city or locality.
Region	String		The state, province, prefecture, or region.
PostalCode	String		The zip code or postal code.
Country	String		The country.
VerifiedAccount	Boolean		Indicates whether the account is verified.
AccountType	String		The account type. The allowed values are PERSONAL, BUSINESS, PREMIER.
AgeRange	String		The account holder's age range.