Lists the shop's blogs with titles, handles, and metadata.

Table-Specific Information

Select

The server uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The server processes other filters client-side within the server.

• 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		The globally unique identifier of the blog.
Title	String	False		The display title of the blog.
Handle	String	False		A unique, human-readable string for the blog. If not provided, the handle is automatically generated from the blog title. The handle can be customized and is used in the Liquid templating language to reference the blog.
Tags	String	True		A list of tags applied to the 200 most recent articles in the blog.
TemplateSuffix	String	False		The name of the alternate template applied to the blog. Returns null if the default 'blog.liquid' template is used.
ArticlesCount	Int	True		The number of articles in the blog.
ArticlesCountPrecision	String	True		The level of precision applied to the article count value.
CommentPolicy	String	False		Indicates whether readers can post comments on the blog and whether comments require moderation.
FeedLocation	String	True		The URL of the blog's feed provider.
FeedPath	String	True		The path to the blog's feed provider.
UpdatedAt	Datetime	True		The date and time when the blog was most recently updated.
CreatedAt	Datetime	True		The date and time when the blog was created.

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 articles are automatically redirected.
RedirectNewHandle	Bool	Indicates whether a redirect is automatically created when the blog handle changes. If true, the old handle redirects to the new one.
Metafields	String	Additional metadata fields attached to the blog resource.