Blogposts
Returns all Blog Posts.
Table Specific Information
Select
The provider uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=' comparison.
- Url supports the '=' comparison.
- IsPublished supports the '=' comparison.
- PublishedDate supports the '=' comparison.
The rest of the filter is executed client-side within the provider.
For example, the following queries are processed server-side:
SELECT * FROM Blogposts WHERE Id = "1234" SELECT * FROM Blogposts WHERE IsPublished = "true"
Columns
Name | Type | References | 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. |