ArticleComments
List of article comments.
Table-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.
- ArticleId supports the '=, IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM ArticleComments WHERE Id = 'Val1'
SELECT * FROM ArticleComments WHERE ArticleId = 'Val1'
Delete
You can delete entries by specifying the following column:
Id
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A globally-unique ID. | |
| ArticleId | String | True |
A globally-unique ID. | |
| ArticleTitle | String | True |
The title of the article. | |
| Body | String | True |
The content of the comment. | |
| BodyHtml | String | True |
The content of the comment, complete with HTML formatting. | |
| Status | String | True |
The status of the comment. | |
| Ip | String | True |
The IP address of the commenter. | |
| UserAgent | String | True |
The user agent of the commenter. | |
| AuthorName | String | True |
The author’s name. | |
| AuthorEmail | String | True |
The author's email. | |
| IsPublished | Bool | True |
Whether or not the comment is published. | |
| PublishedAt | Datetime | True |
The date and time when the comment was published. | |
| UpdatedAt | Datetime | True |
The date and time when the comment was last updated. | |
| CreatedAt | Datetime | True |
The date and time when the comment was created. |