category: IT Services
provider: Microsoft
commonfields:
  id: Azure Storage Table
  version: -1
configuration:
- display: Storage account name
  displaypassword: Account SAS Token
  name: credentials
  type: 9
  required: false
- additionalinfo: Relevant only if the integration is running on Azure VM. If selected, authenticates based on the value provided for the Azure Managed Identities Client ID field. If no value is provided for the Azure Managed Identities Client ID field, authenticates based on the System Assigned Managed Identity. For additional information, see the Help tab.
  display: Use Azure Managed Identities
  name: use_managed_identities
  type: 8
  required: false
- additionalinfo: The Managed Identities client ID for authentication - relevant only if the integration is running on Azure VM.
  displaypassword: Azure Managed Identities Client ID
  name: managed_identities_client_id
  hiddenusername: true
  type: 9
  required: false
- display: Use system proxy settings
  name: proxy
  type: 8
  required: false
- display: Trust any certificate (not secure)
  name: insecure
  type: 8
  required: false
description: Create and Manage Azure Storage Tables and Entities.
display: Azure Storage Table
name: Azure Storage Table
script:
  commands:
  - arguments:
    - description: 'The name of the new table to create. Rules for naming tables can be found here: https://docs.microsoft.com/en-us/rest/api/storageservices/understanding-the-table-service-data-model'
      name: table_name
      required: true
    description: Creates a new table in a storage account.
    name: azure-storage-table-create
    outputs:
    - contextPath: AzureStorageTable.Table.name
      description: Table name.
      type: String
  - arguments:
    - description: The name of the table to delete.
      name: table_name
      required: true
    description: Delete the specified table and any data it contains.
    execution: true
    name: azure-storage-table-delete
  - arguments:
    - defaultValue: '50'
      description: Number of Tables to retrieve. Default is 50.
      name: limit
    - description: "Filter Tables Query expression. \nInformation about Query expression structure can be found here: https://docs.microsoft.com/en-us/rest/api/storageservices/querying-tables-and-entities#constructing-filter-strings"
      name: filter
    - defaultValue: '1'
      description: Page Number.  Default is 1.
      name: page
    description: List tables under the specified account.
    name: azure-storage-table-query
    outputs:
    - contextPath: AzureStorageTable.Table.name
      description: Table name.
      type: String
  - arguments:
    - description: Table name.
      name: table_name
      required: true
    - description: Unique identifier for the partition within a given table.
      name: partition_key
      required: true
    - description: Unique identifier for an entity within a given partition.
      name: row_key
      required: true
    - description: 'Entity fields in JSON format: { "Key1": Value1, "Key2": Value2}.'
      name: entity_fields
      required: true
    description: Insert a new entity into a table.
    name: azure-storage-table-entity-insert
    outputs:
    - contextPath: AzureStorageTable.Table.Entity.PartitionKey
      description: Entity partition key.
      type: String
    - contextPath: AzureStorageTable.Table.Entity.RowKey
      description: Entity row key.
      type: String
    - contextPath: AzureStorageTable.Table.Entity.Timestamp
      description: Entity last update UTC time.
      type: Date
    - contextPath: AzureStorageTable.Table.name
      description: Entity table name.
      type: String
  - arguments:
    - description: Entity table name.
      name: table_name
      required: true
    - description: Unique identifier for the partition within a given table.
      name: partition_key
      required: true
    - description: Unique identifier for an entity within a given partition.
      name: row_key
      required: true
    - description: 'Entity fields in JSON format: { "Key1": Value1, "Key2": Value2}.'
      name: entity_fields
      required: true
    description: Update an existing entity in a table. The Update Entity command does not replace the existing entity.
    name: azure-storage-table-entity-update
  - arguments:
    - description: Table name.
      name: table_name
      required: true
    - description: Unique identifier for the partition within a given table.
      name: partition_key
      required: true
    - description: Unique identifier for an entity within a given partition.
      name: row_key
      required: true
    - description: 'Entity records in JSON format: { "Key1": Value1, "Key2": Value2}.'
      name: entity_fields
      required: true
    description: Replace an existing entity in a table. The Replace Entity command replace the entire entity and can be used to remove properties.
    execution: true
    name: azure-storage-table-entity-replace
  - arguments:
    - description: Entity table name.
      name: table_name
      required: true
    - description: Unique identifier for the partition within a given table. If specified, 'row_key' argument must also be specified.
      name: partition_key
    - description: Unique identifier for an entity within a given partition. If specified, 'partition_key' argument must also be specified.
      name: row_key
    - description: |-
        Filter Entities query expression.
        Information about Query expression structure can be found here: https://docs.microsoft.com/en-us/rest/api/storageservices/querying-tables-and-entities#constructing-filter-strings
      name: filter
    - description: Comma-separated Entity properties to return. If not specified - all fields will be retrieved.
      isArray: true
      name: select
    - defaultValue: '50'
      description: |-
        Number of entities to retrieve. Default is 50.
        This argument is will be ignored when 'partition_key' or 'row_key' arguments are provided.
      name: limit
    - defaultValue: '1'
      description: |-
        Page number. Default is 1.
        This argument is will be ignored when 'partition_key' or 'row_key' arguments are provided.
      name: page
    description: Query Entities in a table.
    name: azure-storage-table-entity-query
    outputs:
    - contextPath: AzureStorageTable.Table.name
      description: Entity table Name.
      type: String
  - arguments:
    - description: Entity table name.
      name: table_name
      required: true
    - description: Unique identifier for the partition within a given table.
      name: partition_key
      required: true
    - description: Unique identifier for an entity within a given partition.
      name: row_key
      required: true
    description: Delete an existing entity in a table.
    execution: true
    name: azure-storage-table-entity-delete
  dockerimage: demisto/python3:3.12.13.10116658
  runonce: false
  script: '-'
  subtype: python3
  type: python
fromversion: 6.0.0
tests:
- No tests (auto formatted)