PhoneNumbers

Get details of prospect phone numbers.

Select

The add-in 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 add-in.

Id supports the '=,IN,>=,<=,>,<' operators.
Number supports the '=,IN' operators.
Order supports the '=,>=,<=,>,<' operator.
PhoneType supports the '=' operator.
Status supports the '=' operator.
StatusChangedAt supports the '=,>=,<=,>,<' operators.
UpdatedAt supports the '=,>=,<=,>,<' operators.

For example, the following query is processed server side:

SELECT * FROM PhoneNumbers WHERE Id = 1

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

SELECT * FROM PhoneNumbers WHERE Id >= 1

SELECT * FROM PhoneNumbers WHERE Id <= 1

SELECT * FROM PhoneNumbers WHERE Id > 1

SELECT * FROM PhoneNumbers WHERE Id < 2

SELECT * FROM PhoneNumbers WHERE StatusChangedAt <= '2022-02-25 01:02:02.0'

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

SELECT * FROM PhoneNumbers WHERE StatusChangedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM PhoneNumbers WHERE StatusChangedAt = '2022-02-25 01:02:02.0'

SELECT * FROM PhoneNumbers WHERE StatusChangedAt < '2022-02-25 01:02:02.0'

SELECT * FROM PhoneNumbers WHERE StatusChangedAt > '2022-02-25 01:02:02.0'

SELECT * FROM PhoneNumbers WHERE Number = '+919876543210'

SELECT * FROM PhoneNumbers WHERE UpdatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM PhoneNumbers WHERE PhoneType = 'work'

Columns


Name	Type	Description
Id [KEY]	Integer	Id of phone numbers.
CountryCode	String	The country code.
CreatedAt	Datetime	The date and time the phone number was created.
Extension	String	Phone number extension.
Number	String	The phone number.
OrderValue	Integer	Ordered position in list of numbers.
PhoneType	String	Type of phone. Possible values are 'mobile', 'work', 'home', 'voip', 'other', etc.
RawNumber	String	Unformatted phone number.
Status	String	The status of the number.
StatusChangedAt	Datetime	Time the status was updated.
UpdatedAt	Datetime	The date and time the phone number was last updated.
LinksSelf	String	Link self.
ProspectId	Integer	Prospect's Id.
ProspectType	String	Prospect type.
Type	String	Type.

Excel Add-In for Outreach

PhoneNumbers

Select

Columns