JDBC Driver for Shopify

Build 25.0.9434

ArticleComments

List of article comments.

Table-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.
  • 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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434