Users
Query users for a Marketo organization.
Note: Insert queries are not supported. Users can be invited using the InviteUser stored procedure. Invited users can be retrieved using the GetInvitedUserById stored procedure. Invited users can be deleted using the DeleteInvitedUser stored procedure.
Select
Note: Filters provided with one of the supported operators listed in the "Operators" column are processed server-side, all the other filters are processed client-side.
For example, the following queries are processed server-side:
SELECT * FROM Users WHERE UserId='[email protected]'
Update
UPDATE USERS SET EmailAddress='[email protected]', FirstName='updated', LastName='updated', ExpiresAt='2024-12-12T00:00:00-01:00' WHERE UserId='[email protected]'
Delete
DELETE FROM USERS WHERE UserId='[email protected]'
Columns
| Name | Type | ReadOnly | Operators | Description |
| UserId [KEY] | String | True | = |
The user id in the form of an email address. |
| Id | Integer | True |
The user identifier. | |
| EmailAddress | String | False |
The user's email address. | |
| FirstName | String | False |
The user's first name. | |
| LastName | String | False |
The user's last name. | |
| APIOnly | Boolean | True |
Whether the user is API-Only. | |
| ExpiresAt | Datetime | False |
The date and time when the user login expires. | |
| LastLoginAt | Datetime | True |
The date and time of user's most recent login. | |
| FailedLogins | Integer | True |
Count of user login failures. | |
| FailedDeviceCode | Integer | True |
Device code for user login failure. | |
| IsLocked | Boolean | True |
Whether the user account is locked. | |
| LockedReason | String | True |
Reason that user account is locked. | |
| OptedIn | Boolean | True |
Whether user has opted in. | |
| UserWorkspaceRoles | String | True |
Array of user roles and workspaces. |