Connect SQL Server to Modern Treasury

Both apps 25SQL Server 11Modern Treasury 14

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

• Action
  Add counterparty

  Creates a counterparty — a person or business you send payments to or receive payments from — optionally with its bank accounts and legal entity.

• Action
  Add expected payment

  Creates an expected payment in Modern Treasury so an incoming or outgoing payment can be reconciled automatically when it arrives.

• Action
  Add external account

  Creates an external bank account for a counterparty in Modern Treasury, with its account numbers, routing details and owner information.

• Action
  Add invoice

  Creates an invoice for a counterparty, payable to one of your internal accounts.

• Action
  Add ledger transaction

  Creates a ledger transaction made of balanced debit and credit entries against your ledger accounts.

• Action
  Add payment order

  Creates a payment order that moves money between one of your internal accounts and a counterparty's or another internal account.

• Action
  Delete counterparty

  Deletes a counterparty from your Modern Treasury organization.

• Action
  Get counterparty

  Returns a single counterparty, including its accounts, contact details and metadata.

• Action
  Get invoice

  Returns a single invoice by its ID, including its amounts, status, counterparty and line-item details.

• Action
  Get ledger transaction

  Returns one ledger transaction, including its ledger entries, status and metadata.

• Action
  Get payment order

  Returns the details of a single payment order, including its amount, status, direction and accounts.

• Action
  List internal accounts

  Returns the organization's internal (bank) accounts, optionally filtered by counterparty, legal entity, currency, status or payment capability.

• Action
  Update counterparty

  Updates an existing counterparty's name, email, external ID, legal entity, metadata, remittance-advice setting or taxpayer identifier. Returns the updated counterparty.

• Action
  Update payment order

  Updates an existing payment order, for example changing its amount, description, metadata or status (such as cancelling or approving it). Returns the updated payment order.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.