Azurerm API Connection On Premise Data gateway

[GTunney]

Is there an existing issue for this?

• I have searched the existing issues

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment and review the contribution guide to help.

Terraform Version

v1.8.2

AzureRM Provider Version

v3.103.1

Affected Resource(s)/Data Source(s)

azurerm_api_connection

Terraform Configuration Files

data "azurerm_client_config" "current" {}

resource "azurerm_api_connection" "sql_connection" {
  name                = "apic-SERVER01"
  resource_group_name = var.resource_group_name
  managed_api_id      = "/subscriptions/${data.azurerm_client_config.current.subscription_id}/providers/Microsoft.Web/locations/uksouth/managedApis/sql"
  display_name        = "SERVER01 Connection"
  tags                = var.tags

  parameter_values= {
      "username" = "USER"
      "password" = "PASSWORD"
      "authType"= "Windows",
      "database"= "integration",
      "server"= "SERVER01",
      "gateway"= "/subscriptions/${data.azurerm_client_config.current.subscription_id}/resourceGroups/rg-non-prod-db-uks/providers/Microsoft.Web/connectionGateways/odgw-datawarehouse-qa"
  }
}

Debug Output/Panic Output

│ Error: creating Connection (Subscription: "subscription_id"
│ Resource Group Name: "rg-oasis-dev"
│ Connection Name: "apic-SERVER01"): unexpected status 400 (400 Bad Request) with error: ConnectionGatewayReferenceMissing: The gateway reference connection parameter is missing for the on-premise connection request.
│
│   with module.azurerm_api_connection.azurerm_api_connection.sql_connection,
│   on modules\api-connection\main.tf line 18, in resource "azurerm_api_connection" "sql_connection":
│   18: resource "azurerm_api_connection" "sql_connection" {

Expected Behaviour

api connection for on premise data gateway should be created

Actual Behaviour

Terraform apply is returning the error mentioned

Steps to Reproduce

terraform apply

Important Factoids

No response

References

No response