Stages

The point in the process used for categorizing prospects.

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.
CreatedAt supports the '=,>=,<=,>,<' operators.
Name supports the '=,IN' operators.
Order supports the '=,IN,>=,<=,>,<' operators.
UpdatedAt supports the '=,>=,<=,>,<' operators.

For example, the following query is processed server side:

SELECT * FROM Stages WHERE Id = 1

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

SELECT * FROM Stages WHERE Id >= 1

SELECT * FROM Stages WHERE Id <= 1

SELECT * FROM Stages WHERE Id > 1

SELECT * FROM Stages WHERE Id < 2

SELECT * FROM Stages WHERE Name IN ('Interested', 'Replied')

SELECT * FROM Stages WHERE OrderValue > 3 AND OrderValue < 7

SELECT * FROM Stages WHERE OrderValue IN (3, 5, 7)

Columns


Name	Type	Description
Id [KEY]	Integer	Id of Stage.
Color	String	The color the stage label will be highlighted in the interface, specified as a hexidecimal value.
CreatedAt	Datetime	The date and time the stage was created.
Name	String	The name of the stage.
OrderValue	Integer	The stages display order value within the collection.
UpdatedAt	Datetime	The date and time the stage was last updated.
LinksSelf	String	Link self.
CreatorId	Integer	Creator Id.
UpdaterId	Integer	Updater Id.
ProspectsLinks	String	The prospects associated to the stage.
UpdaterData	String	The most recent updater of the stage.
Type	String	Type.

Excel Add-In for Outreach

Stages

Select

Columns