ODBC Driver for Shopify

Build 24.0.9060

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 driver processes all filters client-side within the driver. 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.
Email 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060