Users

List the Users of the WordPressOnline website.

Table Specific Information

The provider uses the WordPress API to process supported filters.

The provider processes other filters client-side within the provider.

For example, the following queries are processed server side.

SELECT * FROM Users WHERE Id = 1
SELECT * FROM Users WHERE SiteId = 1255

Also, ordering by Id, and SiteId is handled by the WordPress API.

To update a user you must specify the following column: Id.

UPDATE Users SET name = 'First Last' WHERE Id = '12345'

To delete a user you must specify the following column: Id.

DELETE FROM Users WHERE Id = '12345'


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the user.
SiteID	Integer	True		The unique identifier of the WordPress site the user belongs to.
FirstName	String	False		The user's first name as displayed in their WordPress profile.
LastName	String	False		The user's last name as displayed in their WordPress profile.
Email	String	False		The email address associated with the user's WordPress account.
AvatarURL	String	True		The URL of the user's avatar image.
Name	String	False		The display name of the user, typically shown on posts and comments.
NiceName	String	False		A sanitized, URL-friendly version of the user's display name.
ProfileURL	String	True		The full URL to the user's public WordPress profile page.
Roles	String	False		A list of roles assigned to the user, such as administrator, editor, author, or subscriber.
IPAddress	String	True		The IP address associated with the user's activity.
IsSuperAdmin	Boolean	True		Indicates whether the user has network-level administrative privileges (Super Admin) in a multisite environment.
Login	String	False		The username used by the user to log in to WordPress.
IsSiteVisible	Boolean	True		Indicates whether the user's site is visible to the public.
ItemURL	String	False		The full URL of the user's primary WordPress site.