Connect PostgreSQL and TimeKeeper

Both apps 27PostgreSQL 10TimeKeeper 17

• 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.

• Trigger
  Employee Clock In

  Triggers when an employee clocks in, returning the new time entry with its employee, job, activity and start time.

• Trigger
  Employee Clock Out

  Triggers when an employee clocks out, delivering the completed time entry with its start and end times, duration, job and activity.

• Trigger
  Leave Request Approved

  Triggers when a leave request is approved in TimeKeeper, for leave falling between 30 days ago and 59 days ahead.

• Trigger
  Who's In

  Triggers when an employee appears on the Who's In list, i.e. each time someone clocks in, with their location, last job and clock-in time.

• Action
  Add activity

  Creates a new activity in TimeKeeper that employees can log time against.

• Action
  Add a Job

  Creates a new job in TimeKeeper with a name and optional job number and address.

• Action
  Get employee timesheet

  Returns an employee's timesheet for a date range, including total regular, overtime and leave hours plus each day's time entries and leave.

• Action
  Get job breakdown report

  Generates a breakdown report for one TimeKeeper job over a date range of up to 60 days.

• Action
  List activities

  Returns every activity set up in your TimeKeeper account, with each activity's name and number.

• Action
  List employees

  Returns the employees in your TimeKeeper account, including archived ones, with their contact details, job title, teams and working locations.

• Action
  List jobs

  Returns every job in your TimeKeeper account, with each job's name, job number, completion status and id.

• Action
  List leave entries

  Returns employee leave entries (annual leave and other leave types) within a date range of up to 30 days, optionally for one employee or one leave type. Public holidays are not included.

• Action
  List leave requests

  Returns the leave requests in your TimeKeeper account for a date range of up to 90 days, optionally filtered by status, leave type or employee. Returns open requests unless another status is chosen.

• Action
  List shifts

  Returns the draft, open and published shifts scheduled in a date range of up to 90 days, optionally for one employee. Shift times are in UTC.

• Action
  List time entries

  Returns the time entries recorded in your TimeKeeper account for a date range of up to 90 days, optionally narrowed to one employee, job or activity.

• Action
  Update activity

  Updates the name and activity number of an existing activity in TimeKeeper.

• Action
  Update a Job

  Updates an existing job in TimeKeeper, changing its name, job number, address or address coordinates.

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