Blogposts
Returns all Blog Posts.
Table Specific Information
Select
The adapter 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 adapter.
- 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. |