Connect Amazon Redshift to Zenoti

Both apps 22Amazon Redshift 7Zenoti 15

• Trigger
  New Row

  Triggers when a new row is added to an Amazon Redshift table.

• Trigger
  Updated Row

  Triggers when a row in an Amazon Redshift table is added or changed, based on its updated-time column.

• Action
  Create Rows

  Adds a row to an Amazon Redshift table.

• Action
  Delete Rows

  Deletes the rows in an Amazon Redshift table that match a condition.

• Action
  Find Rows

  Finds rows in an Amazon Redshift table that match a condition.

• Action
  Query Database

  Runs one SQL statement on your Amazon Redshift database and returns any rows it produces.

• Action
  Update Rows

  Updates the rows in an Amazon Redshift table that match a condition.

• Action
  Add booking

  Creates a service booking request for one or more guests at a center on a date, returning a booking id used to pick, reserve and confirm a slot.

• Action
  Add Employee Security Role

  Assigns a security role to a Zenoti employee for a center, zone, or the organization.

• Action
  Add Notes to an Opportunity

  Adds a note to an existing opportunity in Zenoti.

• Action
  Create Employee

  Creates an employee profile in a Zenoti center, including personal details, job, security role and online catalog information.

• Action
  Create Employee Blockout

  Creates a blockout time (such as a lunch break) on an employee's schedule at a center.

• Action
  Create Guest

  Creates a guest (client profile) in a Zenoti center and returns the new guest record with its id.

• Action
  Delete Employee Blockout

  Permanently deletes a blockout time from an employee's schedule.

• Action
  List appointments of a guest

  Returns the appointment history of a guest, optionally filtered by date range or to upcoming/past appointments.

• Action
  List centers

  Returns all centers (business locations) of your Zenoti organization, with their address, time zone and currency details.

• Action
  List employees

  Returns the employees who are active in a Zenoti center on a given date.

• Action
  List services

  Returns the services offered at a Zenoti center, with pricing (including campaign-discounted pricing when a campaign is given).

• Action
  Merge guests

  Merges one or more duplicate guest records into a target guest in Zenoti.

• Action
  Search for a Guest

  Searches for guests by name, email, phone, zip code, tags, username or user code, in one center or across the organization.

• Action
  Search Guest by ID

  Returns the full profile of a Zenoti guest by their guest ID, including personal info, address, preferences, tags and referral details.

• Action
  Update Employee Blockout

  Updates an existing blockout time (such as a lunch break) on an employee's schedule, including its time, type, notes and recurrence.

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