Azure Sqlvirtualmachine Sqlvm
Azure SQL Virtual Machine is an Azure service for managing SQL Server instances running on Azure virtual machines.
- Base URL:
https://management.azure.com - Auth: OAuth 2.0 (user-delegated) — attach an InTouch
oauthcredential. Mint one withitcli.py /oauth <provider>(device-code) or/google-auth(Google); the server auto-refreshes the access token before each run, so the connector never handles or stores tokens.
Operations
operations_list— GET /providers/Microsoft.SqlVirtualMachine/operations — Lists all of the available SQL Rest API operations.sqlvirtualmachinegroups_list— GET /subscriptions/{subscriptionId}/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups — Gets all SQL virtual machine groups in a subscription.sqlvirtualmachines_list— GET /subscriptions/{subscriptionId}/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines — Gets all SQL virtual machines in a subscription.sqlvirtualmachinegroups_listbyresourcegroup— GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups — Gets all SQL virtual machine groups in a resource group.sqlvirtualmachinegroups_get— GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/{sqlVirtualMachineGroupName} — Gets a SQL virtual machine group.availabilitygrouplisteners_listbygroup— GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/{sqlVirtualMachineGroupName}/availabilityGroupListeners — Lists all availability group listeners in a SQL virtual machine group.
Inputs
- a linked
oauthcredential (no key inputs) — the server injects a freshAuthorization: Bearerfrom it operation— one of the operations above- path parameters when an operation's path contains
{...} query— optional JSON object of query paramsbody— JSON object for create/update ops
Example
operation: operations_list
# (attach an 'oauth' credential to the task — no inline secrets)
Publishes
The keys a later task may reference as {{taskName.key}}. Referencing anything not listed here resolves to nothing at run time.
erroroperationresultstatus
Input Properties
Every property this tool accepts, from its own tool.iml.
| Property | Type | Required | Default | Description |
|---|---|---|---|---|
operation |
string | yes | — | One of: operations_list, sqlvirtualmachinegroups_list, sqlvirtualmachines_list, sqlvirtualmachinegroups_listbyresourcegroup, sqlvirtualmachinegroups_get, availabilitygrouplisteners_listbygroup |
resourceGroupName |
string | no | — | Path parameter resourceGroupName (required by some operations). |
sqlVirtualMachineGroupName |
string | no | — | Path parameter sqlVirtualMachineGroupName (required by some operations). |
subscriptionId |
string | no | — | Path parameter subscriptionId (required by some operations). |
query |
string | no | — | Query-string parameters as a JSON object string, e.g. {"limit": 50}. Parsed and url-encoded onto the request. |