Unable to query Azure Table Storage using Azure CLI

Question

I wanted to filter the entry in my Azure Storage Table and the structure looks like the following. I wanted to filter the entry's based on the given Id for example JD.98755. How can we achieve this?

{
  "items": [
    {
      "selectionId": {
        "Id": "JD.98755",
        "status": 0
       },
    "Consortium": "xxxxxx",
    "CreatedTime": "2019-09-06T09:34:07.551260+00:00",
    "RowKey": "yyyyyy",
    "PartitionKey": "zzzzzz-zzzzz-zz-zzzzz-zz",
    "Timestamp": "2019-09-06T09:41:34.660306+00:00",
    "etag": "W/\"datetime'2019-09-06T09%3A41%3A34.6603060Z'\""
    }
  ],
  "nextMarker": {}
}

I can filter other elements like the Consortium using the below query but not the Id

az storage entity query -t test --account-name zuhdefault --filter "Consortium eq 'test'"

I tried something like the following to filter based on the given ID but it has not returned any results.

az storage entity query -t test --account-name zuhdefault --filter "Id eq 'JD.98755'"
{
  "items": [],
  "nextMarker": {}
}

RithwikBojja · Accepted Answer · 2023-01-25 04:23:03Z

1

I do agree with @Gaurav Mantri and I guess one of other approach you can use is:

I have reproduced in my environment and got expected results as below:

Firstly, you need to store the output of the command into a variable like below:

I have stored output in $x variable:

$x

enter image description here

Then you can change the output from Json:

$r= $x | ConvertFrom-Json

enter image description here

Then you can store items.id value in a variable like below:

enter image description here

Now you can use below command to get the items with Id JD.98755:

enter image description here

If you have more data, then store the first output into variable then divide them into objects using ConvertFrom-json and then you use the above steps from first.

edited Jan 25, 2023 at 4:23

answered Jan 25, 2023 at 4:15

RithwikBojja

12k2 gold badges5 silver badges16 bronze badges

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

Comments

Gaurav Mantri · Accepted Answer · 2023-01-24 18:21:44Z

The reason you are not getting any data back is because Azure Table Storage is a simple key/value pair store and you are storing a JSON there (in all likelihood, the SDK serialized JSON data and stored it as string in Table Storage).

Considering there is no key named Id, you will not be able to search for that.

If you need to store JSON document, one option is to make use of Cosmos DB (with SQL API) instead of Table Storage. Other option would be to flatten your JSON so that you store them as key/value pair. In this scenario, your data would look something like:

{
  "selectionId_Id": "JD.98755",
  "selectionId_status": 0,
  "Consortium": "xxxxxx",
  "CreatedTime": "2019-09-06T09:34:07.551260+00:00",
  "RowKey": "yyyyyy",
  "PartitionKey": "zzzzzz-zzzzz-zz-zzzzz-zz",
  "Timestamp": "2019-09-06T09:41:34.660306+00:00",
  "etag": "W/\"datetime'2019-09-06T09%3A41%3A34.6603060Z'\""
}

then you should be able to filter by selectionId_Id.

Collectives™ on Stack Overflow

Unable to query Azure Table Storage using Azure CLI

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related