Get entities
Gets a list of entities from a query against a SQL Server database.
An entity is a .NET object with one or more properties, for example
public record Customer(string VATNumber, string Name, string Address);
This actions returns a list of entities with properties as specified by the Entity properties configuration, for example
List<Customer> customers;
Returns
A List of custom .NET objects with properties specified by the Entity properties configuration.
Properties
| Name | Type | Description |
|---|---|---|
| Title | Optional | The title or name of the command. |
| Connection | Required | The SQL Server Connection. |
| Dynamic connection | Optional | Use this option of you needs to use a connection from the Create Connection action. |
| SQL expression and parameters | Required | The command to execute along with any parameters. |
| Row variable name | Required | Name of Row variable. |
| Row data type | Optional | Name of the created entity type. |
| Entity name | Optional | Name of Row entity. |
| Entity properties | Required | Name and data type of the propertis in each entity |
| Result variable name | Required | Name of resulting list of entities variable |
| Result data type | Optional | Name of the created entity list type. |
| Command timeout (sec) | Optional | The time limit for command execution before it times out. Default is 120 seconds. |
| Description | Optional | Additional notes or comments about the action or configuration. |
SQL Server: Videos / Getting started
This section contains videos to help you get started quickly working with Azure SQL / SQL Server using Flow.
Dump CSV file from Azure Blob container to Azure SQL table
This video demonstrates how to import all records from a CSV file into an Azure SQL table.
In the demo, no data import options (such as data type conversion, number or date formatting) are specified, meaning the data is imported as raw text.