Store's staff member who are assigned to a company location of the shop. The assigned staff members' actions are limited to objects associated with the assigned company location. (This table is available only with a ShopifyPlus subscription)

Table-Specific Information

Select

The 本製品 uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The 本製品 processes other filters client-side within the 本製品.

• Id supports the '=, IN' comparison operators.
• CompanyLocationId supports the '=, IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM CompanyLocationStaffMemberAssignments WHERE Id = 'Val1'
  SELECT * FROM CompanyLocationStaffMemberAssignments WHERE CompanyLocationId = 'Val1'

Insert

The following columns can be used to create a new record:

CompanyLocationId, StaffMemberId

Delete

You can delete entries by specifying the following column:

Id

Columns