Stages

The point in the process used for categorizing prospects.

Select

The 本製品 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 本製品.

Id supports the '=,IN,>=,<=,>,<' 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

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.

SSIS Components for Outreach

Stages

Select

Columns