ContentCategories

Get details of content categories.

Select

The component will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the component.

Id supports the '=,IN,>=,<=,>,<' operators.
CreatedAt supports the '=,>=,<=,>,<' operators.
UpdatedAt supports the '=,>=,<=,>,<' operators.

For example, the following query is processed server side:

SELECT * FROM ContentCategories WHERE Id = 1

SELECT * FROM ContentCategories WHERE Id IN (1, 2)

SELECT * FROM ContentCategories WHERE Id >= 1

SELECT * FROM ContentCategories WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE UpdatedAt >= '2022-01-25 01:02:02.0 ' AND UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE UpdatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE UpdatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM ContentCategories WHERE UpdatedAt > '2022-02-25 01:02:02.0'

Columns


Name	Type	Description
Id [KEY]	Integer	Id of Content Category.
AllowSequences	Boolean	Whether or not this category be used to group sequences.
AllowSnippets	Boolean	Whether or not this category be used to group snippets.
AllowTemplates	Boolean	Whether or not this category be used to group templates.
Color	String	Color of the content category to be used as a background.
CreatedAt	Datetime	The date and time the content category was created.
Name	String	The name of the content category.
UpdatedAt	Datetime	The date and time the content category was last updated.
LinksSelf	String	Link self.
CreatorId	Integer	Creator Id.
CreatorType	String	Creator type.
Type	String	Types.

SSIS Components for Outreach

ContentCategories

Select

Columns