Blogposts

Returns all blog posts.

Table Specific Information

The connector 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 connector. For example, the following queries are processed server-side:

SELECT * FROM Blogposts WHERE Id = "1234" 

SELECT * FROM Blogposts WHERE IsPublished = "true"


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