CompanyContactRoleAssignments
Returns role assignments.
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 globally-unique ID. | |
| CompanyId | String | True |
The company this role assignment belongs to. | |
| CompanyLocationId | String | True |
The company location to which the role is assigned. | |
| CompanyContactId | String | True |
The company contact for whom this role is assigned. | |
| CreatedAt | Datetime | True |
The date and time when the assignment record was created. | |
| UpdatedAt | Datetime | True |
The date and time when the assignment record was last updated. | |
| RoleId | String | True |
A globally-unique ID. | |
| RoleName | String | True |
The name of a role. For example, 'admin' or 'buyer'. | |
| RoleNote | String | True |
A note for the role. |