Test a SQL macro execution.
Executes the macro in a transaction that is rolled back after execution. Requires superadmin privileges.
cURL
curl --request POST \ --url https://api.example.com/api/v1/macros/{macro_id}/test \ --header 'Content-Type: application/json' \ --data ' { "parameters": [ "<string>" ] } '
{ "execution_time": 123, "result": "<string>", "rows_affected": 0 }
Schema for testing a macro.
Array of test values to pass to the macro
Successful Response
Schema for macro test response.
Execution time in milliseconds
The result of the macro execution
Number of rows affected (always 0 for SELECT)