Performing simple Azure Table Storage REST API operations using curl command.
The blog provides guidance to perform simple Table Storage REST API operations such as Create table, Delete Table, Insert entity, Delete entity, Merge entity, Get Table properties, Get Table Storage Stats, Query Table, Query Entities and Update entities operations using curl command.
Let us look at some of the command syntax to perform REST API operations and we will be making use of SAS token as the authentication mechanism. We need to take care of the pointers below while performing the operations via curl command:
- Ensure the URL is formed correctly as per the operation you are trying to perform.
- The mandatory header needs to be passed along with correct values for it.
- Ensure you are appending/removing extra ‘?’ to the SAS token in the URLs accordingly.
- Http verb can be GET, PUT or DELETE as provided by the REST API specifications.
So let's began:
- Get Table Storage Properties:
This Rest API gets the properties of an Azure Table Storage account. Reference link for Rest API is:
Get Table Service Properties (REST API) - Azure Storage | Microsoft Learn
Syntax URL:
Output:
- Get Table Storage Stats:
This Rest API retrieves statistics that are related to replication for Azure Table Storage. This operation works only on the secondary location endpoint when we have RAGRS replication enabled for the storage account. Reference link: Get Table Service Stats (REST API) - Azure Storage | Microsoft Learn
Syntax URL:
Output:
- Query tables:
This Rest API returns a list of tables under the specified account. Reference link: Query Tables (REST API) - Azure Storage | Microsoft Learn
Syntax URL:
Output:
- Create table:
This Rest API creates a new table in a storage account. Reference link: Create Table (REST API) - Azure Storage | Microsoft Learn
Syntax URL:
Output:
- Delete table:
This Rest API deletes a table in a storage account. Reference link: Delete Table (REST API) - Azure Storage | Microsoft Learn
Syntax URL:
Output:
- Query Entities:
This Rest API queries entities in a table and includes the $filter and $select options. Reference link: Query Entities (REST API) - Azure Storage | Microsoft Learn
Syntax URL:
Output:
- Delete Entity Operation:
This Rest API deletes an existing entity in a table. Reference link: Delete Entity (REST API) - Azure Storage | Microsoft Learn
Syntax URL:
Output:
- Insert Operation:
This Rest API inserts a new entity into a table. Reference link: Insert Entity (REST API) - Azure Storage | Microsoft Learn
Syntax URL:
Output:
- Update operation:
This Rest API updates the existing entity in the Table Storage. Reference link: Update Entity (REST API) - Azure Storage | Microsoft Learn
Syntax URL:
Output
Merge operation:
This Rest API operation updates an existing entity by updating the entity's properties and does not replace the existing entity, Reference link: Merge Entity (REST API) - Azure Storage | Microsoft Learn
Syntax URL:
Output:
Hope this article helps you in performing the Table Storage operations by making use of curl command.
Happy Learning!
Published on:
Learn moreRelated posts
Unified Routing – Diagnostics in Azure
You may (or may not) be aware that the diagnostics option in Unified Routing has been deprecated. It is being replaced by diagnostics in Azure...
Service health and Message center: Azure Information Protection consolidation
This post is about the consolidation of Azure Information Protection communications under Microsoft Purview in Service Health and Message Cent...
Switch to Azure Business Continuity Center for your at scale BCDR management needs
In response to the evolving customer requirements and environments since COVID-19, including the shift towards hybrid work models and the incr...
Optimizing Azure Table Storage: Automated Data Cleanup using a PowerShell script with Azure Automate
Scenario This blog’s aim is to manage Table Storage data efficiently. Imagine you have a large Azure Table Storage that accumulates logs from ...
Microsoft Fabric: Resolving Capacity Admin Permission Issues in Automate Capacity Scaling with Azure LogicApps
A while back, I published a blogpost explaining how to use Azure LogicApps to automate scaling Microsoft Fabric F capacities under the PAYG (P...
The Azure Storage product group is heading to the SNIA Developer Conference 2024
The Azure Storage product group is heading to the SNIA Developer Conference (SDC) 2024 in Santa Clara, California, USA from September 16th thr...
ISSUE RESOLVED: Azure Lab Services - lab plan outage - September 12, 2024
Hello, Azure Lab Services is currently experiencing an outage affecting customers using Lab Plans for their service. Customers using Lab Accou...