Connect Timesheet to SQL Server

Both apps 71Timesheet 60SQL Server 11

• Trigger
  New Absence

  Triggered when a new absence is requested or recorded in the chosen Timesheet organization.

• Trigger
  New Project

  Triggered when a new project is created in Timesheet.

• Trigger
  New Rate

  Triggered when a new pay rate is created in Timesheet.

• Trigger
  New Tag

  Triggered when a new tag is created in Timesheet.

• Trigger
  New Task

  Triggered when a new tracked time entry is recorded in Timesheet.

• Trigger
  New Team

  Triggered when a new team is created in Timesheet.

• Trigger
  New Todo

  Triggered when a new to-do is created in Timesheet.

• Action
  Approve Absence

  Approves a pending absence request in a Timesheet organization. Returns the updated absence, including its new status and who approved it.

• Action
  Create Expense

  Creates an expense on a Timesheet task, with an amount, date and optional receipt. Returns the new expense with its ID.

• Action
  Create Note

  Creates a note on a Timesheet task, with text and an optional attachment. Returns the new note with its ID.

• Action
  Create Organization

  Creates a new organization (team workspace) in Timesheet. Returns the new organization with its ID.

• Action
  Create Project

  Creates a new project in Timesheet, optionally with a client, default billing rate and team. Returns the new project with its ID.

• Action
  Create Rate

  Creates a pay rate in Timesheet, such as an overtime multiplier or a bonus amount. Returns the new rate with its ID.

• Action
  Create Reminder

  Creates a reminder in Timesheet on a one-off or recurring schedule. Returns the new reminder with its ID and next fire time.

• Action
  Create Tag

  Creates a tag in Timesheet that can be applied to time entries. Returns the new tag with its ID.

• Action
  Create Task

  Creates a time entry (task) on a Timesheet project, with start and end times and optional tags, rate and mileage. Returns the new entry with its ID and duration.

• Action
  Create Team

  Creates a team inside a Timesheet organization. Returns the new team with its ID.

• Action
  Create Todo

  Creates a to-do on a Timesheet project, with an optional due date, assignees and time estimate. Returns the new to-do with its ID.

• Action
  Delete Expense

  Deletes an expense from Timesheet. Returns confirmation that the expense was removed.

• Action
  Delete Note

  Deletes a note from Timesheet. Returns confirmation that the note was removed.

• Action
  Delete Organization

  Deletes an organization from Timesheet. Returns confirmation that the organization was removed.

• Action
  Delete Project

  Deletes a project from Timesheet. Returns confirmation that the project was removed.

• Action
  Delete Rate

  Deletes a pay rate from Timesheet. Returns confirmation that the rate was removed.

• Action
  Delete Reminder

  Deletes a reminder from Timesheet. Returns confirmation that the reminder was removed.

• Action
  Delete Tag

  Deletes a tag from Timesheet. Returns confirmation that the tag was removed.

• Action
  Delete Task

  Deletes a time entry from Timesheet. Returns confirmation that the entry was removed.

• Action
  Delete Team

  Deletes a team from Timesheet. Returns confirmation that the team was removed.

• Action
  Delete Todo

  Deletes a to-do from Timesheet. Returns confirmation that the to-do was removed.

• Action
  Find Absence

  Searches absences in a Timesheet organization by member, contract, type, status or date range, and returns the first match plus the full list of matches.

• Action
  Find Expense

  Searches Timesheet expenses by text, time entry, organization or date range, and returns the first match plus the full list of matches.

• Action
  Find Note

  Searches Timesheet notes by text, time entry, organization or date range, and returns the first match plus the full list of matches.

• Action
  Find Organization

  Looks up a Timesheet organization by name and returns its ID and details. Timesheet has no organization search endpoint, so this reads your organizations and matches the name, ignoring upper/lower case.

• Action
  Find Project

  Searches Timesheet projects by name, team or status, and returns the first match plus the full list of matches.

• Action
  Find Rate

  Searches Timesheet pay rates by name, team, project or status, and returns the first match plus the full list of matches.

• Action
  Find Reminder

  Looks up a Timesheet reminder by name and returns its ID and schedule. Timesheet has no reminder search endpoint, so this reads your reminders and matches the name, ignoring upper/lower case.

• Action
  Find Tag

  Searches Timesheet tags by name, team, project or status, and returns the first match plus the full list of matches.

• Action
  Find Task

  Searches Timesheet time entries by text, project, to-do, team or date range, and returns the first match plus the full list of matches.

• Action
  Find Team

  Searches Timesheet teams by name or organization, and returns the first match plus the full list of matches.

• Action
  Find Todo

  Searches Timesheet to-dos by title, project, status or assignee, and returns the first match plus the full list of matches.

• Action
  Get Current Timer

  Returns the state of your current Timesheet timer — whether it is running, paused or stopped, and the time entry it is tracking.

• Action
  Get Project

  Returns one Timesheet project by ID, including its client, settings and tracked totals.

• Action
  Get Rate

  Returns one Timesheet pay rate by ID, including its multiplier and extra amount.

• Action
  Get Tag

  Returns a single tag by its ID, including its name, colour, archived state, owning team and total tracked time.

• Action
  Get Task

  Returns a single tracked time entry by its ID, including its description, start and end times, duration, billing flags, project, rate, member and tags.

• Action
  Get Team

  Returns a single team by its ID, including its name, description, colour, owning organization, and project and member counts.

• Action
  Pause Timer

  Pauses the running timer, starting a break. Returns the timer with its new paused state.

• Action
  Resume Timer

  Resumes a paused timer, ending the current break. Returns the timer with its new running state.

• Action
  Send Report

  Generates a timesheet report for the chosen period and emails it to the given address.

• Action
  Start Timer

  Starts the timer on a project, creating a running time entry. Returns the timer and the entry it is tracking.

• Action
  Stop Timer

  Stops the running timer and closes out the time entry it was tracking.

• Action
  Update Expense

  Updates an existing expense's description, date, amount, refund status or attached receipt. Fields left blank keep their current values.

• Action
  Update Note

  Updates an existing note's text, date or attachment. Fields left blank keep their current values.

• Action
  Update Organization

  Updates an organization's name, description, image, colour or AI chat setting. Fields left blank keep their current values.

• Action
  Update Project

  Updates an existing project's name, client, office, colour, billing defaults, salary or archived state. Fields left blank keep their current values.

• Action
  Update Rate

  Updates an existing pay rate's name, multiplier, extra amount, enabled or archived state. Fields left blank keep their current values.

• Action
  Update Reminder

  Updates an existing reminder's title, prompt, message template or schedule. Fields left blank keep their current values.

• Action
  Update Tag

  Updates an existing tag's name, colour or archived state. Fields left blank keep their current values.

• Action
  Update Task

  Updates an existing tracked time entry's project, description, times, billing flags, rate or tags. Fields left blank keep their current values.

• Action
  Update Team

  Updates an existing team's name, description, image, colour or salary visibility. Fields left blank keep their current values.

• Action
  Update Todo

  Updates an existing to-do's title, details, status, due date, assignees or time estimate. Fields left blank keep their current values.

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

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