CData Python Connector for Shopify

Build 23.0.8839

Blogs

Create, read, update or delete blogs

Table-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the Handle column and Id. The connector processes other filters client-side within the connector.
  • Id supports the '=,IN' comparison.
  • Handle supports the '=,IN' comparison.
For example, the following queries are processed server-side.
SELECT * FROM Blogs WHERE Id = '123'
SELECT * FROM Blogs WHERE Id IN ('123', '345')
SELECT * FROM Blogs WHERE Handle = 'new-blog-5927';
SELECT * FROM Blogs WHERE Handle IN ('new-blog-5927', 'new-blog-5926');

Insert

You must specify the Title to create a Blog.

INSERT INTO Blogs (title) VALUES ('new blog')

INSERT INTO Blogs (Title, Metafields) VALUES ('new blog','[{"key":"sponsor","value":"shopify","type":"single_line_text_field","namespace":"global"}]')

Update

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

UPDATE Blogs SET title = 'new blog' WHERE Id = '77171130'

UPDATE Blogs SET Metafields='[{"key":"sponsor","value":"shopify","type":"single_line_text_field","namespace":"global"}]' WHERE Id='77171130'

Delete

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

DELETE FROM Blogs WHERE Id = '555695'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

A unique numeric identifier for the blog.

AdminGraphqlApiId String True

Displays the Admin Graphql API id.

Commentable String False

Indicates whether readers can post comments to the blog and if comments are moderated or not.

CreatedAt Datetime True

The date and time when the blog was created.

Feedburner String False

Feedburner is a web feed management provider and can be enabled to provide custom RSS feeds for Shopify bloggers. This property will default to blank or null unless feedburner is enabled through the shop admin.

FeedburnerLocation String False

URL to the feedburner location for blogs that have enabled feedburner through their store admin. This property will default to blank or null unless feedburner is enabled through the shop admin.

Handle String False

A human-friendly unique string for a blog automatically generated from its title.

Metafields String False

Attaches additional metadata to a store's resources.

Tags String False

Tags are additional short descriptors formatted as a string of comma-separated values.

TemplateSuffix String False

States the name of the template a blog is using if it is using an alternate template. If a blog is using the default blog.liquid template, the value returned is null.

Title String False

The title of the blog.

UpdatedAt Datetime True

The date and time when changes were last made to the blog's properties.

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