ComplianceRequests
Get details of compliance requests.
Select
The connector 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 connector.
- Id supports the '=,IN' operators.
- State supports the '=,IN' operators.
- UuId supports the '=,IN' operators.
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. |