SSIS Components for Outreach

Build 26.0.9770

ContentCategoryMemberships

Gets details of a record that maps content to a content category.

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 queries are processed server-side:

SELECT * FROM ContentCategoryMemberships WHERE Id = 1

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

SELECT * FROM ContentCategoryMemberships WHERE Id >= 1

SELECT * FROM ContentCategoryMemberships WHERE Id < 2

SELECT * FROM ContentCategoryMemberships WHERE Id <= 2

SELECT * FROM ContentCategoryMemberships WHERE Id >= 1 AND Id <= 10

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

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

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

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

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

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

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

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

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

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

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

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

Columns

Name Type Description
Id [KEY] Integer Id of content category memberships.
CreatedAt Datetime The date and time the content category membership was created.
UpdatedAt Datetime The date and time the content category membership was last updated.
ContentCategoryId Integer The content category Id.
CreatorId Integer The Id of the creator.
CreatorType String The type of the creator.
Type String The type of the content category membership.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770