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.