Articles
Create, read, update or delete articles
Table-Specific Information
Select
The adapter processes all filters client-side within the adapter. The following queries are the only ones processed server side:
SELECT * FROM Articles
SELECT * FROM Articles WHERE Id='123'
Insert
You must specify the Title to create an Article.
INSERT INTO Articles(BlogId,Author,Title) VALUES ('599421749','Adam','New Article')
Update
You must specify the blog id and id to update an article. For example:
UPDATE Articles SET Author='Harry' WHERE BlogId = '599421749' AND Id = '5557081211'
Delete
You must specify the Id and the Blog Id of the article to delete it.
DELETE FROM Articles WHERE BlogId = '599421749' AND Id = '5556952105'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
The ID of the article. | |
| BlogId [KEY] | Long | False |
Blogs.Id |
The ID of the blog containing the article. |
| AdminGraphqlApiId | String | True |
Displays the Admin Graphql API id. | |
| Author | String | False |
The name of the author of the article. | |
| BodyHtml | String | False |
The text of the body of the article, complete with HTML markup. | |
| CreatedAt | Datetime | True |
The date and time (ISO 8601 format) when the article was created. | |
| Handle | String | False |
A human-friendly unique string for the article that's automatically generated from the article's title. The handle is used in the article's URL. | |
| Image.alt | String | False |
Alternative text that describes the image. | |
| Image.createdAt | Datetime | True |
The date and time when image is created. | |
| Image.height | Integer | False |
Height of the image. | |
| Image.src | String | False |
A source URL that specifies the location of the image. | |
| Image.width | Integer | False |
Width of the image. | |
| Image.attachment | String | False |
An image attached to article returned as Base64-encoded binary data. | |
| PublishedAt | Datetime | False |
The date and time (ISO 8601 format) when the article was published. | |
| SummaryHtml | String | False |
A summary of the article, complete with HTML markup. | |
| Tags | String | False |
Tags are additional short descriptors formatted as a string of comma-separated values. | |
| Template_suffix | String | False |
The name of the template an article is using if it's using an alternate template. If an article is using the default article.liquid template, then the value returned is null. | |
| Title | String | False |
The title of the article. | |
| UpdatedAt | Datetime | True |
The date and time (ISO 8601 format) when the article was last updated. | |
| UserId | Long | True |
A unique numeric identifier for the author of the article. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| published_status | String |
Filter articles by their publish status. Valid values are: published, unpublished and any ; default: any. |