2,396 questions
0
votes
0
answers
40
views
Azure Table PHP Retrieve Latest Data First with Pagination
I am using this:
https://github.com/Azure/azure-storage-table-php
to insert data to azure table.
However, when I retrieve the data, I don’t get the latest entries unless I use a do...while loop, as ...
0
votes
1
answer
186
views
Table storage through Private endpoint
I can successfully connect to my blob storage using private endpoint with VPN configured. However, when I tried to access the table storage, the same storage account with the blob storage, I ...
0
votes
1
answer
149
views
Automated Cleanup of Azure Logic App Logs in Table Storage
I’ve implemented a weekly Logic App (V2) workflow to automatically purge old Logic App operational logs stored in Azure Table Storage, since there isn’t a built‑in retention policy for those tables. ...
0
votes
1
answer
97
views
Azure table .NET - empty Guid by parsing
I am trying to get the stored data from the Azure table. However, when I am trying to parse the stored id from type Guid, I will get an empty Guid 00000000-0000-0000-0000-000000000000.
public async ...
0
votes
2
answers
141
views
Azure Table Storage REST API not returning data
I have an IoT device that logs data every 3 minutes and uploads that data to Azure Table Storage every 10 minutes. This means the table entities have the built in Timestamp property and a date ...
0
votes
3
answers
136
views
How to authenticate azurite REST API table storage?
I am trying to make a request to the Azurite api from a cypress test. I understand I need an authentication header and I tried using a nodejs script to generate the header. I keep getting an ...
1
vote
1
answer
361
views
Error with Power Query and Azure Storage Table
I have an Azure AI Knowledge store, the data is generated in Azure Storage Tables. When I try to query the data using Power Query in Power BI Desktop I'm getting intermittent errors of the form:
...
0
votes
1
answer
71
views
Writing using TableOutput, Reading using TableClient: String to Int cast error
I have the following class:
public class MyData
{
public string PartitionKey { get; set; }
public string RowKey { get; set; }
public int NumOranges { get; set; }
public int NumApples { get; ...
2
votes
2
answers
542
views
How do configure azure table storage in local docker container?
I am trying to set up a repository class that will create a table if it doesn't exist in my azure storage database. Here's the constructor:
public TableStorageRepository(string ...
2
votes
1
answer
215
views
property value exceeds the maximum allowed size (64KB). If the property value is a string, it is UTF-16 encoded and the maximum number of characters
I've been working on implementing an Audit Trail in an ASP.NET Core 8 Web API, utilizing the Audit.NET library, specifically with the AzureStorageTableDataProvider for storing audit events. The ...
0
votes
1
answer
133
views
Change the Data Type of data in Azure Table Storage
I have an Azure Data Table (ATS) with some data (about 3000 records) where one of the fields was saved as a Byte Array instead of a string. Is there an easy way to convert these to a string data type?...
0
votes
2
answers
318
views
Connect private Azure Table Storage Account with AI search
I have a Azure AI search instance and an Azure Table Storage Account. Both are in the Germany West Central region. Both services have a private endpoint and are connected to the same vnet and also to ...
0
votes
1
answer
774
views
Azure Function App trying to access diagnostics storage table
We have several Azure Functions deployed into a CAF subscription with VNET integration. We use Application Insights to collect our logs.
In the logs we see that every 10 minutes several requests are ...
1
vote
1
answer
192
views
UpsertEntityAsync throwing error after i migrate from Microsoft.Azure.Cosmos.Table to Azure.Data.Tables
i am in progress of migrating an existing project that have Microsoft.Azure.Cosmos.Table to Azure.Data.Tables. I was following the migration guide and implemented my custom model with ITableEntity
...
0
votes
1
answer
327
views
Pagination and continuation token in Azure Table Storage Python API
Similar questions asked here but the azure table package has updated significantly since then and that solution doesn't work any more.
I'm using Azure Data Table Package V12.6.0: https://pypi.org/...
0
votes
1
answer
391
views
Azure function not working once deployed to access Azure Storage
I created an Azure function project in VS Code, using .NET 8 isolated. I followed the instructions here Develop Azure Functions by using Visual Studio Code and once I finished and deployed it, the ...
0
votes
1
answer
296
views
Azure Table Storage - how to fetch multiple records given multiple row keys all belonging to a single partition
I have a set of row keys say
CloudTable table = cloudTableClient.GetTableReference("MyTable");
var partitionKey = "PK";
var rowKeys = new List<string>{"RK1","...
1
vote
1
answer
220
views
Azure Table Storage SDK: Continuation Token Not Working, Fetches Same Data Repeatedly
I am using microsoft/azure/storage-table v1.1 SDK in PHP to fetch entities from my Azure Table. My objective is to retrieve all entities. There are over 2000. When you retrieve entities Azure will ...
0
votes
1
answer
75
views
Is it OK to store different data types on the same Azure Table storage "column" (under the same key)?
Is it OK when most of my rows include an Int32 value under a given key, but sometimes contain a String instead?
I want to do this to set them to "null" to work around the fact that values ...
0
votes
1
answer
66
views
Error on Azure Storage Tables using Peter Test Framework by adding PowerShell commands
I'm getting error while trying to list the azure storage tables using Pester framework. The same commands in PowerShell are working fine. My requirement is I want to convert the PowerShell commands ...
-2
votes
1
answer
93
views
Null Exception when using my own class derived from ITableEntity
Trying to retrieve some data from Azure Table Storage using Azure.Data.Tables
The below code, when using TableEntity works fine but when I use my own class derived from ITableEntity I get an exception ...
0
votes
1
answer
200
views
How do I define a not required Pydantic Field in a ModelBase that needs other fields to be defined without my Lintern complaining?
So, I am working in creating a kind of ORM for Azure Tables for my job, the problem is, I need to not pre-define the field called table_client because that doesn't make sense, I need to build the ...
0
votes
0
answers
100
views
I am unable to properly delete an Azurite table. When I recreate it the original table comes back
I am writing a web application and one of the things it does it to create and populate Azurite tables. I can view these tables in Azurite Storage Explorer.
However, if I:
Delete a table (in Azurite ...
-1
votes
1
answer
182
views
how to get insertedRecord from Azure.Data.Tables UpsertEntityAsync
I'm migrating from Microsoft.Azure.Cosmos.Table to Azure.Data.Tables following this
with cosmos i had this method to insert/merge and return the inserted record
private async Task<...
0
votes
1
answer
392
views
Why am I getting a 403 Forbidden error when trying to access Azure Table Storage?
I am using PowerShell to interact with Azure Table Storage, but I keep receiving a 403 Forbidden error.
Here is the relevant part of my script:
function InsertReplaceTableEntity($TableName, $...
0
votes
1
answer
100
views
Azure Table Storage Query with Timestamp Filter Returns Inconsistent Page Sizes
We have an Azure Table Storage setup where we store a large amount of data for different organizations. We use the Organization ID as the partition key.
For some operations, we need to fetch data from ...
-1
votes
1
answer
91
views
Azure table storage SAS generation using string to sign in c#
I need to generate SAS token for azure table storage using stringToSign method as mentioned in the documentstext. But i am not able to generate valid sas. when i use the generated sas its throwing the ...
0
votes
1
answer
72
views
Listing the Tables in the Storage Account using ADF Web Activity is failed with an authorization error
i have added the parameter source storage account sas token as shown below:
Then I added web activity to list the tables of the storage account where this account has only 500 tables but i'm getting ...
1
vote
1
answer
131
views
Error with PartitionKey in ASP.NET Core 8 Web API using Audit.NET and Azure Storage Table
I've been working on implementing an Audit Trail in an ASP.NET Core 8 Web API, utilizing the Audit.NET library, specifically with the AzureStorageTableDataProvider for storing audit events. The ...
0
votes
1
answer
101
views
Azure Table Storage works from local but not from Azure web App
My backend service is an ASP.NET Core 6 Web API. I am using table storage to maintain API logs, I have a logging middleware which typically stores the log in Azure table storage when the API request ...
1
vote
2
answers
456
views
Add-AzTableRow throws error MethodInvocationException : The specified resource does not exist
We are encountering an error when attempting to add a new row to an Azure Storage Table using the -UseConnectedAccount context rather than a key based authentication in PowerShell.
Error Message is:
...
1
vote
1
answer
70
views
How to connect AzureTableStorage using UserAssigned ManagedIdentity in the AuditTrail implementation using Audit.NET?
I have implemented Audit Trail in .NET 8 Web API application using great library which has a very good documentation also : https://github.com/thepirat000/Audit.NET/blob/master/src/Audit.WebApi/README....
0
votes
1
answer
139
views
Getting System.Text.Json exception when reading from Azure Storage Table as an ITableEntity in Azure queue-triggered functions
I am following this example by Microsoft to read a table entity from an azure storage account's table but I am getting the following error message:
Error:System.Text.Json.JsonException: The JSON ...
0
votes
1
answer
88
views
Logic Apps, transcoding in XSLT 3.0, replacing values stored in an Azure Storage Table
I have some values to transform on a logic app running some XSLT 3.0 code from ISO3 to ISO2.
Those data are stored in an Azure Table.
I know how to run the transformation within logic app, and I know ...
0
votes
1
answer
316
views
Authentication failed in postman for listing the tables in azure storage account
I'm trying to list the table names present in the azure storage account that is enabled with public access using the postman but i'm getting the authentication failed error:
Error:
<?xml version=&...
0
votes
1
answer
146
views
How to get full list of tables if count is big in the adf web activity?
We have 18,000 tables in the Table Storage Account.
I have created a web activity to list the tables in the storage account:
Web Activity - ListTables
URL: @concat('https://stccuatuks001.blob.core....
1
vote
1
answer
1k
views
How to use adf copy data pipeline for doing multiple tables at a time
From the solution of the following question: Copy data activity failing when entering the table name dynamically in sink dataset
how to modify the pipeline for copying multiple tables at a time with ...
0
votes
1
answer
469
views
Azure Data factory - ignore duplicates in destination?
I am retrieving data from a Sql database and want to insert into an Azure table storage.
However, I want to make sure I am not duplicate inserting data into the table storage.
How can I achieve this ...
0
votes
1
answer
60
views
WPF Application exits without saving data despite no exceptions thrown
I have a WPF application using MahApps.Metro with a title bar closure button to close the application. My goal is to store records in an Azure Storage Account when the application closes. I've ...
1
vote
1
answer
3k
views
Is there a way to view traffic logs for Azure Storage for connections that got blocked by Firewall settings from Networking pane?
Where can I find log within Azure Monitor/Log Analytics workspace that informs about some connection attempt (here from PowerBi service) that was dropped due to firewall settings? Can it be checked ...
0
votes
0
answers
88
views
Azure Table REST API / 403 (Server failed to authenticate the request. Works in Postman but not on static web page
I have an azure static web page setup and want to communicate with my Azure Table service through REST API, which I was told would be possible.
This is what my fetch code block looks like:
fetch('...
0
votes
1
answer
294
views
Copy data activity failing when entering the table name dynamically in sink dataset
Following this MS article, I have created the following steps:
Step 1: Added the New Pipeline with two parameters with names as sourceSAS and destinationSAS and given their SAS tokens as values
Step ...
0
votes
1
answer
255
views
can we keep/install two versions of azcopy in the windows system
Current Version of azcopy installed:
>azcopy --version
azcopy version 10.23.0
I'm creating the SAS for all the services provided in Storage account to copy between the storage accounts.
While ...
0
votes
1
answer
65
views
Azure Table Partition Key for task management
I am storing tasks in an Azure Table, I would always retrieve them by Id.
public sealed class ProjectTask
{
public required string Id { get; set; }
public string? ParentId { get; set; }
...
0
votes
1
answer
262
views
How to use Date as partition key in Azure table?
I am creating a table that is going to store a lot of recordas per day on batch processes. Those records will be used for queries for a given date, so I decided it would be good to use short dates (&...
1
vote
1
answer
2k
views
Azure Container App not authorized to access Storage Account Table
I am having a difficult time with the Networking between my Azure Container App (ACA) and Azure Storage Account Table.
Overview
I have a python (Flask) app API that is containerized with Docker. I am ...
0
votes
1
answer
726
views
Azure Table Storage submitTransaction: AuthorizationPermissionMismatch exception
I am trying to use the DefaultAzureCredentials to authenticate the TableServiceClient for inserting entities into Azure Table Storage.
This is the code in my Startup.cs:
DefaultAzureCredentialOptions ...
0
votes
1
answer
361
views
Azure data tables python SDK does not work on read. "NotImplemented"
I have a Table within Azure data storage that I am trying to read from. I am able to successfully write to this table but unable to read. I have followed the docs here:
https://learn.microsoft.com/en-...
0
votes
1
answer
561
views
Maximum number of items in a transaction using Azure.Data.Tables
We are migrating our app that uses Azure Table to the new Azure.Data.Tables package.
One of the migration tasks is to convert batch operations. What is the limit of items in one transaction is when ...
0
votes
1
answer
164
views
Azure Table Storage SAS token pagination
I am using Powershell to read data from an Azure Storage Table. I want to use the API directly without any modules.
I use a SAS token for authentication.
$SASToken = '?sv=2022-11-02&ss=bfqt&...