ODBC Driver for Shopify

Build 24.0.9060

Segments

A list of a shop's segments.

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

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:

Id

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060