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:

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

The connector processes other filters client-side within the connector.

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

SELECT * FROM Companies WHERE Id='VALUE'

SELECT * FROM Companies WHERE ExternalId='VALUE'

SELECT * FROM Companies WHERE Name='VALUE'

SELECT * FROM Companies WHERE CustomerSince='2000-01-01 01:00:00.0'

SELECT * FROM Companies WHERE CreatedAt<'2000-01-01 01:00:00.0'

SELECT * FROM Companies WHERE UpdatedAt<'2000-01-01 01:00:00.0'

Insert

INSERT statements are mapped to the 'companyCreate' GraphQL mutation.

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

ExternalId, Name, Note, CustomerSince

UPDATE

UPDATE statements are mapped to the 'companyUpdate' GraphQL mutation.

The following columns can be updated:

ExternalId, Name, Note

DELETE

DELETE statements are mapped to the 'companyDelete' GraphQL mutation.

You can delete entries by specifying the Id.

Columns