StaffMembers
Retrieves a paginated list of the shop's staff members.(This table is available only with a ShopifyPlus subscription)
View-Specific Information
Select
The connector processes all filters client-side within the connector. The following query is the only one processed server side:
SELECT * FROM StaffMembers
Columns
Name | Type | References | Description |
Id [KEY] | String | A globally-unique ID. | |
ShopId | String |
Shop.Id | A globally-unique ID. |
Name | String | The staff member's full name. | |
FirstName | String | The staff member's first name. | |
LastName | String | The staff member's last name. | |
Active | Bool | Whether the staff member is active. | |
String | The staff member's email address. | ||
Exists | Bool | Whether the staff member's account exists. | |
Initials | String | The staff member's initials, if available. | |
Locale | String | The staff member's preferred locale. Locale values use the format 'language' or 'language-COUNTRY', where 'language' is a two-letter language code, and 'COUNTRY' is a two-letter country code. For example: 'en' or 'en-US' | |
Phone | String | The staff member's phone number. | |
IsShopOwner | Bool | Whether the staff member is the shop owner. | |
PrivateDataAccountSettingsUrl | String | The URL to the staff member's account settings page. | |
PrivateDataCreatedAt | Datetime | The date and time when the staff member was created. |