In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.
Create custom HUB Planner and Postgres workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.
Get all projects
This call will return all projects.
Search projects
Search for projects based on their status.
Get specific project
Retrieve a specific project by its ID.
Create project
Create a new project with the provided details.
Fetch custom field templates
Fetch templates defined for your account.
Search custom fields
Search for custom fields based on their type.
Bulk update projects
Updates multiple projects in a single request.
Delete project
Deletes a specific project by id.
Add resource to project
Adds a resource to a specific project identified by projectId.
Remove resource from project
Removes a resource from a specific project identified by resourceId.
Add clients to project
Adds clients to a specific project identified by projectId.
Remove client from projects
Removes a client from specific projects identified by clientId.
Set project managers
Sets project managers for a specific project identified by projectId.
Get all project tags
Retrieves all tags for a specific project identified by its ID.
Remove project tag from project
Removes a specific tag from a project identified by its ID.
Get all bookings
Retrieve a paginated list of all bookings.
Retrieve deleted bookings
Retrieve deleted bookings using the query parameter deleted.
Retrieve booking dependencies
Retrieve booking dependencies using the query parameter dependencies.
Search bookings
Search allows to get more complex results based on given criteria.
Get specific booking
Get a specific booking by its ID.
Create a new booking
Create a new booking with minimum required fields.
Update booking
Update an existing booking.
Delete booking
Delete a specific booking by id.
Delete multiple bookings
Delete multiple bookings by booking IDs, resourceId or projectId.
Delete multiple bookings by resourceId
Delete all bookings for the resource with ID.
Delete multiple bookings by projectId
Delete all bookings for the project with ID.
List events
Call will return all projects.
Search events
Search events by name.
Get specific event
Use the following command to get a specific event by ID.
Update event
Update an existing event by ID with the complete event object.
Get all holidays
Retrieves a list of all holidays.
Search holidays
Searches for holidays within a specified date range.
Get specific holiday
Retrieves details of a specific holiday by ID.
Update a holiday
Updates an existing holiday by ID.
Get milestone
Retrieve a specific milestone by its ID.
Search milestones
Search for milestones based on specific parameters.
Create milestone
Create a new milestone with the required fields.
Update milestone
Update an existing milestone by its ID.
To set up HUB Planner integration, add the HTTP Request node to your workflow canvas and authenticate it using a generic authentication method. The HTTP Request node makes custom API calls to HUB Planner to query the data you need using the API endpoint URLs you provide.
These API endpoints were generated using n8n
n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the HUB Planner official documentation to get a full list of all API endpoints and verify the scraped ones!
CSV is a universally accepted and easy-to-read format to interpret data, and PostgreSQL is one of the most popular relational databases. Read on to learn how to export PostgreSQL as a CSV file using the COPY command, \copy command, and n8n.
PostgreSQL remains one of the most popular relational database options among data enthusiasts. Read on to learn how to import a CSV file into PostgreSQL using pgAdmin, SQL statements, and n8n.
Learn what database activity monitoring is, why it's important, and how to automatically monitor a Postgres database containing IoT data with n8n workflows.
Learn how to build an n8n workflow that processes text, stores data in two databases, and sends messages to Slack.
Discover our latest community's recommendations and join the discussions about HUB Planner and Postgres integration.
Mikhail Savenkov
Describe the problem/error/question Postgres node is not working with IN Operator when the parameters is an Array. I suppose that’s because of the sanity checks. E.g. I have a list of some workflows that I’m returning v…
Open topic
Honza Pav
Hello, I have a follow-up question related to a topic that has been discussed but is closed: Postgres use array as a query parameters I want to pass an array into a Postgresql query as a query parameter. Ideally, I woul…
Open topic
Vyacheslav Karbovnichy
Describe the problem/error/question I have set up local n8n (latest stable v1.59.3) and wanted to try the solution from here https://www.youtube.com/watch?v=PEI_ePNNfJQ but when importing that workflow locally I have so…
Open topic
Dennis
Hey everyone, I have the following problem & one question. Problem I have an HTTP request and a split. The split node correctly splits the HTTP into 10 items. But the Postgres only returns 1 item. No matter what, which…
Open topic
Dennis
Hey everyone, I love N8N so far; as a newbie when it comes to databases and development, I am happy for this awesome solution. Situation I am, at best, an intermediate coder. Right now we are building an MVP, before h…
Open topic
The world's most popular workflow automation platform for technical teams including
Build complex workflows, really fast