ArticleComments
Stores comments posted on blog articles, including author, content, and moderation status.
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 unique identifier for the article comment record. | |
| ArticleId | String | True |
The unique identifier of the article to which this comment belongs. | |
| ArticleTitle | String | True |
The title of the article where the comment was posted. | |
| Body | String | True |
The plain-text content of the comment as submitted by the author. | |
| BodyHtml | String | True |
The HTML-formatted version of the comment content, preserving styling and markup. | |
| Status | String | True |
The current moderation status of the comment, such as approved, pending, or spam. | |
| Ip | String | True |
The IP address from which the comment was submitted, used for moderation or tracking purposes. | |
| UserAgent | String | True |
Information about the commenter's browser and operating system, as provided by the user agent string. | |
| AuthorName | String | True |
The display name of the individual who submitted the comment. | |
| AuthorEmail | String | True |
The email address provided by the commenter, used for identification or follow-up communication. | |
| IsPublished | Bool | True |
Indicates whether the comment has been published and made visible on the article page. | |
| PublishedAt | Datetime | True |
The timestamp when the comment was published and became visible on the article. | |
| UpdatedAt | Datetime | True |
The timestamp when the comment was last edited or modified. | |
| CreatedAt | Datetime | True |
The timestamp when the comment was originally created in the system. |