Connect SQL Server to Teambook

Both apps 45SQL Server 11Teambook 34

• 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 SQL Server database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected SQL Server database.

• Action
  Add Row

  Add one row to a table on the connected SQL Server database.

• Action
  Delete Row

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

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

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

• Action
  Find Row via Custom Query

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

• Action
  Run Custom Statement

  Runs a statement you write against the connected SQL Server database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

• Action
  Add Actual log

  Creates one or more time-tracking actual logs in a batch.

• Action
  Add Booking

  Creates one or more bookings in a batch.

• Action
  Add Client

  Creates a client record.

• Action
  Add Task

  Creates a task, optionally scoped to a project (omit project_id for account-wide task).

• Action
  Create Project

  Create a Project inside Teambook

• Action
  Create User

  Creates a teambook User

• Action
  Deactivate User

  Deactivates a Teambook user so they can no longer be booked or sign in, without deleting their history.

• Action
  Delete Actual log

  Deletes an actual log by id.

• Action
  Delete Booking

  Removes a single booking from Teambook.

• Action
  Delete Project

  Deletes a project by id.

• Action
  Delete Task

  Deletes a task from the Teambook account.

• Action
  Delete User

  Deletes a user from the Teambook account.

• Action
  Get Actual log

  Retrieve a single Teambook actual log (time entry) by its id.

• Action
  Get Booking

  Retrieve a single Teambook booking (a user's assignment to a project on a date for a duration) by its id.

• Action
  Get Client

  Retrieves a single client by id.

• Action
  Get Project

  Retrieves a single project by id.

• Action
  Get Task

  Retrieves a single task by id.

• Action
  Get Team

  Retrieve a single Teambook team by its id.

• Action
  Get User

  Retrieve a single Teambook user by id.

• Action
  List Actual logs

  Lists actual logs (timesheet entries), filterable by user_id, project_id, since, range.

• Action
  List Bookings

  Lists bookings, optionally filtered by team, user, project and date window. Returns the first page of up to 100 bookings.

• Action
  List Clients

  Returns every client in the Teambook account.

• Action
  List Project capacities

  Lists project capacity entries (days reserved per project per month) entered on the Capacity by Project page.

• Action
  List Projects

  Lists all projects in the Teambook account.

• Action
  List Tasks

  Lists all tasks.

• Action
  List Teams

  Lists all teams in the Teambook account.

• Action
  List User capacities

  Lists monthly capacity-reservation rows per user, filterable by user_id and since (first day of month).

• Action
  List Users

  Lists all users in the Teambook account.

• Action
  Update Actual log

  Edits an actual log's project, user, date, duration, task, payroll_item, approved, or comment.

• Action
  Update Booking

  Updates an existing Teambook booking; only the fields you fill in are changed.

• Action
  Update Client

  Edits a client's name, phone_number, or email.

• Action
  Update Project

  Edits a project's fields (name, code, active, color, kind, estimated, notes, client_id, manager_id, dates, custom_fields).

• Action
  Update Task

  Edits a task's name or project_id.

• Action
  Update User

  Edits a user's first_name, last_name, email, role, billable, time_zone, phone_number, language, or schedule.

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