CompanyContactRoleAssignments
Maps company contacts to specific roles, defining permissions and access within a B2B company account.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- 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 |
A unique identifier for the company contact role assignment record. | |
| CompanyId | String | True |
The unique identifier of the company associated with this role assignment. | |
| CompanyLocationId | String | True |
The unique identifier of the company location where this role applies. | |
| CompanyContactId | String | True |
The unique identifier of the company contact to whom this role is assigned. | |
| CreatedAt | Datetime | True |
The timestamp indicating when the role assignment was first created. | |
| UpdatedAt | Datetime | True |
The timestamp indicating when the role assignment record was last updated. | |
| RoleId | String | True |
The unique identifier of the role assigned to the company contact. | |
| RoleName | String | True |
The name of the assigned role, such as 'Admin', 'Buyer', or 'Manager'. | |
| RoleNote | String | True |
A descriptive note providing additional context or information about the assigned role. |