Az storage entity query unable to fetch all entries from table
- Dominant language
- Python
- Stars
- 4.6k
- Forks
- 3.5k
- Avg merge
- 3d 2h
- Merged PRs (30d)
- 60
Description
**Description**
I am trying to use Az storage entity query to get entries from a cosmos db table. (following https://docs.microsoft.com/en-us/cli/azure/storage/entity?view=azure-cli-latest#az-storage-entity-query)
The table has about 100 entries, but even after removing all filters, it is able to fetch only ~30 of them.
This is how we are getting the rows -
$tb = (az storage entity query --table-name $TableName --connection-string ) | ConvertFrom-Json
For individual entries, we have observed this
```
{
"items": [
{
"Consortium": "xxxxxx",
"CreatedTime": "2019-09-06T09:34:07.551260+00:00",
"RowKey": "yyyyyy",
"PartitionKey": "zzzzzz-zzzzz-zz-zzzzz-zz",
"Tags": "{}",
"Timestamp": "2019-09-06T09:41:34.660306+00:00",
"etag": "W/\"datetime'2019-09-06T09%3A41%3A34.6603060Z'\""
}
],
"nextMarker": {}
}
```
When the filter is `Rowkey -eq 'yyyyyy'` above entry is not fetched, but it appears with filter `PartitionKey -eq 'zzzzzz-zzzzz-zz-zzzzz-zz'`
This is one of the entries that does not come when entire table is fetched.
**Expected behavior**
All entries should be fetched as it is possible to fetch <= 1000 entries in single run, without need of markers.
**Environment summary**
Install Method MSI
CLI version 2.2.0
Windows 10
powershell 7
Contributor guide
Assessment
This issue has not been assessed yet.