Blogs

Create, read, update or delete blogs

Table-Specific Information

The adapter processes all filters client-side within the adapter. The following queries are the only ones processed server side:

SELECT * FROM Blogs

SELECT * FROM Blogs WHERE Id='123'

You must specify the Title to create a Blog.

INSERT INTO Blogs(title) VALUES ('new blog')

You must specify the id to update a Blog. For example:

UPDATE Blogs SET title='new blog' WHERE Id = '77171130'

You must specify the Id of the Blog to delete it.

DELETE FROM Blogs WHERE Id = '555695'

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the blog.
AdminGraphqlApiId	String	True		Displays the Admin Graphql API id.
Commentable	String	False		Indicates whether readers can post comments to the blog and if comments are moderated or not. The allowed values are no, yes, moderate. The default value is no.
CreatedAt	Datetime	True		The date and time when the blog was created.
Feedburner	String	False		Feedburner is a web feed management provider and can be enabled to provide custom RSS feeds for Shopify bloggers. This property will default to blank or null unless feedburner is enabled through the shop admin.
FeedburnerLocation	String	False		URL to the feedburner location for blogs that have enabled feedburner through their store admin. This property will default to blank or null unless feedburner is enabled through the shop admin.
Handle	String	False		A human-friendly unique string for a blog automatically generated from its title.
Metafields	String	True		Attaches additional metadata to a store's resources.
Tags	String	False		Tags are additional short descriptors formatted as a string of comma-separated values.
TemplateSuffix	String	False		States the name of the template a blog is using if it is using an alternate template. If a blog is using the default blog.liquid template, the value returned is null.
Title	String	False		The title of the blog.
UpdatedAt	Datetime	True		The date and time when changes were last made to the blog's properties.