Blogposts

Returns blog posts, including title, body, and publishing details.

Table-Specific Information

The driver uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

The rest of the filter is executed client-side within the driver. For example, the following queries are processed server-side:

SELECT * FROM Blogposts WHERE Id = "1234" 

SELECT * FROM Blogposts WHERE IsPublished = "true"

To insert a blog post, specify at least the following columns: Title and Body.

INSERT INTO BlogPosts (Title, Body, Tags) VALUES ('Welcome to BigCommerce!!!', 'Test insert Operations.', 'Blog,SEO')

The following is an example of how to update the BlogPosts table:

UPDATE BlogPosts SET Body = 'Customize your site. Update Body', MetaKeywords = 'This' WHERE Id = 12

The following is an example of how to delete from the BlogPosts table:

DELETE FROM BlogPosts WHERE Id = 13


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	The unique identifier of the blog post.
Title	String	False	The title of this blog post.
URL	String	False	The URL for the public blog post.
PreviewURL	String	True	The URL used to preview the blog post.
Body	String	False	The text body of the blog post.
Summary	String	True	The summary of the blog post.
IsPublished	Boolean	False	Indicates whether the blog post is published.
PublishedDate	Datetime	False	The date when the blog post was published.
PublishedTimezone	String	False	The timezone associated with the blog post's published date.
PublishedTimezoneType	Integer	False	The type of the published date timezone.
PublishedDateISO	String	False	The published date in ISO 8601 format.
MetaDescription	String	False	The description text for this blog post's meta element.
MetaKeywords	String	False	The keywords for this blog post's meta element.
Author	String	False	The name of the blog post's author.
ThumbnailPath	String	False	The local path to a thumbnail image within the product_images folder to accompany the blog post.
Tags	String	False	A list of tags that characterize the blog post.