CompanyContactRoleAssignments
Lists role assignments mapping company contacts to their permissions.
Table-Specific Information
Select
The 本製品 uses the Shopify API to process WHERE clause conditions built with the following column and operators. The 本製品 processes other filters client-side within the 本製品.
- CompanyContactId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM CompanyContactRoleAssignments WHERE CompanyContactId = 'Val1'
Insert
The following columns can be used to create a new record:
CompanyLocationId, CompanyContactId, RoleId
Delete
You can delete entries by specifying the following columns:
Id, CompanyContactId
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The globally unique identifier of the company contact role assignment. | |
| CompanyId | String | True |
The globally unique identifier of the company that this role assignment belongs to. | |
| CompanyLocationId | String | True |
The globally unique identifier of the company location where the role is assigned. | |
| CompanyContactId | String | True |
The globally unique identifier of the company contact associated with this role assignment. | |
| CreatedAt | Datetime | True |
The date and time when the role assignment record was created. | |
| UpdatedAt | Datetime | True |
The date and time when the role assignment record was last updated. | |
| RoleId | String | True |
The globally unique identifier of the assigned role. | |
| RoleName | String | True |
The name of the assigned role, such as 'admin' or 'buyer'. | |
| RoleNote | String | True |
A note associated with the assigned role. |