Connect Openlayer and SQL Server

Both apps 35Openlayer 24SQL Server 11

• Trigger
  New Project

  Triggers when a new project is created in your Openlayer workspace.

• Trigger
  New Test Result

  Triggers when a new test result is available for a data source. Useful for alerting on passing or failing model tests.

• Action
  Create Data Source

  Creates a new data source in a project for streaming production data to Openlayer.

• Action
  Create Project

  Creates a new AI or ML project in your Openlayer workspace.

• Action
  Create Test

  Creates a data quality test in a project. Checks for duplicate rows, null values, or row counts.

• Action
  Delete Inference Pipeline

  Delete an inference pipeline by its ID.

• Action
  Delete Project

  Delete a project by its ID.

• Action
  Delete Test

  Delete a test by its ID.

• Action
  Evaluate Test

  Evaluates a test for a specific time range. Use after publishing records to get immediate results.

• Action
  Find Data Source

  Finds a data source (inference pipeline) by name in a project.

• Action
  Find Project

  Finds a project by name in your Openlayer workspace.

• Action
  Find Test Result

  Finds test results for a data source, including whether each test passed or failed. Filter by outcome or test type to branch an automation on the result.

• Action
  Get Inference Pipeline

  Retrieve the details around a specific inference pipeline.

• Action
  Get Project

  Retrieves one project by its id. Openlayer has no single-project endpoint, so this reads the workspace's first 100 projects and returns the one matching the id.

• Action
  Get Test

  Retrieve a test by ID.

• Action
  Get Test Result

  Retrieves one test result by its id. Openlayer has no single-result endpoint, so this reads the data source's 100 most recent results and returns the matching one.

• Action
  List Inference Pipelines

  List the authenticated user's inference pipelines under a project.

• Action
  List Projects

  Lists the projects in your Openlayer workspace, optionally narrowed to one kind of project. Returns up to 100 projects.

• Action
  List Test Results

  List all results for a test/goal under an inference pipeline.

• Action
  List Tests

  Lists the tests in a project, optionally narrowed by kind, archived state or monitoring mode. Returns up to 100 tests.

• Action
  Publish Record

  Publishes an LLM inference record to a data source for monitoring. Streams the model input, output, and metadata to Openlayer.

• Action
  Update Inference Pipeline

  Update an inference pipeline.

• Action
  Update Project

  Update a project.

• Action
  Update Test

  Update a test (partial updates allowed).

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