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. The connector processes other filters client-side within the connector.
- Id supports the '=,IN' comparison operators.
- Title supports the '=,!=' comparison operators.
- Handle supports the '=,IN' comparison operators.
- CreatedAt supports the '=,!=,<,>,>=,<=' comparison operators.
- UpdatedAt supports the '=,!=,<,>,>=,<=' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM Blogs
SELECT * FROM Blogs WHERE Id = 'Val1'
SELECT * FROM Blogs WHERE Title = 'Val1'
SELECT * FROM Blogs WHERE Handle = 'Val1'
SELECT * FROM Blogs WHERE CreatedAt = '2023-01-01 11:10:00'
SELECT * FROM Blogs WHERE UpdatedAt = '2023-01-01 11:10:00'
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. |