ODBC Driver for Shopify

Build 24.0.9060

Pages

Returns a list of the shop's pages.

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.

  • Title supports the '=,!=' comparison operators.
  • Handle supports the '=,IN' comparison operators.
  • CreatedAt supports the '=,!=,<,>,>=,=<' comparison operators.
  • UpdatedAt supports the '=,!=,<,>,>=,=<' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM Pages
  SELECT * FROM Pages WHERE Title = 'Val1'
  SELECT * FROM Pages WHERE Handle = 'Val1'
  SELECT * FROM Pages WHERE CreatedAt = '2023-01-01 11:10:00'
  SELECT * FROM Pages WHERE UpdatedAt = '2023-01-01 11:10:00'

Columns

Name Type References Description
Id [KEY] String A globally-unique ID.
Title String The title of the page.
Body String The description of the page, complete with HTML formatting.
Handle String A human-friendly unique string for the page automatically generated from its title.
BodySummary String Summary of the page body.
OnlineStoreUrl String The URL used for viewing the resource on the shop's Online Store. Returns 'null' if the resource is currently not published to the Online Store sales channel.
CreatedAt Datetime The timestamp of the page creation.
UpdatedAt Datetime The timestamp of the latest page update.
SeoTitle String The SEO title.
SeoDescription String The meta description.

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