Error When Listing and Downloading Blobs from Azure Storage Account Using SAS Token

Hi @Manuj Shivam Sharma

Welcome to Microsoft Q&A, thanks for posting your query.

The HttpResponseError: The requested URI does not represent any resource on the server typically means that the Azure Blob Storage service cannot locate the resource (in this case, a blob) you are trying to access.

Please follow the below steps that may solve your issue.

Check the SAS Token Permissions:

• Verify the SAS token has the necessary permissions to list and read blobs in the container. The token should have at least the list and read permissions.

Verify the Blob Service URL:

• Make sure that the (poc-powerapp-container) is correctly formatted. It should look something like "https://<storage_account_name>.blob.core.windows.net". Ensure that there are no typos or extra characters.
• Confirm <storage_account_name> matches your actual Azure Storage account name. Do not include the container name in this URL.

Ensure the Container Exists:

• Double-check that the container name (poc-powerapp-container) is correct and that the container actually exists in your Azure Storage account.

Check for Blob Existence:

• Before accessing the blob, you can check to see if the blob exists. You can do this by using the get_blob_properties method to verify the blob's existence.

Here’s an updated version of your code with additional checks and error

from azure.storage.blob import BlobServiceClient, ContainerClient
from io import BytesIO
import pandas as pd
container_name = 'poc-powerapp-container'
sas_token = 'your_sas_token'
blob_service_url = 'your_blob_service_url'
blob_service_client = BlobServiceClient(account_url=blob_service_url, credential=sas_token)
container_client = blob_service_client.get_container_client(container_name)
# List blobs in the container
blobs_list = container_client.list_blobs()
for blob in blobs_list:
    if 'parquet' in blob.name.lower():
        try:
            # Check if the blob exists
            blob_client = blob_service_client.get_blob_client(container=container_name, blob=blob.name)
            blob_properties = blob_client.get_blob_properties()  # This will raise an error if the blob doesn't exist
            # Download the blob into a BytesIO stream
            stream = BytesIO()
            blob_client.download_blob().readinto(stream)
            stream.seek(0)
            # Save the stream contents to a local Parquet file
            local_parquet_file_path = "local_file_path.parquet"
            with open(local_parquet_file_path, 'wb') as f:
                f.write(stream.getbuffer())
            print(f"Parquet file saved as '{local_parquet_file_path}'")
            # Read the Parquet file into a pandas DataFrame
            df = pd.read_parquet(local_parquet_file_path)
            print(df.head())
        except Exception as e:
            print(f"Error processing blob {blob.name}: {e}")

Here are some troubleshooting steps to check the "HttpResponseError: The requested URI does not represent any resource on the server" error:

• Before processing, print their names of the blobs to confirm you are trying to access. This can help you confirm that you are attempting to access the correct blobs.

print(f"Processing blob: {blob.name}")

• Ensure that the blob names do not contain special characters that may cause issues in the URI. Special characters such as spaces, slashes, and question marks can cause issues with the URI and prevent the BlobServiceClient or ContainerClient from connecting to the container.
• Test with a different blob if possible. Try accessing a known blob directly by its name to see if the issue persists. This can help isolate whether the problem is with specific blobs or the overall configuration.
• Use Azure Storage Explorer to manually check the container and blobs. This can help confirm that everything is set up correctly and identify any issues with the container or blobs.

I also recommend reviewing similar threads that may provide further insight into the issue you are encountering.

Similar threads:

unable to upload a blob - Microsoft Q&A

https://stackoverflow.com/questions/69878614/getting-the-requested-uri-does-not-represent-any-resource-on-the-server-even-w

Please feel free to contact if the issue persists, we will be glad to assist you closely.

Hi @Vinod Kumar Reddy Chilupuri

Thanks for taking out your time for this issue of mine.

Just wanted to share with you that I have tried all the steps which you have suggested but the problem is still persisting.

However, any alternative solution or approach is always welcomed!