CompanyContacts

Lists contacts for companies, including identifiers, email, and role.

Table-Specific Information

Select

The server uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The server processes other filters client-side within the server.

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 globally unique identifier of the company that the contact belongs to.
Id [KEY]	String	True		The globally unique identifier of the company contact.
IsMainContact	Bool	True		Indicates whether this contact is the main contact for the company.
Title	String	False		The job title of the company contact.
Locale	String	False		The locale (language) preference of the company contact.
LifetimeDuration	String	True		The duration of time since the company contact was created in Shopify, expressed as a readable interval such as '1 year', '2 months', or '3 days'.
CreatedAt	Datetime	True		The date and time when the company contact was created in Shopify.
UpdatedAt	Datetime	True		The date and time when the company contact record was last updated.
CustomerId	String	True		The globally unique identifier of the customer linked to this 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 associated with this contact.
CustomerPhone	String	False		The phone number of the customer associated with this contact.