Connect PostgreSQL to Vcita

Both apps 18PostgreSQL 10Vcita 8

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected PostgreSQL database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected PostgreSQL database.

• Action
  Add Row

  Adds a new row.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Finds a row in a table via a lookup column.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected PostgreSQL database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected PostgreSQL database and returns the first row it matches.

• Action
  Update Row

  Updates an existing row.

• Action
  Add booking

  Creates a booking in vcita: an appointment with a staff member for a service, or a registration to a group event.

• Action
  Add Client Message

  Adds a message to a client's conversation in vcita, sent from the business to the client or recorded as from the client.

• Action
  Create Client

  Creates a new client in your vcita business.

• Action
  Create Invoice

  Creates an invoice for a client matter, with line items, dates and currency, and optionally sends it to the client.

• Action
  Find Client

  Finds clients in your Vcita business by email, phone or id, and returns the matching clients.

• Action
  List appointments

  Returns the business's appointments, optionally filtered by client and state.

• Action
  List services

  Returns the bookable services of a business, both one-on-one appointment services and group event services.

• Action
  Update Client

  Updates an existing client's contact details, status, tags and other fields. Fields left blank are not changed.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.