Stack Overflow
Stack Overflow

Questions tagged [azure-tablequery]

126 questions
2
votes
2 answers

paging (ascendingly ordered) with azure table storage

This works fine to page over data in steps of at most 1000 items: var q1 = (from book in table.CreateQuery() where book.PartitionKey == "TestPartition" select book).AsTableQuery(); TableContinuationToken…
cs0815
  • 16,751
  • 45
  • 136
  • 299
2
votes
1 answer

Restricting Azure TableQuery by Entity type

I have a single table in Azure Table Storage (well, actually in the emulator) which contains multiple entity types, two of which are AzureRuleInfo and AzureCostCodeInfo. I want to pull out a range of AzureRuleInfo and AzureCostCodeInfo entities…
Adrian K
  • 9,880
  • 3
  • 33
  • 59
1
vote
1 answer

Migrate from Microsoft.WindowsAzure.Storage.Table to Azure.Data.Tables - deserialization issues

I'm in the process of migrating code from Microsoft.WindowsAzure.Storage.Table to the Azure.Data.Tables. The issue described appears on querying entities with content that don't match the datatype. Consider the following snippet of migrated…
kseeker
  • 21
  • 1
  • 4
1
vote
0 answers

Is TableQuery.GenerateFilterCondition no longer available in Azure.Data.Tables?

I'm updating a large code base from the now-deprecated WindowsAzure.Storage package to Azure.Data.Tables, and I'm having a hard time figuring out how to convert my queries. I have dozens, maybe hundreds of queries built using…
Brian Rak
  • 4,912
  • 6
  • 34
  • 44
1
vote
1 answer

Azure table query failing with bad request error

I am querying my azure table storage for some output. I can do it in Azure Storage Explorer, and to me the query generated in my code LOOKS like it should work as it does in Azure Storage Explorer. It fails and returns bad request, and I just don't…
dinotom
  • 4,990
  • 16
  • 71
  • 139
1
vote
1 answer

There is no implicit reference conversion from table to ITableEntity in Azure Function

I am writing my first Azure Function and Azure table code. I am getting issue when I write Get query function. I have the following code that would try to get all the jobs from the table. public static class GetJobStatus { …
Sri Reddy
  • 6,832
  • 20
  • 70
  • 112
1
vote
1 answer

Querying specific columns Azure Table Storage

I am moving data from Azure Table Storage (source) to Azure Table Storage (Destination) I have lets say 15 columns in my source but I only want 7 of those in my destination. How can I, or what is the best way to map or query that. I have done some…
gumdrop
  • 35
  • 1
  • 9
1
vote
1 answer

Calling a JS function without parentheses?

How the following code makes a call to odata function, is this a new language feature? what is the name of this new language feature and where can I find its reference?: const { odata, TableClient } = require("@azure/data-tables"); const…
mehran
  • 1,314
  • 4
  • 19
  • 33
1
vote
1 answer

Azure table Storage - Table service Query to retrieve and return 10 entities till last entity

I have a table storage table which has more than 2000 entities. Performing Table service query execution to fetch all 2000 entities in one go is taking time. So I was trying to use LINQ Take operator but it is returning only 10 entities. What should…
Sumithra
  • 49
  • 11
1
vote
1 answer

Argument of type 'null' is not assignable to parameter of type 'TableContinuationToken'

According to the docs link, when querying a table using queryEntities, the continuationToken can be passed in as null or undefined (Please use 'null' or 'undefined' if this is the first operation.) However, that does not compile: Argument of type…
Piyush Kumar
  • 169
  • 1
  • 9
1
vote
2 answers

Azure Table Storage - 501 Not Implemented

I'm following this guide for using Azure Tables: https://learn.microsoft.com/en-us/dotnet/api/overview/azure/data.tables-readme-pre which uses the Azure.Data.Tables NuGet package. I can successfully save a row and see it in the storage explorer…
David Masters
  • 8,069
  • 2
  • 44
  • 75
1
vote
2 answers

Extracting Byte values from Azure Table Storage

I am writing a python script to query data from an Azure Table Storage. The data which I want to extract is of type Binary (The info is serialized and stored) When I run the code using entity['BodyChunk01] I get the value back as 'BodyChunk01':…
Sajjad Zulphekari
  • 23
  • 5
1
vote
0 answers

Azure tables filtering by partition key value

I would like to filter value on an azure table where partitionKey is equal to a value. var query = new azure.TableQuery().stringFilter('PartitionKey', 'eq', Tenant); tableSvc.queryEntities( TABLE_VALUE, query, null, async function…
Hamza Haddad
  • 1,516
  • 6
  • 28
  • 48
1
vote
1 answer

Query Azure Table Storage with Rest Api

I am trying to retrieve data from azure data table using the rest api.The Url looks something like this. https:///Customers(PartitionKey='MyPartition') The Api error's out with Invalid data. If I add RowKey as well along with…
Rocket Singh
  • 469
  • 1
  • 10
  • 22
1
vote
1 answer

How to use Microsoft.WindowsAzure.Storage.Table 's TableOperators.Not operator

I am using Microsoft.WindowsAzure.Storage.Table's TableOperators to generate table queries and combining clauses using TableQuery.CombineFilters. But I do not see a way to use 'TableOperators.Not' to take negation of a clause. How can that be done?
Sayantan Ghosh
  • 998
  • 2
  • 9
  • 29
1 2
3
…
8 9