Categories

Returns information about WordPress categories, including their names, descriptions, and post counts.

Table Specific Information

The connector uses the WordPress API to process some of the filters.

The connector processes other filters client-side within the connector.

For example, the following queries are processed server side.

SELECT * FROM Categories WHERE Slug = 'test'

To insert a category the following column is required: Name.

INSERT INTO Categories (Description, Name, Parent) VALUES ('This is an example Category', 'myCategory', '138')

To update a category you must specify the following column: Id.

UPDATE Categories SET Name = 'updatedName', Description = 'Updated description.', Parent = 137 WHERE Id = '139'

To delete a category you must specify the following column: Id.

DELETE FROM Categories WHERE Id = '139'


Name	Type	ReadOnly	References	Description
Slug	String	True		The slug assigned to the category in WordPress. This is a URL-friendly string derived from the category name and used in site URLs and API endpoints.
ID [KEY]	String	True		A unique integer that identifies the category in WordPress and links posts, tags, and other taxonomy data associated with that category.
Name	String	False		The category name defined in WordPress, representing the label shown on the site and used to organize related posts.
Description	String	False		The descriptive text defined in WordPress for the category, typically used to explain its purpose or the type of posts it contains.
FeedURL	String	True		The URL of the RSS feed for posts in this category.
MetaAggregate	String	False		Contains aggregated metadata for the category, combining key details returned by WordPress.
Parent	Integer	True		The identifier of the parent category that this category belongs to. A value of 0 indicates that the category has no parent.
PostCount	Integer	True		Indicates how many posts are associated with this category in WordPress.