Connect PostgreSQL and OnceHub to Build Intelligent Automations

Choose a Trigger

PostgreSQL

When this happens...

Choose an Action

OnceHub

Automatically do this!

Actions and Triggers

When this happensTriggers

A trigger is an event that starts a workflow.

Postgresql (mutiple table)

Postgresql (mutiple table)

Get all the data, which was updated in last 15 min, from all the table provided.

Booking Scheduled

Booking Scheduled

Triggers when a new booking is scheduled.

Booking Rescheduled

Booking Rescheduled

Triggers when a booking is rescheduled.

Booking No-Show

Booking No-Show

Triggers when the status of a booking is manually changed to “No-show”.

Booking Canceled

Booking Canceled

Triggers when an existing booking is cancelled.

Booking Lifecycle Event

Booking Lifecycle Event

Triggers when the status of a booking is changed to “Scheduled”, “Rescheduled”, “Canceled”, “Completed”, or “No-show”.

Do thisActions

Action is the task that follows automatically within your PostgreSQL integrations.

Execute a Query (advanced)

Execute a Query (advanced)

You can select, create, update or delete row(s) of table via custom SQL query.

Insert row

Insert row

Adds a new row into the table.

Find Contact

Find Contact

Find Contact in your oncehub account.

List Bookings

List Bookings

Get a list all bookings in the account.

List Booking Calendars

List Booking Calendars

Get a list of all booking calendars in your account.

List Booking Pages

List Booking Pages

Get a list of all booking pages in your account.

Need help building your workflow?

Get instant answers from our AI assistant or connect with a support specialist anytime.

Frequently Asked Questions

How do I start an integration between PostgreSQL and OnceHub?

To start, connect both your PostgreSQL and OnceHub accounts to viaSocket. Once connected, you can set up a workflow where an event in PostgreSQL triggers actions in OnceHub (or vice versa).

Can we customize how data from PostgreSQL is recorded in OnceHub?

Absolutely. You can customize how PostgreSQL data is recorded in OnceHub. This includes choosing which data fields go into which fields of OnceHub, setting up custom formats, and filtering out unwanted information.

How often does the data sync between PostgreSQL and OnceHub?

The data sync between PostgreSQL and OnceHub typically happens in real-time through instant triggers. And a maximum of 15 minutes in case of a scheduled trigger.

Can I filter or transform data before sending it from PostgreSQL to OnceHub?

Yes, viaSocket allows you to add custom logic or use built-in filters to modify data according to your needs.

Is it possible to add conditions to the integration between PostgreSQL and OnceHub?

Yes, you can set conditional logic to control the flow of data between PostgreSQL and OnceHub. For instance, you can specify that data should only be sent if certain conditions are met, or you can create if/else statements to manage different outcomes.