CData Python Connector for Shopify

Build 23.0.8839

Pages

Create, read, update or delete pages

Table-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the Id, CreatedAt, Handle, PublishedAt, Title, UpdatedAt, PublishedStatus columns. The following queries are the only ones processed server-side:
SELECT * FROM Pages

SELECT * FROM Pages WHERE Id = '123'

SELECT * FROM Pages WHERE CreatedAt > '2018-05-02'

SELECT * FROM Pages WHERE Handle = 'test'

SELECT * FROM Pages WHERE PublishedAt <= '2018-05-02'

SELECT * FROM Pages WHERE Title = 'new title'

SELECT * FROM Pages WHERE UpdatedAt >= '2018-05-02'

SELECT * FROM Pages WHERE PublishedStatus >= 'published'

Insert

You must specify the Title to create a Page.

INSERT INTO Pages (title) VALUES ('new Page')

Update

You must specify the id to update a Page. For example:

UPDATE Pages SET author = 'Harry' WHERE Id = '77171130'

Delete

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

DELETE FROM Pages WHERE Id = '555695'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

The unique numeric identifier for the page.

AdminGraphqlApiId String True

Displays the Admin Graphql API id.

Author String False

The name of the person who created the page.

BodyHtml String False

The text content of the page, complete with HTML markup.

CreatedAt Datetime True

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

Handle String False

A unique, human-friendly string for the page, generated automatically from its title. In online store themes, the Liquid templating language refers to a page by its handle.

Metafields String False

Additional information attached to the Page object.

PublishedAt Datetime False

The date and time (ISO 8601 format) when the page was published. Returns null when the page is hidden.

ShopId Long True

The ID of the shop to which the page belongs.

TemplateSuffix String False

The suffix of the Liquid template being used.

Title String False

The page's title.

UpdatedAt Datetime True

The date and time (ISO 8601 format) when the page was last updated.

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