CData Python Connector for Shopify

Build 23.0.8839

Articles

Create, read, update or delete articles

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

ImageAlt String False

Alternative text that describes the image.

ImageCreatedAt Datetime True

The date and time when image is created.

ImageHeight Int False

Height of the image.

ImageSrc String False

A source URL that specifies the location of the image.

ImageWidth Int False

Width of the image.

ImageAttachment 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.

TemplateSuffix 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.

PublishedStatus String False

Filter articles 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