Connect ProjectManager and SQL Server

Both apps 37ProjectManager 26SQL Server 11

• Trigger
  New Project

  Fires when a new project is created in the ProjectManager workspace.

• Trigger
  New Task

  Triggers when a new task is created, can be configured to find all new tasks or only tasks added to a specific project

• Trigger
  New User

  Fires when a new user (resource) is added to the ProjectManager workspace.

• Action
  Create Project

  Create a new project in your workspace

• Action
  Create Task

  Creates a new task within a specified project

• Action
  Create Timesheet Entry

  Create a single timesheet entry. A timesheet entry is the number of hours spent by a person on a task on a specific day. There can only be one entry per person/task/day, trying to add a second entry will give a conflict error, however you can use the timesheet-update action to increase the number of hours logged for an existing timesheet entry.

• Action
  Create User

  Add a new user/resource in your account

• Action
  Get Account Information

  Returns information about the current user including home URL, email, user ID and workspace name

• Action
  Get Project Details

  Get the details of one specific project

• Action
  Get Project Priorities

  Gets a list of all the priorities which can be applied to a project

• Action
  Get Project Statuses

  Get all the statuses which can be applied to a project

• Action
  Get Task Details

  Get the details of one specific task, you will need to know the task's unique ID

• Action
  Get Task Fields

  Get all the custom fields which can be applied to the tasks in a specific project, each project has different custom fields so you will need to provide a ProjectID with this action

• Action
  Get Task Field Values

  Get the value of each custom field applied to a specific task

• Action
  Get Task Priorities

  Get all the priorities which can be applied to a task

• Action
  Get Task Statuses (Columns)

  Get the statuses (board columns) which can be applied to tasks in a specific project, note that each project has unique task statuses

• Action
  Get User Details

  Get the details of one specific user/resource

• Action
  Get User Roles

  Retrieves the list of user roles (privilege levels) defined in the ProjectManager workspace.

• Action
  Search Projects

  Search through your active projects using various criteria, 100 results max

• Action
  Search Tasks

  Search for tasks across your entire account, using various criteria, 100 results max

• Action
  Search Users

  Search for workspace users/resources using various criteria, 100 results max

• Action
  Update Project

  Update an existing project, empty fields will remain unchanged

• Action
  Update Task

  Update an existing task, empty fields will remain unchanged

• Action
  Update Task Field Value

  Update the value of a custom field for a specific task

• Action
  Update Timesheet Entry

  Update an existing timesheet entry, useful for incrementing the total hours logged or adding notes about the entry

• Action
  Update User

  Update an existing user/resource, empty fields will remain unchanged

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