Blogposts

Returns all Blog Posts.

Table Specific Information

Select

The driver will use the BigCommerce API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.

• Id supports the '=' comparison.

• Url supports the '=' comparison.

• IsPublished supports the '=' comparison.

• PublishedDate supports the '=' comparison.

For example, the following queries are processed server side:\

SELECT * FROM Blogposts SELECT * FROM Blogposts WHERE Id = "1234" SELECT * FROM Blogposts WHERE IsPublished = "true"

Columns

Name	Type	Description
Id [KEY]	Integer	Id of the blogpost
Title	String	Title of this blog post.
URL	String	URL for the public blog post.
PreviewURL	String	URL to preview the blog post.
Body	String	Text body of the blog post.
Summary	String	Summary of the blog post.
IsPublished	Boolean	Whether the blog post is published.
PublishedDate	Datetime	Date when the blogpost was published.
PublishedTimezone	String	Timezone when the blogpost was published.
PublishedTimezoneType	String	Type of the timezone.
PublishedDateISO	String	Published date in ISO8601 format.
MetaDescription	String	Description text for this blog posts meta element.
MetaKeywords	String	Keywords for this blog posts meta element.
Author	String	Name of the blog posts author.
ThumbnailPath	String	Local path to a thumbnail image within the product_images folder to accompany the blog post.