Returns the list of companies in the shop.

Table-Specific Information

Select

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

• 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
  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

Delete

You can delete entries by specifying the following column:

Id

Columns