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