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