Segments

Lists customer segments defined in the shop.

Table-Specific Information

Select

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

Id supports the '=, IN' comparison operators.
Name supports the '=' comparison operator.

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

  SELECT * FROM Segments WHERE Id = 'Val1'
  SELECT * FROM Segments WHERE Name = 'Val1'

Insert

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

Name, Query

Update

The following columns can be updated:

Name, Query

Delete

You can delete entries by specifying the following column:

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		A globally unique Id for the segment.
Name	String	False		The name of the segment (for example, 'High-value customers' or 'Subscribed to newsletter').
Query	String	False		The definition of the segment, composed of conditions based on customer attributes or behaviors.
CreationDate	Datetime	True		The date and time when the segment was created in the store.
LastEditDate	Datetime	True		The date and time when the segment was last updated.