Connect Nifty and SQL Server

Both apps 39Nifty 28SQL Server 11

• Trigger
  New Doc

  Triggers when a new doc is created.

• Trigger
  New File

  Triggers when a new file is uploaded.

• Trigger
  New Message

  Triggers when a new message is sent.

• Trigger
  New Milestone

  Triggers when a new milestone is created.

• Trigger
  New Portfolio

  Triggers when a new portfolio is created.

• Trigger
  New Project

  Triggers when a new project is created.

• Trigger
  New Status

  Triggers when a new status is created.

• Trigger
  New Subtask

  Triggers when a new subtask is created.

• Trigger
  New Tag

  Triggers when a new tag is created.

• Trigger
  New Task

  Triggers when a new task is created.

• Trigger
  Task Is Completed

  Triggers when a task is completed.

• Action
  Create Document

  Creates a Nifty document in a project, optionally seeding its body from Markdown.

• Action
  Create File

  creates a file record in a project from text content (or a URL), firing file.created.

• Action
  Create Milestone

  Creates a milestone (a date-spanning list shown on the project roadmap) in a Nifty project.

• Action
  Create Portfolio

  Creates a portfolio (a team-level grouping of projects) in Nifty.

• Action
  Create Project

  Creates a new project.

• Action
  Create Status

  Creates a status column (Kanban column / list stage) in a Nifty project.

• Action
  Create Subtask

  Creates a new subtask.

• Action
  Create Tag

  Creates a tag (called a label in the Nifty API) that can be applied across the workspace to tasks, documents, files and more.

• Action
  Create Task

  Creates a new task.

• Action
  Create Upload URL

  Returns a presigned upload URL and storage key for a new file. Upload the bytes to the URL, then pass the key to Create File.

• Action
  Get Document

  Retrieve a single Nifty document's details (name, project, access type, author, timestamps). The document body is not included.

• Action
  Get Message

  Retrieve a single Nifty message (chat message or comment) by its ID.

• Action
  Get Milestone

  Retrieve a single milestone by its id, including its custom-field values.

• Action
  Get Project

  Retrieve a single Nifty project by its id, including its custom-field values and any related records you ask to expand.

• Action
  Get Status

  Retrieve a single Nifty status column by its id.

• Action
  Get Tag

  Retrieves a single tag (Nifty label) by id.

• Action
  Send Message

  Posts a message in Nifty: into a chat, as a comment on a task, document, file or annotation, as a reply to another message, or as a direct message to a team member.

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