Stack Overflow
Stack Overflow

Questions tagged [azure-tablequery]

126 questions
1
vote
0 answers

Apply filter to fetch records from Azure Storage Table

Need records from Azure Storage Table. Either need to apply filter on storage table OR first get all records in code and apply filter. Result should have records (all fields) only for ID, whose RelatedTypes must have entry in table with this ID. Eg:…
Anoop Soni
  • 11
  • 1
  • 4
1
vote
1 answer

Azure Table Query Limits with ExecuteQuerySegmentedAsync vs ExecuteQuery

What are the limits of calling ExecuteQuery()? For example, limits on the number of entities and download size. In other words, when will the method below hit its limits? private static void ExecuteSimpleQuery(CloudTable table, string partitionKey,…
Pingpong
  • 7,681
  • 21
  • 83
  • 209
1
vote
1 answer

How to retrieve latest record from Azure table storage using C#?

I'm facing an issue with azure table storage. I have hundreds of thousands of data into the storage table that I need to query. First approach is to retrieve all the data and then queried as per the requirement but its taking too much time. Second…
Ravinder bachhal
  • 11
  • 2
1
vote
1 answer

Retrieving data from Azure Table Storage using Azure Cosmos Library in the FSI Fails

I am using Visual Studio 2019 with a F# script file. I imported the latest nuget package to insert and retrieve an entity in Azure Table Storage Install-Package Microsoft.Azure.Cosmos.Table -Version 1.0.5 The Insert works fine, but the retrieval…
Jamie Dixon
  • 4,204
  • 4
  • 25
  • 47
1
vote
1 answer

AND operation using TableQuery.CombineFilters on a List

How can I assign initial value to myQuery where I am appending conditions using AND and a foreach loop. I am trying to do the following: string myQuery = string.empty; foreach (string myCondition in myConditionLists) { myQuery =…
Shamim Hafiz - MSFT
  • 21,454
  • 43
  • 116
  • 176
1
vote
0 answers

Unable to find entities from table storage after inserting batches of 100

Issue: We currently have two azure consumption plan functions, each receiving service bus queue messages as input. The first functions call SQL Azure with a stored proc, gets 500k+ records back, saves those records in batches of a 100 to Azure table…
Martin
  • 119
  • 1
  • 7
1
vote
1 answer

How can I fetch the last N entities in Javascript for a Azure storage table query

I have the query code below, but it fetches the top 3 values with one of two primary keys. What I want is to select the last 3 rows instead. FYI - my RowKeys are incramentally added numbers (ex. 1,2,3,4,5) var tableUri =…
chuckd
  • 13,460
  • 29
  • 152
  • 331
1
vote
1 answer

Fluent methods may not be invoked on a Query created via CloudTable.CreateQuery()

I use WindowsAzure.Storage 9.1.1 nuget package and when I run: var table = GetTableReference(vehicleStatusTableName); var condition = TableQuery.CombineFilters( TableQuery.GenerateFilterCondition(partitionKey, QueryComparisons.Equal,…
Andrei
  • 42,814
  • 35
  • 154
  • 218
1
vote
1 answer

Deserialize a DynamicTableEntity retrieved from Azure Table

I want to print a DynamicTableEntity object retrieved from an Azure Table. I am not aware of the properties of the retrieved object. I am getting an error in using Newtonsoft.Json var toreturn =…
benedemon
  • 411
  • 2
  • 5
  • 14
1
vote
1 answer

How to query using TableQuery via IEnumerable?

I am exposing my Table via the following method: public static class TableCacheService { public static IEnumerable Read() { var acc = new CloudStorageAccount( new StorageCredentials("account",…
Alex Gordon
  • 191
  • 11
1
vote
1 answer

How to delete Azure table entities based on range query results

Am trying to delete Azure table entities based on my range filter. All am trying here is to delete the older records. I was able to get the correct entites based on my range search condition. TableQuery rangeQuery = new…
Pரதீப்
  • 91,748
  • 19
  • 131
  • 172
1
vote
1 answer

Azure Table Storage as Sink in Data Factory Row Key

I want to pass a value for the row key as a parameter just like the partition key. But the UI only gives me an option to use unique identifier or a source column. Actually I need to use this same entity somewhere else. How will I query this entity…
das
  • 201
  • 1
  • 3
  • 10
1
vote
2 answers

Authorization of Azure Storage service REST API for table

i've been stuck for the whole day making my call of Azure Storage REST API. response showed that it's due to error in Azure authentication, but I have no idea what's the problem. you can check the similar problem here also Authorization of Azure…
Sandeep Bhaskar
  • 300
  • 2
  • 12
1
vote
2 answers

Azure Table Storage Querying using Python- Read Integer Column

I am trying to query Azure Table Storage using Python. An int32 datatype column doesn't return its value but returns something like this azure.storage.table.models.EntityProperty obj..... But, in case of string datatype columns, i am not facing any…
AngiSen
  • 915
  • 4
  • 18
  • 41
1
vote
2 answers

Table Storage SDK

I am trying to load some data from a CSV file to Azure table storage row by row using Python. String columns are getting inserted directly but the date column mentioned in the source in the format 2018-02-18T11:29:12.000Z is still loaded as string.…
AngiSen
  • 915
  • 4
  • 18
  • 41
1 2 3
…
8 9