StaffMembers
Lists staff accounts with access to the shop, including roles and permissions. Available only for Shopify Plus stores.
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 identifier for the staff member within the Shopify store. | |
| ShopId | String |
Shop.Id | The globally unique identifier of the shop to which the staff member belongs. |
| Name | String | The full name of the staff member, combining first and last names as displayed in the admin interface. | |
| FirstName | String | The given (first) name of the staff member. | |
| LastName | String | The family (last) name of the staff member. | |
| Active | Bool | Indicates whether the staff member's account is currently active and able to access the store's admin. | |
| String | The email address associated with the staff member's Shopify account, used for login and notifications. | ||
| Exists | Bool | Indicates whether the staff account currently exists in Shopify. False may indicate that the account has been deleted or deactivated. | |
| Initials | String | The abbreviated initials of the staff member's name, typically displayed in admin dashboards or avatars. | |
| Locale | String | The staff member's preferred language and region setting, formatted as 'language' or 'language-COUNTRY' (for example, 'en' or 'en-US'). | |
| Phone | String | The staff member's contact phone number, used for internal communication or security verification. | |
| IsShopOwner | Bool | Indicates whether this staff member is the owner of the shop, granting full administrative privileges. | |
| AccountType | String | Specifies the type of staff account, such as 'standard', 'collaborator', or 'partner'. | |
| PrivateDataAccountSettingsUrl | String | The direct URL to the staff member's account settings page in the Shopify admin, used for profile and security management. | |
| PrivateDataCreatedAt | Datetime | The date and time when the staff member's account was created in the system. |