Calls

Get details of an inbound or outbound call made with a prospect.

Select

The 本製品 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 本製品.

Id supports the '=,IN,>=,<=,>,<' operators.
From supports the '=,IN' operators.
CreatedAt supports the '=,>=,<=,>,<' operators.
Outcome supports the '=,IN' operators.
State supports the '=,IN' operators.
To supports the '=,IN' operators.
UserCallType supports the '=,IN' operators.
UpdatedAt supports the '=,>=,<=,>,<' operators.

For example, the following query is processed server side:

SELECT * FROM Calls WHERE Id = 1

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

SELECT * FROM Calls WHERE Id >= 1

SELECT * FROM Calls WHERE Id <= 1

SELECT * FROM Calls WHERE Id > 1

SELECT * FROM Calls WHERE Id < 2

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

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

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

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

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

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

SELECT * FROM Calls WHERE UserCallType = 'bridge'

SELECT * FROM Calls WHERE UserCallType IN('bridge', 'test')

Columns


Name	Type	Description
Id [KEY]	Integer	Id of call.
AnsweredAt	Datetime	The date and time the call was answered.
CompletedAt	Datetime	The date and time the call was completed.
CreatedAt	Datetime	The date and time the call was created.
DialedAt	Datetime	The date and time the call was dialed.
Direction	String	The call direction from the user's point of view.
ExternalVendor	String	The voice provider of the call.
From	String	The phone number used to place the call.
Note	String	A custom note associated with this call.
Outcome	String	The calls outcome. 使用できる値は次のとおりです。Answered, Not Answered
RecordingDeletionReason	String	Recording Deletion Reason.
RecordingUrl	String	The URL of the calls audio recording.
ReturnedAt	Datetime	The date and time the call was returned.
SequenceAction	String	The action to take on the associated sequence.
ShouldRecordCall	Boolean	Indicated whether or not the call is recorded.
State	String	The calls current state.
StateChangedAt	Datetime	The date and time the calls state last changed.
Tags	String	A list of tag values associated with the call.
To	String	The phone number that the call was placed to.
Uid	String	The Outreach voice trace Id.
UpdatedAt	Datetime	The date and time the call was last updated.
UserCallType	String	The type of call placed within the Outreach client. 使用できる値は次のとおりです。bridge, voip
VendorCallId	String	The call-id as recorded by the voice provider.
VoicemailRecordingUrl	String	The URL of the calls voicemail audio recording.
LinksSelf	String	Link self.
BatchesLinks	String	Batches Links.
CallDispositionId	Integer	The associated call disposition Id.
CallDispositionType	String	The associated Call disposition type.
CallPurposeId	Integer	The associated call purpose Id.
CallPurposeType	String	The associated call purpose type.
OpportunityId	Integer	The associated opportunity Id.
PhoneNumberId	Integer	The associated phone number's Id.
ProspectId	Integer	The associated prospect Id.
SequenceId	Integer	The associated sequence Id.
SequenceStateId	Integer	The associated sequenceStates Id.
SequenceStepId	Integer	The associated sequence Step Id.
TaskId	Integer	The associated task's Id.
UserId	Integer	The associated user's Id.
Type	String	Type.

ODBC Driver for Outreach

Calls

Select

Columns