Excel Add-In for Salesforce Marketing Cloud

Build 20.0.7695

AccountUser

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

Table-Specific Information

Select

The add-in 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 add-in processes other filters client-side within the add-in. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.

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

SELECT * FROM AccountUser

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', 'test@gmail.com', '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) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695