InvalidQueryParameterValue in Query Blob Contents using REST API

Question

I'm trying to query Azure query blob content through REST API, following the documentation below

https://learn.microsoft.com/en-us/rest/api/storageservices/query-blob-contents

I made my blob contents public for testing and a GET request to blob URI is giving the content, but making a post request to mentioned URI

https://myaccount.blob.core.windows.net/mycontainer/myblob?comp=query (replaced myaccount, mycontainer and myblob)

giving me following error

<?xml version="1.0" encoding="utf-8"?>
<Error>
    <Code>InvalidQueryParameterValue</Code>
    <Message>Value for one of the query parameters specified in the request URI is invalid.
RequestId:1c52fc4f-801e-0061-63fc-f98163000000
Time:2021-02-03T07:15:32.9547540Z</Message>
    <QueryParameterName>comp</QueryParameterName>
    <QueryParameterValue>query</QueryParameterValue>
    <Reason />
</Error>

blob content is JSON and Blob is a Block Blob type

Ivan Glasenberg · Accepted Answer · 2021-02-04 06:19:17Z

5

I think you might use the SharedKey for authentication when using Query Blob Contents rest api.

If it's the case, you'd better add the steps or code about how do you build the Authorization header. There might be a minor error there.

I give it a try by using sas token for authentication(you can refer to this link for how to generate sas token via azure portal or code), and it can work well.

Here is my request url:

https://yy1.blob.core.windows.net/a11/my11.csv?comp=query&my_sas_token

And in postman, the request headers are as below:

the request body is as below:

And as you can see the test results in the above screenshots, the status code is 200, and we can get the expected blob content.

answered Feb 4, 2021 at 6:19

Ivan Glasenberg

30.3k2 gold badges56 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

ASHMIL Over a year ago

After adding SAS Token I got this error solved, Thanks for your help. but now it is showing. A required feature for this operation is not enabled on the account, BlobQuery. I searched for an option like this in Azure and not able to find it. How to enable this feature in my account?

Ivan Glasenberg Over a year ago

@ASHMILHUSSAINK, what's your azure storage? general purpose v2 or others? are you querying a .json/.csv file or other types of file?

ASHMIL Over a year ago

@Ican Yang, Storage is StorageV2 (general purpose v2) I have tried with Both .json and .csv

Ivan Glasenberg Over a year ago

@ASHMILHUSSAINK the file is block blob type?

ASHMIL Over a year ago

Yes the file is Block blob

|

Collectives™ on Stack Overflow

InvalidQueryParameterValue in Query Blob Contents using REST API

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related