AccountUser

An individual user within an account. This table does not support deletes.

Table-Specific Information

Select

The provider uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The provider processes other filters client-side within the provider.

For example, the following (but not only) queries are processed server side:

SELECT * FROM AccountUser WHERE Id = 123

SELECT * FROM AccountUser WHERE Id IN (123, 456)

SELECT * FROM AccountUser WHERE CreatedDate > '2017/01/25'

Insert

You must specify the following fields when inserting to this table: Client_Id, Name, Email, UserID, and Password.

INSERT INTO AccountUser (Client_Id, UserId, Name, Email, Password) VALUES (123, 'bcabsbasbcasb', 'Test', '[email protected]', 'testpas@2sowrd')

Update

You must specify the Id and the Client_Id in the WHERE clause when executing an update against this table.

UPDATE AccountUser SET Name = 'changed' WHERE Id = 123 AND Client_Id = 456

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Int	False	Identifier for an object.
CreatedDate	Datetime	False	Date and time of the object's creation..
ModifiedDate	Datetime	False	Indicates the last time object information was modified.
Client_ID [KEY]	Int	False	The Id of the client.
AccountUserID	Int	False	Specifies the Marketing Cloud identifier of an account user.
UserID	String	False	The Id of the user.
Name	String	False	Name of the object or property.
Email	String	False	Default email address for object. Indicates if subscriber information can be used for email sends.
MustChangePassword	Bool	False	Indicates whether user must change password on next login.
ActiveFlag	Bool	False	Specifies the status of an account user.
ChallengePhrase	String	False	Specifies the challenge answer for login assistance.
ChallengeAnswer	String	False	Specifies the challenge answer for login assistance.
IsAPIUser	Bool	False	Indicates if a user can use the API. A value of true indicates the user's password remains the same until actively changed.
NotificationEmailAddress	String	False	Indicates email address to which to send notifications.
Client_PartnerClientKey	String	False	The partner client key of the partner.
Password	String	False	Specified the password of an account user.
Locale_LocaleCode	String	True	The locale code of the locale.
TimeZone_ID	Int	True	The id of the timezone.
TimeZone_Name	String	True	The name of the timezone.
CustomerKey	String	False	User-supplied unique identifier for an object within an object type.
DefaultBusinessUnit	Int	False	Indicates business unit account user initially accesses.
LanguageLocale_LocaleCode	String	True	The locale code of the language locale.
Client_ModifiedBy	Int	False	Returns user ID for user who modified the object.

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

Build 24.0.9060