Query, create and delete user accounts.

Table Specific Information

Select

• Id supports the '=' operator.
• Username supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• FirstName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• LastName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• FullName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.

The driver uses the Act! CRM API to process search criteria that refer to the supported fields. The driver processes other filters client-side within the driver. For example, the following queries are processed server side:

SELECT * FROM Users WHERE Id = '12345'
SELECT * FROM Users WHERE Username = 'jsmith'

Insert

To insert a user, you must specify the Username, Password, FirstName, LastName, RoleName, and Status.

INSERT INTO Users (Username, Password, FirstName, LastName, RoleName, Status) VALUES ('jdoe1', 'S13cur3P@ss!', 'John1', 'Doe1', 'Administrator', 'Inactive')

Delete

Users can be deleted by providing an Id and issuing a DELETE statement.

DELETE FROM Users WHERE Id = 'd583f44d-2013-4615-801c-b111b23b8deb'

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	Unique identifier of the user.
Username	String	False	The login name of the user.
Password	String	False	The password for the new user.
FirstName	String	False	The first name of the user.
MiddleName	String	False	The middle name of the user.
LastName	String	False	The last name of the user.
NamePrefix	String	False	The name prefix of the user.
NameSuffix	String	False	The name suffix of the user.
FullName	String	False	The full display name of the user.
Salutation	String	False	The salutation of the user.
Email	String	True	The email address of the user.
Role	String	True	The role assigned to the user.
RoleName	String	False	The role name to assign to the new user.
Status	String	False	The status of the user (Active, Inactive, Deleted).
LastLogOnDate	Datetime	True	The date and time the user last logged on.
MustChangePassword	Boolean	False	Whether the user must change their password on next login.
CanChangePassword	Boolean	False	Whether the user is allowed to change their password.
PasswordExpires	Boolean	False	Whether the user password expires.