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