CompanyLocationStaffMemberAssignments
Lists staff members assigned to specific company locations. Available only for Shopify Plus stores.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- 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
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A unique identifier for the company location staff member assignment record. | |
| CompanyId | String | True |
The unique identifier of the company associated with this staff assignment. | |
| CompanyName | String | True |
The official name of the company to which the staff member is assigned. | |
| CompanyLocationId | String | True |
The unique identifier of the specific company location where the staff member is assigned. | |
| CompanyLocationName | String | True |
The display name of the company location linked to this assignment. | |
| StaffMemberId | String | True |
The unique identifier of the staff member associated with the company location. | |
| StaffMemberName | String | True |
The full name of the staff member assigned to this company location. |