TDV Adapter for Outreach

Build 22.0.8462

Events

Get details of application events, capturing details around the initiator, recipient.

Select

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

  • Id supports the '=,IN,>=,<=,>,<' operators.
  • Name supports the '=,IN' operators.
  • CreatedAt supports the '=,>=,<=,>,<' operators.
  • EventAt supports the '=,>=,<=,>,<' operators.
  • ProspectId supports the '=' operator.
  • MailingId supports the '=' operator.
  • UserId supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM Events WHERE Id = 1

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

SELECT * FROM Events WHERE Id >= 1

SELECT * FROM Events WHERE Id <= 1

SELECT * FROM Events WHERE Id > 1

SELECT * FROM Events WHERE Id < 2

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

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

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

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

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

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

SELECT * FROM Events WHERE EventAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Events WHERE ProspectId = 1

SELECT * FROM Events WHERE MailingId = 1

SELECT * FROM Events WHERE UserId = 1

Columns

Name Type Description
Id [KEY] Integer Id of Email Address.
Body String The event body.
CreatedAt Datetime The date and time the event was created.
EventAt Datetime The date and time the event occurred.
ExternalUrl String The external URL associated with this event.
Name String The name of the event that took place.
Payload String The transmitted data for the event.
RequestCity String The city where the request that created the event was made.
RequestDevice String The type of device on which the request that created the event was made.
RequestHost String Name of the host from which the request was made.
RequestProxied Boolean A boolean value indicating whether or not the request was proxied.
RequestRegion String Name of the region from which the request was made.
LinksSelf String Link self.
MailingId Integer Mailing Id.
ProspectId Integer Prospect's Id.
ProspectType String Prospect's type.
UserId Integer User's Id.
Type String Type.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462