Articles
Returns a list of the shop's visible articles.
View-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.
- Id supports the '=,IN' comparison operators.
- AuthorV2Name supports the '=,!=' comparison operators.
- AuthorV2FirstName supports the '=,!=' comparison operators.
- AuthorV2LastName supports the '=,!=' comparison operators.
- BlogTitle supports the '=,!=' comparison operators.
- CreatedAt supports the '=,!=,<,>,>=,<=' comparison operators.
- UpdatedAt supports the '=,!=,<,>,>=,<=' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM Articles
SELECT * FROM Articles WHERE Id = 'Val1'
SELECT * FROM Articles WHERE AuthorV2Name = 'Val1'
SELECT * FROM Articles WHERE AuthorV2FirstName = 'Val1'
SELECT * FROM Articles WHERE AuthorV2LastName = 'Val1'
SELECT * FROM Articles WHERE BlogTitle = 'Val1'
SELECT * FROM Articles WHERE CreatedAt = '2023-01-01 11:10:00'
SELECT * FROM Articles WHERE UpdatedAt = '2023-01-01 11:10:00'
Columns
Name | Type | References | Description |
Id [KEY] | String | A globally-unique ID. | |
Title | String | The article's name. | |
Handle | String | A human-friendly unique string for the Article automatically generated from its title. | |
Tags | String | A categorization that a article can be tagged with. | |
ContentHtml | String | The content of the article, complete with HTML formatting. | |
ExcerptHtml | String | The excerpt of the article, complete with HTML formatting. | |
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. | |
PublishedAt | Datetime | The date and time when the article was published. | |
AuthorV2Name | String | The author's full name. | |
AuthorV2FirstName | String | The author's first name. | |
AuthorV2LastName | String | The author's last name. | |
AuthorV2Bio | String | The author's bio. | |
AuthorV2Email | String | The author's email. | |
BlogId | String | A globally-unique ID. | |
BlogTitle | String | The blogs's title. | |
ImageId | String | A unique ID for the image. | |
ImageWidth | Int | The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify. | |
ImageAltText | String | A word or phrase to share the nature or contents of an image. | |
ImageHeight | Int | The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify. | |
ImageUrl | String | The location of the image as a URL. | |
SeoTitle | String | The SEO title. | |
SeoDescription | String | The meta description. | |
CreatedAt | Datetime | The date and time when the article was created. This column can only be used as an input for filtering. | |
UpdatedAt | Datetime | The date and time when the article was last updated. This column can only be used as an input for filtering. |