Blogs
Retrieves a list of the shop's blogs.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=,IN' comparison operators.
- Title supports the '=,!=' comparison operators.
- Handle supports the '=' comparison operator.
- CreatedAt supports the '=,!=,<,>,>=,<=' comparison operators.
- UpdatedAt supports the '=,!=,<,>,>=,<=' comparison operators.
The connector processes other filters client-side within the connector.
For example, the following queries are processed server-side:
SELECT * FROM Blogs WHERE Id='VALUE'
SELECT * FROM Blogs WHERE Title='VALUE'
SELECT * FROM Blogs WHERE Handle='VALUE'
SELECT * FROM Blogs WHERE CreatedAt<'2000-01-01 01:00:00.0'
SELECT * FROM Blogs WHERE UpdatedAt<'2000-01-01 01:00:00.0'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally-unique ID. | |
| Title | String | The blogs's title. | |
| Handle | String | A human-friendly unique string for the Blog automatically generated from its title. | |
| OnlineStoreUrl | String | The URL used for viewing the resource on the shop's Online Store. Returns 'null' if the resource is currently not published to the Online Store sales channel. | |
| SeoTitle | String | The SEO title. | |
| SeoDescription | String | The meta description. | |
| CreatedAt | Datetime | The date and time when the blog was created. This column can only be used as an input for filtering. | |
| UpdatedAt | Datetime | The date and time when the blog was last updated. This column can only be used as an input for filtering. |