CompanyContacts

Returns contacts for companies.

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.

CompanyId supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM CompanyContacts WHERE CompanyId = '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 company to which the contact belongs.
Id [KEY]	String	True		A globally-unique ID.
IsMainContact	Bool	True		Whether the contact is the main contact of the company.
Title	String	False		The company contact's job title.
Locale	String	False		The company contact's locale (language).
LifetimeDuration	String	True		The lifetime duration of the company contact, since its creation date on Shopify. Examples: '1 year', '2 months', '3 days'.
CreatedAt	Datetime	True		The date and time at which the company contact was created at Shopify.
UpdatedAt	Datetime	True		The date and time at which the company contact was last updated.
CustomerId	String	True		The customer associated to this contact.
CustomerFirstName	String	False		The customer's first name.
CustomerLastName	String	False		The customer's last name.
CustomerEmail	String	False		The customer's email address.
CustomerPhone	String	False		The customer's phone number.