DatabaseQueryExecution

Create database query with assertions and variables

post/database/query/generated

Request

  • Base URL: https://api.mabl.com
  • URL: https://api.mabl.com/database/query/generated
  • Auth: one of:
    • HTTP basic
    • API key in header Authorization

Request body

workspace_idstring required

The ID of the workspace that is requesting the code generation

snippet_type'css' | 'javascript' | 'xpath' | 'sql' | 'postman'
test_type'api' | 'browser' | 'performance' | 'mobile'

Type of test

namestring

The name of the snippet

promptstring

Client provided prompt for code snippet generation

additional_contextstring

Additional context for the code generation request

current_snippetstring

The current snippet body for the code generation request

session_idstring

The session id for the prompt

database_schema_query_execution_idstring

ID of query result with the database schema

database_type'mariadb' | 'mongodb' | 'mssql' | 'mysql' | 'oracle' | 'postgres'

Response

The generated DatabaseQueryExecution entity for the requested execution

bodystring

The code generated by the AI model

descriptionstring

An optional extended description field for the generated result

prompt_idstring

The id of the prompt request

session_idstring

The session id for the prompt

successboolean

Indicates if the code generation was successful

titlestring

A brief description of the generated code result

user_idstring

The id of the user asking for the prompt

workspace_idstring

The workspace id

querystring

Generated SQL query

nosql_operationobject

Generated operation details for non-SQL query operations

Changes

No recorded changes to this operation across all 37 revisions of this API.