Stores blog metadata and publishing configuration for each blog in the shop.

Table-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.
• Title supports the '=, !=' comparison operators.
• Handle supports the '=, !=' comparison operators.
• UpdatedAt supports the '=, !=, <, >, >=, <=' comparison operators.
• CreatedAt supports the '=, !=, <, >, >=, <=' comparison operators.

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

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

Insert

The following columns can be used to create a new record:

Title, Handle, TemplateSuffix, CommentPolicy

The following pseudo-column can be used to create a new record:

Metafields (references Metafields)

Metafields Temporary Table Columns

Column Name	Type	Description
Id	String	The unique ID of the metafield.
Namespace	String	A container for a set of metafields. You need to define a custom namespace for your metafields to distinguish them from the metafields used by other apps.
Key	String	The name of the metafield.
Value	String	The information to be stored as metadata.
Type	String	The metafield's information type.

Update

The following columns can be updated:

Title, Handle, TemplateSuffix, CommentPolicy

The following pseudo-columns can be used to update a record:

RedirectArticles, RedirectNewHandle, Metafields (references Metafields)

Metafields Temporary Table Columns

Column Name	Type	Description
Id	String	The unique ID of the metafield.
Namespace	String	A container for a set of metafields. You need to define a custom namespace for your metafields to distinguish them from the metafields used by other apps.
Key	String	The name of the metafield.
Value	String	The information to be stored as metadata.
Type	String	The metafield's information type.

Delete

You can delete entries by specifying the following column:

Id

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A unique identifier for the blog record.
Title	String	False		The title of the blog as displayed in the Shopify Admin and storefront.
Handle	String	False		A unique, human-readable identifier automatically generated from the blog title, used in Liquid templates and URLs. Merchants can customize this handle for SEO or organizational purposes.
Tags	String	True		A list of tags associated with the 200 most recent blog articles, used for categorization and filtering.
TemplateSuffix	String	False		The alternate Liquid template assigned to the blog, if applicable. Returns null when the default 'blog.liquid' template is used.
ArticlesCount	Int	True		The total number of articles currently associated with the blog.
ArticlesCountPrecision	String	True		Indicates the precision level of the article count, specifying whether the value is exact or approximate.
CommentPolicy	String	False		Defines how comments are managed on the blog, such as open, moderated, or closed to public submissions.
FeedLocation	String	True		The full URL of the blog's feed provider, allowing external readers or applications to subscribe to blog updates.
FeedPath	String	True		The relative path of the blog feed provider within the store's site structure.
UpdatedAt	Datetime	True		The timestamp indicating when the blog was most recently updated or modified.
CreatedAt	Datetime	True		The timestamp marking when the blog was first created in Shopify.

Pseudo-Columns

Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.

Name	Type	Description
RedirectArticles	Bool	Indicates whether blog article URLs should be automatically redirected when their paths change.
RedirectNewHandle	Bool	Specifies whether Shopify should automatically redirect from an old blog handle to a new one after the handle is updated.
Metafields	String	Custom metadata attached to the blog, allowing apps and themes to store and retrieve additional structured information.