Excel Add-In for BigCommerce

Build 23.0.8839


Returns all Blog Posts.

Table Specific Information


The 本製品 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 本製品.

For example, the following queries are processed server-side:

SELECT * FROM Blogposts WHERE Id = "1234" 

SELECT * FROM Blogposts WHERE IsPublished = "true"


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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839