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 INTO Projects (Name, Pipeline, PipelineStage) VALUES ('New Website Launch', 'pipeline_id', 'stage_id');

UPDATE

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

DELETE

DELETE FROM Projects WHERE Id = 123456789;

Columns