Connect Parseur and SQL Server

Both apps 27Parseur 16SQL Server 11

• Trigger
  New Document Export Failed

  Triggered when Parseur fails to export a document to its destination.

• Trigger
  New Document Not Processed

  Triggered when Parseur receives a document it cannot extract data from, so you can follow it up.

• Trigger
  New Document Processed

  Triggered when Parseur finishes extracting data from a document, with the extracted fields.

• Trigger
  New Document Processed (With List Items)

  Triggered when Parseur finishes extracting data from a document, including any table or list fields it found (line items, rows).

• Trigger
  New Mailbox

  Triggers when a new mailbox is created in your Parseur account. Returns the mailbox's name, email prefix, AI engine and document counts.

• Trigger
  New Table Field Processed

  Triggers once for every row of a table or list field when Parseur finishes processing a document. Returns the row's values along with the document and mailbox it came from.

• Action
  Create Document

  Sends text or HTML content to a Parseur mailbox as a new document, so Parseur can extract its data. Returns the new document's ID.

• Action
  Create Document From File

  Uploads a file (PDF, DOCX, image and so on) to a Parseur mailbox as a new document, so Parseur can extract its data. Returns the new document's ID.

• Action
  Delete Document

  Deletes a document from Parseur by its ID.

• Action
  Delete Mailbox

  Deletes a Parseur mailbox and everything in it. This cannot be undone.

• Action
  Get Document

  Returns one document from Parseur by its ID, including its processing status and the data Parseur extracted from it.

• Action
  Get Mailbox

  Returns one Parseur mailbox by its ID, with its email address, document counts and settings.

• Action
  List Documents

  Returns the documents in Parseur, optionally narrowed to one mailbox or one processing status.

• Action
  List Mailboxes

  Returns the mailboxes in your Parseur account, with the email address to send documents to and how many documents each holds.

• Action
  Reprocess Document

  Sends an existing document back through parsing, for example after you update its template. Returns the document's ID, name and processing status.

• Action
  Update Mailbox

  Updates a Parseur mailbox's settings. Only the values you supply are changed — anything you leave blank keeps its current setting.

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