InTouch Hub · Blue Isle Software

Azure SQL Database

Azure SQL Database management API — 309 operations consolidated from 85 Microsoft OpenAPI specs into one connector.

Provided free and as is, without warranty of any kind — including merchantability, fitness for a particular purpose, and the accuracy or completeness of any result. See the licence. You are responsible for checking what this produces before relying on it.

azurecloud

Azure SQL Database

Azure SQL Database management API — 309 operations consolidated from 85 Microsoft OpenAPI specs into one connector.

Consolidated from 85 spec-per-resource-provider connectors; every operation from every one of them is preserved. The superseded names still resolve.

Operations

Inputs

Publishes

The keys a later task may reference as {{taskName.key}}. Referencing anything not listed here resolves to nothing at run time.

Input Properties

Every property this tool accepts, from its own tool.iml.

Property Type Required Default Description
operation string yes — One of: backuplongtermretentionpolicies_createorupdate, backuplongtermretentionpolicies_get, backuplongtermretentionpolicies_listbydatabase, backuplongtermretentionvaults_createorupdate, backuplongtermretentionvaults_get, backuplongtermretentionvaults_listbyserver, backupshorttermretentionpolicies_createorupdate, backupshorttermretentionpolicies_get, backupshorttermretentionpolicies_listbydatabase, backupshorttermretentionpolicies_update, blobauditingpolicies_databaseblobauditingpolicies_get, capabilities_listbylocation, databaseadvisors_get, databaseadvisors_listbydatabase, databaseautomatictuning_get, databaseautomatictuning_update, databaseblobauditingpolicies_createorupdate, databaseblobauditingpolicies_get, databaseblobauditingpolicies_listbydatabase, databasecolumns_get, databasecolumns_listbytable, databaseoperations_cancel, databaseoperations_listbydatabase, databaserecommendedactions_get, databaserecommendedactions_listbydatabaseadvisor, databases_createimportoperation, databases_createorupdate, databases_delete, databases_export, databases_failover, databases_get, databases_import, databases_listbyelasticpool, databases_listbyserver, databases_listmetricdefinitions, databases_listmetrics, databases_rename, databases_update, databaseschemas_get, databaseschemas_listbydatabase, databasesecurityalertpolicies_createorupdate, databasesecurityalertpolicies_get, databasesecurityalertpolicies_listbydatabase, databasetables_get, databasetables_listbyschema, databasevulnerabilityassessmentrulebaselines_cre, databasevulnerabilityassessmentrulebaselines_del, databasevulnerabilityassessmentrulebaselines_get, databasevulnerabilityassessments_createorupdate, databasevulnerabilityassessments_delete, databasevulnerabilityassessments_get, databasevulnerabilityassessments_listbydatabase, databasevulnerabilityassessmentscans_export, databasevulnerabilityassessmentscans_get, databasevulnerabilityassessmentscans_initiatesca, databasevulnerabilityassessmentscans_listbydatab, datamaskingpolicies_createorupdate, datamaskingpolicies_get, datamaskingrules_createorupdate, datamaskingrules_listbydatabase, datawarehouseuseractivities_get, disasterrecoveryconfigurations_createorupdate, disasterrecoveryconfigurations_delete, disasterrecoveryconfigurations_failover, disasterrecoveryconfigurations_failoverallowdata, disasterrecoveryconfigurations_get, disasterrecoveryconfigurations_list, elasticpoolactivities_listbyelasticpool, elasticpooldatabaseactivities_listbyelasticpool, elasticpooloperations_cancel, elasticpooloperations_listbyelasticpool, elasticpools_createorupdate, elasticpools_delete, elasticpools_failover, elasticpools_get, elasticpools_listbyserver, elasticpools_listmetricdefinitions, elasticpools_listmetrics, elasticpools_update, encryptionprotectors_createorupdate, encryptionprotectors_get, encryptionprotectors_listbyserver, encryptionprotectors_revalidate, extendeddatabaseblobauditingpolicies_get, extendedserverblobauditingpolicies_get, extensions_get, extensions_listbydatabase, failovergroups_createorupdate, failovergroups_delete, failovergroups_failover, failovergroups_get, failovergroups_listbyserver, failovergroups_update, firewallrules_createorupdate, firewallrules_delete, firewallrules_get, firewallrules_listbyserver, firewallrules_replace, geobackuppolicies_createorupdate, geobackuppolicies_get, geobackuppolicies_listbydatabase, instancefailovergroups_createorupdate, instancefailovergroups_delete, instancefailovergroups_failover, instancefailovergroups_forcefailoverallowdatalos, instancefailovergroups_get, instancefailovergroups_listbylocation, instancepools_createorupdate, instancepools_delete, instancepools_get, instancepools_list, instancepools_listbyresourcegroup, instancepools_update, jobagents_get, jobagents_listbyserver, jobcredentials_get, jobcredentials_listbyagent, jobexecutions_listbyagent, jobs_listbyagent, longtermretentionbackups_get, longtermretentionbackups_listbydatabase, longtermretentionbackups_listbylocation, longtermretentionbackups_listbyresourcegrouploca, longtermretentionbackups_listbyresourcegroupserv, longtermretentionbackups_listbyserver, managedbackupshorttermretentionpolicies_createor, managedbackupshorttermretentionpolicies_get, managedbackupshorttermretentionpolicies_listbyda, managedbackupshorttermretentionpolicies_update, manageddatabasecolumns_get, manageddatabasecolumns_listbytable, manageddatabaserestoredetails_get, manageddatabases_createorupdate, manageddatabases_delete, manageddatabases_get, manageddatabases_listbyinstance, manageddatabases_update, manageddatabaseschemas_get, manageddatabaseschemas_listbydatabase, manageddatabasesecurityalertpolicies_createorupd, manageddatabasesecurityalertpolicies_get, manageddatabasesecurityalertpolicies_listbydatab, manageddatabasesensitivitylabels_createorupdate, manageddatabasesensitivitylabels_delete, manageddatabasesensitivitylabels_disablerecommen, manageddatabasesensitivitylabels_get, manageddatabasesensitivitylabels_listcurrentbyda, manageddatabasesensitivitylabels_listrecommended, manageddatabasetables_get, manageddatabasetables_listbyschema, manageddatabasevulnerabilityassessmentrulebaseli, manageddatabasevulnerabilityassessments_createor, manageddatabasevulnerabilityassessments_delete, manageddatabasevulnerabilityassessments_get, manageddatabasevulnerabilityassessments_listbyda, manageddatabasevulnerabilityassessmentscans_expo, manageddatabasevulnerabilityassessmentscans_get, manageddatabasevulnerabilityassessmentscans_init, manageddatabasevulnerabilityassessmentscans_list, managedinstanceadministrators_createorupdate, managedinstanceadministrators_delete, managedinstanceadministrators_get, managedinstanceadministrators_listbyinstance, managedinstanceencryptionprotectors_createorupda, managedinstanceencryptionprotectors_get, managedinstanceencryptionprotectors_listbyinstan, managedinstanceencryptionprotectors_revalidate, managedinstancekeys_createorupdate, managedinstancekeys_delete, managedinstancekeys_get, managedinstancekeys_listbyinstance, managedinstanceoperations_listbymanagedinstance, managedinstances_createorupdate, managedinstances_delete, managedinstances_get, managedinstances_list, managedinstances_listbyinstancepool, managedinstances_listbyresourcegroup, managedinstancetdecertificates_create, managedinstancevulnerabilityassessments_createor, managedinstancevulnerabilityassessments_delete, managedinstancevulnerabilityassessments_get, managedinstancevulnerabilityassessments_listbyin, managedrestorabledroppeddatabasebackupshorttermr, managedserversecurityalertpolicies_createorupdat, managedserversecurityalertpolicies_get, managedserversecurityalertpolicies_listbyinstanc, operations_list, privateendpointconnections_createorupdate, privateendpointconnections_delete, privateendpointconnections_get, privateendpointconnections_listbyserver, privatelinkresources_get, privatelinkresources_listbyserver, queries_listbydatabase, querystatistics_listbyquery, querytexts_listbyquery, recommendedelasticpools_get, recommendedelasticpools_listbyserver, recommendedelasticpools_listmetrics, recommendedelasticpoolsdecoupled_recommendedelasticpools_get, recommendedelasticpoolsdecoupled_recommendedelasticpools_listbyserver, recommendedelasticpoolsdecoupled_recommendedelasticpools_listmetrics, recoverabledatabases_get, recoverabledatabases_listbyserver, recoverablemanageddatabases_get, recoverablemanageddatabases_listbyinstance, replicationlinks_delete, replicationlinks_failover, replicationlinks_failoverallowdataloss, replicationlinks_get, replicationlinks_listbydatabase, restorabledroppeddatabases_get, restorabledroppeddatabases_listbyserver, restorabledroppedmanageddatabases_get, restorabledroppedmanageddatabases_listbyinstance, restorepoints_create, restorepoints_delete, restorepoints_get, restorepoints_listbydatabase, sensitivitylabels_createorupdate, sensitivitylabels_delete, sensitivitylabels_get, sensitivitylabels_listbydatabase, sensitivitylabels_listcurrentbydatabase, sensitivitylabels_listrecommendedbydatabase, serveradvisors_get, serveradvisors_listbyserver, serverautomatictuning_get, serverautomatictuning_update, serverazureadadministrators_createorupdate, serverazureadadministrators_delete, serverazureadadministrators_get, serverazureadadministrators_listbyserver, serverblobauditingpolicies_get, serverblobauditingpolicies_listbyserver, servercommunicationlinks_createorupdate, servercommunicationlinks_delete, servercommunicationlinks_get, servercommunicationlinks_listbyserver, serverconnectionpolicies_createorupdate, serverconnectionpolicies_get, serverdnsaliases_acquire, serverdnsaliases_createorupdate, serverdnsaliases_delete, serverdnsaliases_get, serverdnsaliases_listbyserver, serverkeys_createorupdate, serverkeys_delete, serverkeys_get, serverkeys_listbyserver, serveroperations_listbyserver, servers_checknameavailability, servers_createorupdate, servers_delete, servers_get, servers_list, servers_listbyresourcegroup, servers_update, serversecurityalertpolicies_createorupdate, serversecurityalertpolicies_get, serversecurityalertpolicies_listbyserver, servervulnerabilityassessments_createorupdate, servervulnerabilityassessments_delete, servervulnerabilityassessments_get, servervulnerabilityassessments_listbyserver, serviceobjectives_get, serviceobjectives_listbyserver, servicetieradvisors_get, servicetieradvisors_listbydatabase, syncagents_createorupdate, syncagents_delete, syncagents_generatekey, syncagents_get, syncagents_listbyserver, syncagents_listlinkeddatabases, syncgroups_createorupdate, syncgroups_get, syncgroups_listbydatabase, syncgroups_listhubschemas, syncgroups_listlogs, syncgroups_listsyncdatabaseids, syncmembers_createorupdate, syncmembers_delete, syncmembers_get, syncmembers_listbysyncgroup, syncmembers_listmemberschemas, syncmembers_update, tdecertificates_create, transparentdataencryptionactivities_listbyconfig, transparentdataencryptions_get, usages_listbyinstancepool, virtualclusters_delete, virtualclusters_get, virtualclusters_list, virtualclusters_listbyresourcegroup, virtualclusters_update, virtualnetworkrules_createorupdate, virtualnetworkrules_delete, virtualnetworkrules_get, virtualnetworkrules_listbyserver, workloadclassifiers_createorupdate, workloadclassifiers_delete, workloadclassifiers_get, workloadclassifiers_listbyworkloadgroup, workloadgroups_createorupdate, workloadgroups_delete, workloadgroups_get, workloadgroups_listbydatabase
administratorName string no — Path parameter administratorName (required by some operations).
advisorName string no — Path parameter advisorName (required by some operations).
backupLongTermRetentionPolicyName string no — Path parameter backupLongTermRetentionPolicyName (required by some operations).
backupLongTermRetentionVaultName string no — Path parameter backupLongTermRetentionVaultName (required by some operations).
backupName string no — Path parameter backupName (required by some operations).
baselineName string no — Path parameter baselineName (required by some operations).
blobAuditingPolicyName string no — Path parameter blobAuditingPolicyName (required by some operations).
columnName string no — Path parameter columnName (required by some operations).
communicationLinkName string no — Path parameter communicationLinkName (required by some operations).
connectionPolicyName string no — Path parameter connectionPolicyName (required by some operations).
credentialName string no — Path parameter credentialName (required by some operations).
dataMaskingPolicyName string no — Path parameter dataMaskingPolicyName (required by some operations).
dataMaskingRuleName string no — Path parameter dataMaskingRuleName (required by some operations).
dataWarehouseUserActivityName string no — Path parameter dataWarehouseUserActivityName (required by some operations).
databaseName string no — Path parameter databaseName (required by some operations).
disasterRecoveryConfigurationName string no — Path parameter disasterRecoveryConfigurationName (required by some operations).
dnsAliasName string no — Path parameter dnsAliasName (required by some operations).
elasticPoolName string no — Path parameter elasticPoolName (required by some operations).
encryptionProtectorName string no — Path parameter encryptionProtectorName (required by some operations).
extensionName string no — Path parameter extensionName (required by some operations).
failoverGroupName string no — Path parameter failoverGroupName (required by some operations).
firewallRuleName string no — Path parameter firewallRuleName (required by some operations).
geoBackupPolicyName string no — Path parameter geoBackupPolicyName (required by some operations).
groupName string no — Path parameter groupName (required by some operations).
instancePoolName string no — Path parameter instancePoolName (required by some operations).
jobAgentName string no — Path parameter jobAgentName (required by some operations).
keyName string no — Path parameter keyName (required by some operations).
linkId string no — Path parameter linkId (required by some operations).
locationName string no — Path parameter locationName (required by some operations).
longTermRetentionDatabaseName string no — Path parameter longTermRetentionDatabaseName (required by some operations).
longTermRetentionServerName string no — Path parameter longTermRetentionServerName (required by some operations).
managedInstanceName string no — Path parameter managedInstanceName (required by some operations).
operationId string no — Path parameter operationId (required by some operations).
policyName string no — Path parameter policyName (required by some operations).
privateEndpointConnectionName string no — Path parameter privateEndpointConnectionName (required by some operations).
queryId string no — Path parameter queryId (required by some operations).
recommendedActionName string no — Path parameter recommendedActionName (required by some operations).
recommendedElasticPoolName string no — Path parameter recommendedElasticPoolName (required by some operations).
recoverableDatabaseName string no — Path parameter recoverableDatabaseName (required by some operations).
resourceGroupName string no — Path parameter resourceGroupName (required by some operations).
restorableDroppedDatabaseId string no — Path parameter restorableDroppedDatabaseId (required by some operations).
restorableDroppededDatabaseId string no — Path parameter restorableDroppededDatabaseId (required by some operations).
restoreDetailsName string no — Path parameter restoreDetailsName (required by some operations).
restorePointName string no — Path parameter restorePointName (required by some operations).
ruleId string no — Path parameter ruleId (required by some operations).
scanId string no — Path parameter scanId (required by some operations).
schemaName string no — Path parameter schemaName (required by some operations).
securityAlertPolicyName string no — Path parameter securityAlertPolicyName (required by some operations).
sensitivityLabelSource string no — Path parameter sensitivityLabelSource (required by some operations).
serverName string no — Path parameter serverName (required by some operations).
serviceObjectiveName string no — Path parameter serviceObjectiveName (required by some operations).
serviceTierAdvisorName string no — Path parameter serviceTierAdvisorName (required by some operations).
subscriptionId string no — Path parameter subscriptionId (required by some operations).
syncAgentName string no — Path parameter syncAgentName (required by some operations).
syncGroupName string no — Path parameter syncGroupName (required by some operations).
syncMemberName string no — Path parameter syncMemberName (required by some operations).
tableName string no — Path parameter tableName (required by some operations).
transparentDataEncryptionName string no — Path parameter transparentDataEncryptionName (required by some operations).
virtualClusterName string no — Path parameter virtualClusterName (required by some operations).
virtualNetworkRuleName string no — Path parameter virtualNetworkRuleName (required by some operations).
vulnerabilityAssessmentName string no — Path parameter vulnerabilityAssessmentName (required by some operations).
workloadClassifierName string no — Path parameter workloadClassifierName (required by some operations).
workloadGroupName string no — Path parameter workloadGroupName (required by some operations).
body string no — Request body as a JSON object string. Sent as JSON, or form-encoded when the operation expects a form. Required by write operations.
query string no — Query-string parameters as a JSON object string, e.g. {"limit": 50}. Parsed and url-encoded onto the request.