Connect MeisterTask and SQL Server

Both apps 29MeisterTask 18SQL Server 11

• Trigger
  New Attachment

  Triggers when a new file is attached to any task in the project you pick. Returns the attachment's name, type and download link along with the task it belongs to.

• Trigger
  New Checklist Item

  Triggers when a new checklist item is added to any task in the project you pick. Returns the item's text and status along with the checklist and task it belongs to.

• Trigger
  New Comment

  Triggers when a new comment is posted on any task in the project you pick. Returns the comment text and author along with the task it was posted on.

• Trigger
  New Label

  Triggers when a new label is created in the project you pick. Returns the label's name and color.

• Trigger
  New Person

  Triggers when a new person joins your MeisterTask account. Returns their name, email address and when they were added.

• Trigger
  New Project

  Triggers when a new project is created in your MeisterTask account. Returns the project's name, notes and status.

• Trigger
  New Section

  Triggers when a new section (column) is added to the project you pick. Returns the section's name, color and work-in-progress limit.

• Trigger
  New Task

  Triggers when a new task is created in the project you pick. Returns the task's title, notes, section and assignee.

• Trigger
  New Task Label

  Triggers when a label is added to any task in the project you pick. Returns the label's name and color along with the task it was added to.

• Action
  Create Attachment

  Uploads a file and attaches it to a MeisterTask task. Returns the new attachment's ID, name and download link.

• Action
  Create Label

  Creates a new label in a MeisterTask project. Returns the label's ID, name and color.

• Action
  Create Task

  Creates a new task in a MeisterTask section. Returns the task's ID, title, section and project.

• Action
  Create Task Label

  Adds an existing project label to a MeisterTask task. Returns the link between the task and the label.

• Action
  Find Attachment

  Finds an attachment on a MeisterTask task by name. Returns whether a match was found along with the attachment's ID, name and download link.

• Action
  Find Label

  Finds a label in a MeisterTask project by name. Returns whether a match was found along with the label's ID and color.

• Action
  Find Person

  Finds a person in your MeisterTask account by email address or full name. Returns whether a match was found along with the person's ID, name and email.

• Action
  Find Task

  Finds a task in a MeisterTask project by title, optionally limited to one section. Returns whether a match was found along with the task's ID, section and assignee.

• Action
  Update Task

  Updates a MeisterTask task. Only the values you supply are changed — anything you leave blank keeps its current value.

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