TDV Adapter for Outreach

Build 22.0.8462

SequenceStates

Get details of sequence states.

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.
  • ClickCount supports the '=,IN,>=,<=,>,<' operators.
  • CallCompletedAt supports the '=,>=,<=,>,<' operators.
  • CreatedAt supports the '=,>=,<=,>,<' operators.
  • DeliverCount supports the '=,IN,>=,<=,>,<' operators.
  • OpenCount supports the '=,IN,>=,<=,>,<' operators.
  • PauseReason supports the '=,IN' operators.
  • RepliedAt supports the '=,>=,<=,>,<' operators.
  • ReplyCount supports the '=,IN,>=,<=,>,<' operators.
  • State supports the '=' operator.
  • StateChangedAt supports the '=,>=,<=,>,<' operators.
  • UpdatedAt supports the '=,>=,<=,>,<' operators.
  • AccountId supports the '=' operator.
  • ProspectId supports the '=' operator.
  • SequenceId supports the '=' operator.
  • SequenceStepId supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM SequenceStates WHERE Id = 1

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

SELECT * FROM SequenceStates WHERE Id >= 1

SELECT * FROM SequenceStates WHERE Id <= 1

SELECT * FROM SequenceStates WHERE Id > 1

SELECT * FROM SequenceStates WHERE Id < 2

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

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

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

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

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

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

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

SELECT * FROM SequenceStates WHERE DeliverCount = 0

SELECT * FROM SequenceStates WHERE Name = 'test'

SELECT * FROM SequenceStates WHERE ProspectId = 1

SELECT * FROM SequenceStates WHERE AccountId = 1

SELECT * FROM SequenceStates WHERE SequenceId = 1

Columns

Name Type Description
Id [KEY] Integer Id of sequence state.
ActiveAt Datetime The date and time the sequence state was last active.
BounceCount Integer The total count of bounced mailings during this sequence state.
CallCompletedAt Datetime The date and time the sequence state last had a call completed.
ClickCount Integer The total count of clicked mailings from this sequence state.
CreatedAt Datetime The date and time the sequence state was created.
DeliverCount Integer The total count of delivered mailings from this sequence state.
ErrorReason String The reason for the most recent error.
FailureCount Integer The total count of failed mailings from this sequence state.
NegativeReplyCount Integer The total count of negative reply mailings from this sequence state.
NeutralReplyCount Integer The total count of neutral reply mailings from this sequence state.
OpenCount Integer The total count of opened mailings from this sequence state.
OptOutCount Integer The total count of opted out mailings from this sequence state.
PauseReason String The reason for the most recent pause.
PositiveReplyCount Integer The total count of positive reply mailings from this sequence state.
RepliedAt Datetime The date and time the sequence state last had a mailing reply.
ReplyCount Integer The total count of replied mailings from this sequence state.
ScheduleCount Integer The total count of scheduled mailings from this sequence state.
State String The current state of the sequence state.
StateChangedAt Datetime The date and time the sequence state's state last changed.
UpdatedAt Datetime The date and time the sequence state was last updated.
LinksSelf String Link self.
AccountId Integer Account Id.
AccountType String Account type.
CreatorId Integer Creator Id.
CreatorType String Creator type.
MailboxId Integer Mailbox Id.
MailboxType String MailBox type.
ProspectId Integer Prospect Id.
ProspectType String Prospect type.
SequenceId Integer Sequence Id.
SequenceType String Sequence type.
SequenceStepId Integer Sequence step's Id.
SequenceStepType String Sequence step's type.
Type String Type.

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