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.

Last updated