Blogs

Create, read, update or delete blogs

Table-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the Handle column and Id. The connector processes other filters client-side within the connector.

Id supports the '=,IN' comparison.
Handle supports the '=,IN' comparison.

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

SELECT * FROM Blogs WHERE Id = '123'
SELECT * FROM Blogs WHERE Id IN ('123', '345')
SELECT * FROM Blogs WHERE Handle = 'new-blog-5927';
SELECT * FROM Blogs WHERE Handle IN ('new-blog-5927', 'new-blog-5926');

Insert

You must specify the Title to create a Blog.

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

INSERT INTO Blogs (Title, Metafields) VALUES ('new blog','[{"key":"sponsor","value":"shopify","type":"single_line_text_field","namespace":"global"}]')

Update

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

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

UPDATE Blogs SET Metafields='[{"key":"sponsor","value":"shopify","type":"single_line_text_field","namespace":"global"}]' WHERE Id='77171130'

Delete

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

DELETE FROM Blogs WHERE Id = '555695'

Columns


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.
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	False		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.