CompanyContacts

Stores individual contact records for companies, including names, emails, roles, and assigned company identifiers.

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.

CompanyId supports the '=, IN' comparison operators.
Id supports the '=, IN' comparison operators.

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

  SELECT * FROM CompanyContacts WHERE CompanyId = 'Val1'
  SELECT * FROM CompanyContacts WHERE Id = 'Val1'

Insert

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

CompanyId, Title, Locale, CustomerFirstName, CustomerLastName, CustomerEmail, CustomerPhone, CustomerId

Update

The following columns can be updated:

Title, Locale, CustomerFirstName, CustomerLastName, CustomerEmail, CustomerPhone

Delete

You can delete entries by specifying the following column:

Columns


Name	Type	ReadOnly	References	Description
CompanyId	String	True		The unique identifier of the company to which this contact is associated.
Id [KEY]	String	True		A unique identifier for the company contact record.
IsMainContact	Bool	True		Indicates whether this contact is designated as the company's primary point of contact.
Title	String	False		The job title or professional designation of the company contact.
Locale	String	False		The language or locale preference set for the company contact, used for communication and localization.
LifetimeDuration	String	True		The length of time since the company contact was created in Shopify, expressed in a readable format such as '1 year', '2 months', or '3 days'.
CreatedAt	Datetime	True		The timestamp marking when the company contact record was first created in Shopify.
UpdatedAt	Datetime	True		The timestamp marking when the company contact record was last updated.
CustomerId	String	True		The unique identifier of the customer record linked to this company contact.
CustomerFirstName	String	False		The first name of the customer associated with this contact.
CustomerLastName	String	False		The last name of the customer associated with this contact.
CustomerEmail	String	False		The email address of the customer linked to this contact record.
CustomerPhone	String	False		The phone number of the customer linked to this contact record.