CData Python Connector for Shopify

Build 23.0.8839

Comments

Create, read, update and delete the comments.

Table-Specific Information

Select

The connector processes all filters client-side within the connector. The following queries are the only ones processed server-side:
SELECT * FROM Comments WHERE Id = '123'

Insert

You must specify Article Id, Author, Body, Email to create a Comment.

INSERT INTO Comments (articleid, author, body, email) VALUES ('5557001', 'Harry', 'test', '[email protected]')

Update

You must specify the Id to update a Comment. For example:

UPDATE Comments SET Author = 'Adam' WHERE Id = '77171130'

Delete

You must specify the Id of the Comments to delete it.

DELETE FROM Comments WHERE Id = '555695'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

A unique numeric identifier for the comment.

BlogId Long False

Blogs.Id

A unique numeric identifier for the blog containing the article that the comment belongs to.

ArticleId Long False

Articles.Id

A unique numeric identifier for the article that the comment belongs to.

Author String False

The name of the author of the comment.

Body String False

The basic Textile markup of a comment.

BodyHtml String False

The text of the comment, complete with HTML markup.

CreatedAt Datetime True

The date and time (ISO 8601 format) when the comment was created.

Email String False

The email address of the author of the comment.

Ip String False

The IP address from which the comment was posted.

PublishedAt String False

The date and time (ISO 8601 format) when the comment was published.

Status String True

The status of the comment.

UpdatedAt Datetime True

The date and time (ISO 8601 format) when the comment was last modified.

UserAgent String False

The user agent string provided by the software used to create the comment.

PublishedStatus String False

Filter comments by their publish status. Valid values are: published, unpublished and any ; default: any.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839