ODBC Driver for Shopify

Build 24.0.9060

Blogs

Retrieves a list of the shop's blogs.

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.
  • 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 Blogs
  SELECT * FROM Blogs WHERE Id = 'Val1'
  SELECT * FROM Blogs WHERE Title = 'Val1'
  SELECT * FROM Blogs WHERE Handle = 'Val1'
  SELECT * FROM Blogs WHERE CreatedAt = '2023-01-01 11:10:00'
  SELECT * FROM Blogs WHERE UpdatedAt = '2023-01-01 11:10:00'

Columns

Name Type References Description
Id [KEY] String A globally-unique ID.
Title String The blogs's title.
Handle String A human-friendly unique string for the Blog automatically generated from its title.
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.
SeoTitle String The SEO title.
SeoDescription String The meta description.
CreatedAt Datetime The date and time when the blog was created. This column can only be used as an input for filtering.
UpdatedAt Datetime The date and time when the blog was last updated. This column can only be used as an input for filtering.

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