Companies

Returns the list of companies in the shop.

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.

Id supports the '=, IN' comparison operators.
ExternalId supports the '=, !=' comparison operators.
Name supports the '=, !=' comparison operators.
CustomerSince supports the '=, <, >, >=, <=' comparison operators.
CreatedAt supports the '=, <, >, >=, <=' comparison operators.
UpdatedAt supports the '=, <, >, >=, <=' comparison operators.

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

  SELECT * FROM Companies WHERE Id = 'Val1'
  SELECT * FROM Companies WHERE ExternalId = 'Val1'
  SELECT * FROM Companies WHERE Name = 'Val1'
  SELECT * FROM Companies WHERE CustomerSince = '2023-01-01 11:10:00'
  SELECT * FROM Companies WHERE CreatedAt = '2023-01-01 11:10:00'
  SELECT * FROM Companies WHERE UpdatedAt = '2023-01-01 11:10:00'

Insert

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

ExternalId, Name, Note, CustomerSince

Update

The following columns can be updated:

ExternalId, Name, Note, MainContactId

Delete

You can delete entries by specifying the following column:

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A globally-unique ID.
ExternalId	String	False		A unique externally-supplied ID for the company.
Name	String	False		The name of the company.
Note	String	False		A note about the company.
ContactsCount	Int	True		The number of contacts that belong to the company.
ContactsCountPrecision	String	True		The count's precision, or the exactness of the value.
CustomerSince	Datetime	True		The date and time at which the company became the customer.
DefaultCursor	String	True		A default cursor that returns the single next record, sorted ascending by ID.
LifetimeDuration	String	True		The lifetime duration of the company, since it became a customer of the shop. Examples: '2 days', '3 months', '1 year'.
LocationsCount	Int	True		The number of locations that belong to the company.
LocationsCountPrecision	String	True		The count's precision, or the exactness of the value.
OrdersCount	Int	True		The total number of orders placed for this company, across all its locations.
OrdersCountPrecision	String	True		The count's precision, or the exactness of the value.
HasTimelineComment	Bool	True		Whether the merchant added a timeline comment to the company.
CreatedAt	Datetime	True		The date and time at which the company was created in Shopify.
UpdatedAt	Datetime	True		The date and time at which the company was last modified.
DefaultRoleId	String	True		A globally-unique ID.
DefaultRoleName	String	True		The name of a role. For example, 'admin' or 'buyer'.
DefaultRoleNote	String	True		A note for the role.
MainContactId	String	True		A globally-unique ID.
TotalSpentAmount	Decimal	True		Decimal money amount.
TotalSpentCurrencyCode	String	True		Currency of the money.