Articles
Returns a list of the shop's visible articles.
View-Specific Information
Select
The add-in uses the Shopify API to process WHERE clause conditions built with the following columns and operators:
- 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.
The add-in processes other filters client-side within the add-in.
For example, the following queries are processed server-side:
SELECT * FROM Articles WHERE Id='VALUE'
SELECT * FROM Articles WHERE AuthorV2Name='VALUE'
SELECT * FROM Articles WHERE AuthorV2FirstName='VALUE'
SELECT * FROM Articles WHERE AuthorV2LastName='VALUE'
SELECT * FROM Articles WHERE BlogTitle='VALUE'
SELECT * FROM Articles WHERE CreatedAt<'2000-01-01 01:00:00.0'
SELECT * FROM Articles WHERE UpdatedAt<'2000-01-01 01:00:00.0'
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. |