[Bug]: Unable to create Storage Container and Blob in Azure Government

[enel1221]

Is there an existing issue for this?

• I have searched the existing issues

Affected Resource(s)

• storage.azure.upbound.io/v1beta2 - Container
• storage.azure.upbound.io/v1beta2 - Blob

Resource MRs required to reproduce the bug

---
apiVersion: storage.azure.upbound.io/v1beta2
kind: Account
metadata:
  name: test
  annotations:
    meta.upbound.io/example-id: storage/v1beta2/blob
  labels:
    testing.upbound.io/example-name: test
spec:
  providerConfigRef:
    name: default
  forProvider:
    accountReplicationType: LRS
    accountTier: Standard
    location: usgovvirginia
    resourceGroupName: testrg
    blobProperties:
      - versioningEnabled: false
---
apiVersion: storage.azure.upbound.io/v1beta2
kind: Container
metadata:
  annotations:
    meta.upbound.io/example-id: storage/v1beta2/blob
  labels:
    testing.upbound.io/example-name: test
  name: test
spec:
  providerConfigRef:
    name: default
  forProvider:
    containerAccessType: private
    storageAccountNameSelector:
      matchLabels:
        testing.upbound.io/example-name: test
---
apiVersion: storage.azure.upbound.io/v1beta2
kind: Blob
metadata:
  annotations:
    meta.upbound.io/example-id: storage/v1beta2/blob
  labels:
    testing.upbound.io/example-name: test
  name: test
spec:
  providerConfigRef:
    name: default
  forProvider:
    storageAccountNameSelector:
      matchLabels:
        testing.upbound.io/example-name: test
    storageContainerNameSelector:
      matchLabels:
        testing.upbound.io/example-name: test
    type: Block

Steps to Reproduce

1. Create a storage account, container and blob using the above configuration.
2. Observe the issue caused by incorrect endpoint.

What happened?

Storage Account gets created however Container and Blob error out

Relevant Error Output Snippet

expected the account "testi.blob.core.windows.net" to use a domain suffix of "core.usgovcloudapi.net"

Crossplane Version

1.18.0

Provider Version

1.10.1

Kubernetes Version

1.30.3

Kubernetes Distribution

EKS, AKS

Additional Info

I believe the issue may be related to these lines

provider-upjet-azure/config/externalname.go

Lines 838 to 840 in 527df19

	"azurerm_storage_blob": config.TemplatedStringAsIdentifier("name", "https://{{ .parameters.storage_account_name }}.blob.core.windows.net/{{ .parameters.storage_container_name }}/{{ .external_name }}"),
	"azurerm_storage_blob_inventory_policy": config.IdentifierFromProvider,
	"azurerm_storage_container": config.TemplatedStringAsIdentifier("name", "https://{{ .parameters.storage_account_name }}.blob.core.windows.net/{{ .external_name }}"),