Connect Hjarni and SQL Server

Both apps 26Hjarni 15SQL Server 11

• Trigger
  New Note

  Triggers when a new note is created.

• Action
  Add File to Note

  Attaches a file to an existing note from a URL.

• Action
  Add tag

  Create a tag.

• Action
  Create Folder

  Creates a new folder with a name, parent folder, description, and AI instructions.

• Action
  Create Note

  Creates a new note with a title, body, tags, and folder.

• Action
  Delete folder

  Delete a container.

• Action
  Delete note

  Delete a note (moves to trash).

• Action
  Delete tag

  Delete a tag.

• Action
  Get folder

  Fetch one container by id.

• Action
  Get note

  Fetch one note by id with body, tags, container, files.

• Action
  List notes

  List notes, filter by scope/container_id/tag, paginated.

• Action
  List tags

  List tags.

• Action
  Update folder

  Update a container.

• Action
  Update note

  Update note fields (title, body, tags, container, append_body etc, expected_lock_version).

• Action
  Update tag

  Rename/update a tag.

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