Connect ONLYOFFICE DocSpace and SQL Server

Both apps 38ONLYOFFICE DocSpace 27SQL Server 11

• Trigger
  File Created

  Triggers when a new file is created in the selected DocSpace folder or room.

• Trigger
  File Created in My Documents

  Triggers when a new file is created in your My documents section.

• Trigger
  Folder Created

  Triggers when a new folder is created inside the selected folder or room.

• Trigger
  Folder Created in My Documents

  Triggers when a new folder is created in your My Documents section.

• Trigger
  Room Archived

  Triggers when a room is moved to the Archive section of your DocSpace.

• Trigger
  Room Created

  Triggers when a new room is created in the DocSpace portal.

• Trigger
  User Added

  Triggers when a new user is added to the DocSpace portal.

• Trigger
  User Joined

  Triggers when a user joins the DocSpace portal by activating their account.

• Action
  Archive Room

  Moves a DocSpace room to the Archive section.

• Action
  Create File

  Creates a new document, spreadsheet or presentation file in a DocSpace folder or room.

• Action
  Create File in My Documents

  Creates a new blank document, spreadsheet or presentation in your My documents section.

• Action
  Create Folder

  Creates a new folder with the given title inside a folder or room.

• Action
  Create Folder in My Documents

  Creates a new folder in your My Documents section.

• Action
  Create Room

  Creates a new room in the DocSpace Rooms section and returns the room's information.

• Action
  Delete Folder

  Deletes a folder in DocSpace. The deletion runs as a background file operation, which is returned.

• Action
  Delete Folder From My Documents

  Deletes a folder from My Documents in ONLYOFFICE DocSpace.

• Action
  Download File

  Returns a temporary pre-signed download link for a DocSpace file.

• Action
  Download File From My Documents

  Returns a temporary download link for a file in My Documents.

• Action
  Find User by Email

  Finds a DocSpace user by email address and returns their profile.

• Action
  Get External Link

  Returns the primary external (public share) link of a DocSpace room.

• Action
  Get Room Access List

  Returns the list of users, groups and links that have access to a room, with their access rights.

• Action
  Invite User

  Invites a person to the DocSpace portal by email with the chosen user role.

• Action
  Search File

  Searches a DocSpace folder or room for files whose title matches the given text.

• Action
  Search Folder

  Searches a DocSpace folder or room for subfolders whose name matches the given text and returns the matches.

• Action
  Share Room

  Shares a room with a person by email or user id, giving them the chosen access level, and optionally sends them a notification.

• Action
  Upload File

  Uploads a file from a URL into a chosen DocSpace folder or room.

• Action
  Upload File to My Documents

  Uploads a file to your My documents section in ONLYOFFICE DocSpace.

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