ADO.NET Provider for Outreach

Build 24.0.9060

Calls

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

Select

The provider 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 provider.

  • 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.

The allowed values are 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.

The allowed values are 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060