Accounts

Get details of accounts.

Select

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

Id supports the '=,IN,>=,<=,>,<' operators.
BuyerIntentScore supports the '=,>=,<=,>,<' operators.
CreatedAt supports the '=,>=,<=,>,<' operators.
CustomId supports the '=' operator.
Domain supports the '=,IN' operators.
Name supports the '=,IN' operators.
Nammed supports the '=,IN' operators.
SharingTeamId supports the '=,IN' operators.
TouchedAt supports the '=,>=,<=,>,<' operators.
UpdatedAt supports the '=,>=,<=,>,<' operators.

For example, the following query is processed server side:

SELECT * FROM Accounts WHERE Id = 1

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

SELECT * FROM Accounts WHERE Id >= 1

SELECT * FROM Accounts WHERE Id <= 1

SELECT * FROM Accounts WHERE Id > 1

SELECT * FROM Accounts WHERE Id < 2

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

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

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

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

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

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

SELECT * FROM Accounts WHERE CustomId = 1

SELECT * FROM Accounts WHERE BuyerIntentScore = 1

SELECT * FROM Accounts WHERE SharingTeamId = 1

Columns


Name	Type	Description
Id [KEY]	Integer	Id of Account.
BuyerIntentScore	Double	A custom score given to measure the quality of the account.
CompanyType	String	A description of the company type.
CreatedAt	Datetime	The date and time the account was created.
CustomId	String	A custom ID for the account often referencing an ID in an external system.
Description	String	A custom description of the account.
Domain	String	The company website domain.
ExternalSource	String	The source of the resource creation.
Followers	String	The number of followers the company has listed on social media.
FoundedAt	Datetime	The founding date of the company.
Industry	String	A description of the company industry.
LinkedInEmployees	String	The number of employees listed on the company LinkedIn URL.
LinkedInUrl	String	The company LinkedIn URL.
Locality	String	The company primary geographic region.
Name	String	The name of the company.
Named	Boolean	A boolean value determining whether this is a named account or not. Only named accounts will show up on the collection index.
NaturalName	String	The natural name of the company.
NumberOfEmployees	String	The number of employees working at the company.
SharingTeamId	String	The ID of the sharing team associated with this object. Access is currently in beta.
Tags	String	A list of tag values associated with the account.
TouchedAt	String	The date and time the account was last touched.
TrashedAt	String	The date and time the account was last trashed.
UpdatedAt	Datetime	The date and time the account was last updated.
WebsiteUrl	String	The company website URL.
LinksSelf	String	Link self.
CreatorId	Integer	Creator Id.
CreatorType	String	Creator type.
OwnerId	Integer	Owner Id.
OwnerType	String	Owner type.
ProspectsLinks	String	Prospects links.
TasksLinks	String	Tasks links.
UpdaterId	Integer	Updater Id.
UpdaterType	String	Updater type.
Type	String	Type.

JDBC Driver for Outreach

Accounts

Select

Columns