BlogTopics

Lists all blog topics available in HubSpot, used to categorize and organize blog posts effectively.

Table Specific Information

Blog topics represent any number of topics a blog post can be posted under.

When selecting blogs, they can only be filtered by the Id, Name, Slug, and CreatedAt. CreatedAt can be used to specify a range. For example:

SELECT * FROM BlogTopics WHERE CreatedAt >= '1/1/2014' AND CreatedAt <= '10/31/2014'
SELECT * FROM BlogTopics WHERE Name = 'mytopic'


Name	Type	References	Description
Id [KEY]	Long		Unique identifier assigned to the blog topic.
CreatedAt	Datetime		Timestamp indicating when the blog topic was originally created.
DeletedAt	Datetime		Timestamp marking when the blog topic was deleted, if applicable.
Description	String		Descriptive text explaining the purpose or focus of the blog topic.
Name	String		Name of the blog topic, used to categorize blog posts.
Slug	String		URL-friendly slug that determines how the topic appears in the URL path.
UpdatedAt	Datetime		Timestamp indicating the last time the blog topic record was updated.
ExtraUrlParameters	String		Optional input-only property to specify additional query parameters when retrieving blog topic data. Format: 'param1=value1, param2=value2, param3=value3'.