BlogTopics

Retrieve the available blog topics in HubSpot.

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		The blog topic id.
CreatedAt	Datetime		When the topic was created
DeletedAt	Datetime		When the topic was deleted.
Description	String		A description of the topic.
Name	String		The name of the topic.
Slug	String		How the topic will appear in the url.
UpdatedAt	Datetime		When the topic was last updated.
ExtraUrlParameters	String		An input only property for specifying additional parameters when selecting data from HubSpot. Specify the parameters as name=value pairs in a comma separated list. For instance, 'param1=value1,param2=value2,param3=value3'.