Segments

A list of a shop's segments.

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

For example, the following queries are processed server side:

	SELECT * FROM Segments
	SELECT * FROM Segments WHERE Id = 'gid://shopify/Segment/460201033987'
	SELECT * FROM Segments WHERE Id IN ('gid://shopify/Segment/460201033987', 'gid://shopify/Segment/460201066755')

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	True		A globally-unique ID.
Name	String	False		The name of the segment.
Query	String	False		A precise definition of the segment. The definition is composed of a combination of conditions on facts about customers.
CreationDate	Datetime	True		The date and time when the segment was added to the store.
LastEditDate	Datetime	True		The date and time when the segment was last updated.