Azure Cost Management API is not returning the Blob location

According to this Official MS Document the Azure Cost management API with scope set to enrollmentAccounts does not contain any blob location in the request. If you want to retrieve the cost of the blob resource, You need to use:-

'/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}'

where resourceGroupName is the name of your resource group containing your blob.

My sample Powershell script that calls the Cost management API:-

$AppId = "xxxxxx-6d26a31435cb"
$AppSecret = "xxxxhhZ~bY."
$TokenURI = "https://login.microsoftonline.com/xxxxxx95/oauth2/token"
$Resource = "https://management.core.windows.net/"

$BodyRequest = "grant_type=client_credentials&client_id=$AppId&client_secret=$AppSecret&resource=$Resource"

$AccessToken = Invoke-RestMethod -Method Post -Uri $TokenURI -Body $BodyRequest -ContentType 'application/x-www-form-urlencoded'

$RequestURI = "https://management.azure.com/subscriptions/0151c365-f598-44d6-b4fd-e2b6e97cb2a7/resourceGroups/siliconstrg909-rg/providers/Microsoft.CostManagement/query?api-version=2023-03-01"

$Headers = @{
    "Authorization" = "Bearer " + $AccessToken.access_token
    "Content-Type" = "application/json"
}

# Updated request body structure
$UsageRequestBody = @{
    type = "Usage"
    timeframe = "MonthToDate"
    dataset = @{
        granularity = "Daily"
        aggregation = @{
            totalCost = @{
                name = "PreTaxCost"
                function = "Sum"
            }
        }
        grouping = @(
            @{
                type = "Dimension"
                name = "ResourceGroup"
            }
        )
    }
}

# Convert the updated payload to JSON
$UsageRequestBodyJson = $UsageRequestBody | ConvertTo-Json

# Make the request using Invoke-RestMethod
$UsageRequest = Invoke-RestMethod -Method Post -Uri $RequestURI -Headers $Headers -Body $UsageRequestBodyJson -ContentType 'application/json'

# Output the response
$UsageRequest.properties.rows
# Check for pagination
while ($UsageRequest.properties.nextLink) {
    $NextLink = $UsageRequest.properties.nextLink
    $UsageRequest = Invoke-RestMethod -Uri $NextLink -Headers $Headers -Method Get
    $UsageRequest.properties.rows
}

Output:-

In your enrollmentAccounts Rest API, Try to add ResourceGroup name in value that contains your blob:-

$AppId = "xxxxxx26a31435cb"
$AppSecret = "xxxxxxxZ~bY."
$TokenURI = "https://login.microsoftonline.com/83xxxxxx92395/oauth2/token"
$Resource = "https://management.core.windows.net/"

$BodyRequest = "grant_type=client_credentials&client_id=$AppId&client_secret=$AppSecret&resource=$Resource"

$AccessToken = Invoke-RestMethod -Method Post -Uri $TokenURI -Body $BodyRequest -ContentType 'application/x-www-form-urlencoded'

$RequestURI = "https://management.azure.com/providers/Microsoft.Billing/enrollmentAccounts/*****5/providers/Microsoft.CostManagement/generateCostDetailsReport?api-version=2023-08-01"

$Headers = @{
    "Authorization" = "Bearer " + $AccessToken.access_token
    "Content-Type" = "application/json"
}

# Updated request body structure
$UsageRequestBody = @{
    type = "Usage"
    timeframe = "MonthToDate"
    dataset = @{
        granularity = "Daily"
        filter = @{
            and = @(
                @{
                    or = @(
                        @{
                            dimensions = @{
                                name = "ResourceLocation"
                                operator = "In"
                                values = @("East US", "West Europe")
                            }
                        },
                        @{
                            tags = @{
                                name = "Environment"
                                operator = "In"
                                values = @("UAT", "Prod")
                            }
                        }
                    )
                },
                @{
                    dimensions = @{
                        name = "ResourceGroup"
                        operator = "In"
                        values = @("YourSampleResourceGroupName")  # Replace this with your actual resource group name
                    }
                }
            )
        }
    }
}

# Convert the updated payload to JSON
$UsageRequestBodyJson = $UsageRequestBody | ConvertTo-Json

# Make the request using Invoke-RestMethod
$UsageRequest = Invoke-RestMethod -Method Post -Uri $RequestURI -Headers $Headers -Body $UsageRequestBodyJson -ContentType 'application/json'

# Output the response
$UsageRequest
# Check for pagination
while ($UsageRequest.properties.nextLink) {
    $NextLink = $UsageRequest.properties.nextLink
    $UsageRequest = Invoke-RestMethod -Uri $NextLink -Headers $Headers -Method Get
    $UsageRequest
}

Also, There’s a separate Rest API dedicated to Azure Blob Storage, You can try calling the Azure blob Powershell command to retrieve the blob properties like below:-

# Connect to Azure account and set the desired subscription
Connect-AzAccount -TenantId xxxxxxxab9
Set-AzContext -SubscriptionId 'xxxxxxcb2a7'

# Get the storage account context
$ctx = Get-AzStorageAccount -ResourceGroupName "valleyrg87" -Name "siliconstorage678"

# Check if the context is retrieved properly
$ctx


# Get the storage account context
$ctx = Get-AzStorageAccount -ResourceGroupName "valleyrg87" -Name "siliconstorage678"

# Check if the context is retrieved properly
$ctx

# If context is retrieved successfully, proceed to get blob properties
if ($ctx) {
    # Get the blob reference
    $blob = Get-AzStorageBlob -Blob "hello_world.py" -Container "data" -Context $ctx.Context

    # Check if the blob is retrieved successfully
    $blob

    # If the blob is retrieved successfully, get blob properties
    if ($blob) {
        $properties = $blob.ICloudBlob.Properties
        $properties
    } else {
        Write-Host "Blob not found or there was an issue retrieving the blob."
    }
} else {
    Write-Host "Storage account not found"
}

Output:-