ComplianceRequests

Get details of compliance requests.

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.
State supports the '=,IN' operators.
UuId supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM ComplianceRequests WHERE Id = 1

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

SELECT * FROM ComplianceRequests WHERE State = 'test'

SELECT * FROM ComplianceRequests WHERE uuid = '12345'

SELECT * FROM ComplianceRequests WHERE uuid IN (1, 2)

Columns


Name	Type	Description
Id [KEY]	Integer	Id of compliance request.
BatchComplianceRequestUuid	String	The UUID of the batch the compliance request belongs to.
CreatedAt	Datetime	The date and time the compliance request was created.
ObjectType	String	The type of record to process.
RequestObjectId	String	The identifier for the record processed for prospects. This is the prospect Id for recipients. This is an e-mail address.
RequesterId	Integer	The ID of the Outreach user who submitted the compliance request.
RequestType	String	The type of compliance request.
State	String	The current state of the compliance request.
UpdatedAt	Datetime	The date and time at which the compliance request was last updated.
UuId	String	The UUID of the compliance request.

SSIS Components for Outreach

ComplianceRequests

Select

Columns