Power BI Connector for BigCommerce

Build 21.0.7930


Returns all Blog Posts.

Table Specific Information


The {i 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 {i.

  • 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"


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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930