ProspectNotes

Get details of notes related to prospects.

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 '=' operators.
ProspectId supports the '=' operators.
CreatedAt supports the '=,>=,<=,>,<' operators.

For example, the following query is processed server side:

SELECT * FROM ProspectNotes WHERE Id = '12345'

SELECT * FROM ProspectNotes WHERE ProspectId = '54321'

SELECT * FROM ProspectNotes WHERE CreatedAt = '2026-06-26 01:02:02.0'

Columns


Name	Type	Description
Id [KEY]	Integer	Id of prospect note.
CreatedAt	Datetime	The date and time the prospect note was created.
Message	String	The text content of this prospect note.
NoteType	String	The context of this prospect note. The allowed values are note, call, coffee, beer, meeting.
OpportunityAssociationRule	String	The rule used to associate the prospect note with an opportunity. The allowed values are recent_created, recent_updated.
Pinned	Boolean	A boolean value indicating whether this prospect note is pinned.
ProspectId	Integer	The associated prospect Id.
ProspectType	String	The associated prospect type.
ProspectLinks	String	The associated prospect links.
CreatorId	Integer	The creator of the prospect note.
CreatorType	String	The creator type.
CreatorLinks	String	The associated creator Links.
OpportunityId	Integer	The associated opportunity Id.
OpportunityType	String	The associated opportunity type.
OpportunityLinks	String	The associated opportunity Links.
Type	String	Type.

JDBC Driver for Outreach

ProspectNotes

Select

Columns