Returns all Projects from HubSpot, used to plan, track, and collaborate on work across your team.

View-Specific Information

In HubSpot, Projects are used to plan, track, and collaborate on work across teams.

SELECT

When selecting Projects, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators are: =, !=, <, <=, >, >=, IN

Further filtering is available using AND and OR combinations. A maximum of 3 OR operators are supported server-side, with each of these operators supporting up to 3 AND operators inside of them. For example:

SELECT * FROM Projects;
SELECT * FROM Projects WHERE Id = '123456789';

In the below server-offloading examples, "{Column}" represents any column you'd like to filter and "{Value}" represents any value you want to filter it on:

SELECT * FROM Projects WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM Projects WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}
SELECT * FROM Projects WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})

INSERT

INSERT statements use the format:

INSERT INTO Projects (Name, Pipeline, PipelineStage) VALUES ('New Website Launch', 'pipeline_id', 'stage_id');

UPDATE

UPDATE statements use the format:

UPDATE Projects SET Status = 'IN_PROGRESS', Description = 'Q3 initiative' WHERE Id = 123456789;

DELETE

DELETE statements use the format:

DELETE FROM Projects WHERE Id = 123456789;

Columns

Name	Type	ReadOnly	References	Filterable	Description
Id [KEY]	Long	True		True	The unique identifier of the project.
Archived	Bool	True		False	Indicates whether the project is archived.
CreatedAt	Datetime	True		False	The date and time when the project was created.
UpdatedAt	Datetime	True		False	The date and time when the project was last updated.
Name	String	False		True	The name of the project.
Description	String	False		False	A description of the project.
Status	String	False		True	The current status of the project.
Type	String	False		True	The type of the project. Supported values: sales, marketing, service, internal_ops.
Pipeline	String	False		False	The Id of the pipeline that the project belongs to.
PipelineStage	String	False		False	The Id of the pipeline stage that the project is currently in.
TargetDueDate	Datetime	False		False	The target due date for completing the project.
OwnerId	String	False		True	The Id of the HubSpot user assigned as the owner of the project.
RecordId	Decimal	True		False	The unique record Id of the project, set automatically by HubSpot.