SqlClient.GetItemsAsync Method

Definition

Namespace:

Azure.Connectors.Sdk.Sql

Assembly:

Azure.Connectors.Sdk.dll

Package:

Azure.Connectors.Sdk v0.13.0-preview.1

Get rows (V2)

public virtual System.Threading.Tasks.Task<Azure.Connectors.Sdk.Sql.Models.GetItemsResponse> GetItemsAsync(string serverName, string databaseName, string tableName, string aggregationTransformation = default, string filterQuery = default, string orderBy = default, int? skipCount = default, int? topCount = default, string selectQuery = default, bool? count = default, bool? extractMIPLabels = default, string purviewAcccountName = default, System.Threading.CancellationToken cancellationToken = default);

abstract member GetItemsAsync : string * string * string * string * string * string * Nullable<int> * Nullable<int> * string * Nullable<bool> * Nullable<bool> * string * System.Threading.CancellationToken -> System.Threading.Tasks.Task<Azure.Connectors.Sdk.Sql.Models.GetItemsResponse>
override this.GetItemsAsync : string * string * string * string * string * string * Nullable<int> * Nullable<int> * string * Nullable<bool> * Nullable<bool> * string * System.Threading.CancellationToken -> System.Threading.Tasks.Task<Azure.Connectors.Sdk.Sql.Models.GetItemsResponse>

Public Overridable Function GetItemsAsync (serverName As String, databaseName As String, tableName As String, Optional aggregationTransformation As String = Nothing, Optional filterQuery As String = Nothing, Optional orderBy As String = Nothing, Optional skipCount As Nullable(Of Integer) = Nothing, Optional topCount As Nullable(Of Integer) = Nothing, Optional selectQuery As String = Nothing, Optional count As Nullable(Of Boolean) = Nothing, Optional extractMIPLabels As Nullable(Of Boolean) = Nothing, Optional purviewAcccountName As String = Nothing, Optional cancellationToken As CancellationToken = Nothing) As Task(Of GetItemsResponse)

Parameters

serverName

String

Server name

databaseName

String

Database name

tableName

String

Table name

aggregationTransformation

String

Aggregation transformation

filterQuery

String

Filter Query

orderBy

String

Order By

skipCount

Nullable<Int32>

Skip Count

topCount

Nullable<Int32>

Top Count

selectQuery

String

Select Query

count

Nullable<Boolean>

Count

extractMIPLabels

Nullable<Boolean>

Extract MIP Labels

purviewAcccountName

String

Purview Acccount Name

cancellationToken

CancellationToken

Cancellation token.

Returns

Task<GetItemsResponse>

The Get rows (V2) response.

Remarks

This operation gets rows from a table.