Azure SQL Database Management - Get databases

Important: This connector and its actions have been removed from Nintex Workflow and can now be found in Nintex Gallery.

Use the Azure SQL Database Management - Get databases action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to retrieve a list of Azure SQL databases.

For more information about Azure Container Instance Management, go to Azure Container Instance Management.

Before you begin: 

Jump to:

Configure the Azure SQL Database Management - Get databases action

  1. Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.

  2. Select a Connection. If you do not have a connection, see Add a connection.
  1. Select Subscription credentials which uniquely identify a Microsoft Azure subscription.
  1. Select a Resource group name of the resource group that contains the resource.
  2. Select a Server name.
  3. Specify a Database name.

Azure SQL Database Management - Get databases action fields and settings

Section

Field

Description

Variable types

(Unlabeled)

Connection Credentials and other settings that enables workflows to communicate with external systems, services, or applications. It's required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.

The Azure SQL Database Management connection to use to retrieve the list of databases.

To refresh the available connections, click .

(n/a)
Subscription Subscription credentials which uniquely identify Microsoft Azure subscription. Select the subscription from the drop-down. Text, Decimal, Integer, Boolean, DateTime, Collection
  Resource group name The name of the resource group that contains the resource. You can obtain this value from the drop-down or get it from your Azure portal. Text, Decimal, Integer, Boolean, DateTime, Collection
  Server name The name of the server. Select the server from the drop-down. Text, Decimal, Integer, Boolean, DateTime, Collection
Output Databases

Stores the result of the action as an object with the following variables; See the Azure SQL REST API for more information:

  • Value: (Collection)

    • ID: (Text)

    • Kind: (Text)

    • Location: (Text)

    • Name: (Text)

    • Properties: (Object)

      • Catalog collation: (Text)

      • Collation: (Text)

      • Creation date: (DateTime)

      • Current backup storage redundancy: (Text)

      • Current service objective name: (Text)

      • Current SKU: (Object)

        • Capacity: (Integer)

        • Name: (Text)

        • Tier: (Text)

      • Database ID: (Text)

      • Default secondary location: (Text)

      • Is infrastructure encryption enabled: (Boolean)

      • Is ledger on: (Boolean)

      • Maximum database size in bytes: (Integer)

      • Read scale: (Text)

      • Requested backup storage redundancy: (Text)

      • Requested service objective name: (Text)

      • Status: (Text)

      • Zone redundant: (Boolean)

    • SKU: (Object)

      • Capacity: (Integer)

      • Name: (Text)

      • Tier: (Text)

    • Type: (Text)

 

 Object