JDBC Driver for Shopify

Build 23.0.8839

Blogs

Retrieves a list of the shop's blogs.

View-Specific Information

Select

The 本製品 uses the Shopify API to process WHERE clause conditions built with the following columns and operators:

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

The 本製品 processes other filters client-side within the 本製品.

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

SELECT * FROM Blogs WHERE Id='VALUE'

SELECT * FROM Blogs WHERE Title='VALUE'

SELECT * FROM Blogs WHERE Handle='VALUE'

SELECT * FROM Blogs WHERE CreatedAt<'2000-01-01 01:00:00.0'

SELECT * FROM Blogs WHERE UpdatedAt<'2000-01-01 01:00:00.0'

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 23.0.8839