ODBC Driver for Salesforce

Build 24.0.9060

GetUserInformation

Retrieves personal information for the user associated with the current session.

Input

Name Type Description
BasicInfoOnly String Default is false. If this input is set to true, the procedure will only return basic information like the ServerURL, SessionID, Sandbox, OrganizationId and OrganizationName.

Result Set Columns

Name Type Description
AccessibilityMode String Available in API version 7.0 and later. Indicates whether user interface modifications for the visually impaired are on (true) or off (false). The modifications facilitate the use of screen readers, such as JAWS.
CurrencySymbol String Currency symbol to use for displaying currency values. Applicable only when OrganizationMultiCurrency is false.
OrganizationId String Id of the organization. Allows third-party tools to uniquely identify individual organizations in Salesforce, which is useful for retrieving billing or organization-wide setup information.
OrganizationMultiCurrency String Indicates whether the user's organization uses multiple currencies (true) or not (false).
OrganizationName String Name of the user's organization or company.
OrgDefaultCurrencyIsoCode String Default currency ISO code. Applicable only when OrganizationMultiCurrency is false. When the logged-in user creates any objects that have a currency ISO code, the API uses this currency ISO code if it is not explicitly specified in the create() call.
ProfileID String Id of the profile associated with the role currently assigned to the user.
RoleID String Role Id of the role currently assigned to the user.
Sandbox String Whether the current organization is a sandbox. Either 'true' or 'false' for Basic authorization, and NULL otherwise.
ServerURL String The server URL of the Salesforce instance.
SessionID String The currently active section used by the API connection.
SessionSecondsValid String Number of seconds remaining until the user's session expires.
UserDefaultCurrencyIsoCode String Default currency ISO code. Applicable only when OrganizationMultiCurrency is true. When the logged-in user creates any objects that have a currency ISO code, the API uses this currency ISO code if it is not explicitly specified in the create() call.
UserEmail String The user's email address.
UserFullName String The user's full name.
UserID String The user's Id.
UserLanguage String User's language, which controls the language for labels displayed in an application. String is 2-5 characters long. The first two characters are always an ISO language code. For example, fr or en. If the value is further qualified by country, then the string also has an underscore (_) and another ISO country code, for example US or UK. For example, the string for the United States is en_US, and the string for French Canadian is fr_CA.
UserLocale String User's locale, which controls the formatting of dates and choice of symbols for currency. The first two characters are always an ISO language code; for example, fr or en. If the value is further qualified by country, then the string also has an underscore (_) and another ISO country code; for example, US or UK. For example, the string for the United States is en_US, and the string for French Canadian is fr_CA.
UserName String User's login name.
UserTimeZone String User's time zone.
UserType String Type of user license assigned to the Profile associated with the user.
UserUISkin String Available in API version 7.0 and later. Returns the value Theme2 if the user is using the newer user interface theme of the online application, labeled Salesforce. Returns Theme1 if the user is using the older user interface theme, labeled Salesforce Classic. In the online application, this look and feel setting is configurable from Setup by clicking Customize | User Interface.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060