Categories

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

Table-Specific Information

The component uses the WordPress API to process the following filter server-side. Other filters are processed client-side within the component.

For example, the following query is processed server-side.

SELECT * FROM Categories WHERE Slug = 'test'

To insert a category, the following columns are required: Name and Slug.

INSERT INTO Categories (Name, Slug) VALUES ('randomname', 'test')

To update a category, you must specify the following columns: Name and ID.

UPDATE Categories SET Name = 'updatedName', Description = 'Updated description.' WHERE ID = '155863483'

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.