Connectors Reference
Azure Data Explorer a.k.a Kusto is a log analytics cloud platform optimized for ad-hoc big data queries. Read more about it here: http://aka.ms/kdocs
|
Status: Preview |
Tier: Premium |
Version: 1.0.0 |
|
Name |
Summary |
|
Run query and list results |
|
|
listKustoShowCommandResultsPost (ControlCommandAndListSchema body) |
Run control show command and list results |
|
Query schema |
|
|
runKustoQueryAndVisualizeResultsPost (QueryAndVisualizeSchema body) |
Run query and visualize results |
|
runKustoCommandAndVisualizeResultsPost (CommandAndVisualizeSchema body) |
Run control command and visualize results |
|
retrieveKustoAsyncResult (string operationId, [Optional]string Timestamp) |
Retrieve Kusto async result |
|
Name |
Summary |
|
Name |
Summary |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Summary: Run query and list results
Description: Runs the query and returns the result as a set of rows which can be iterated over in the following connectors.
Syntax:
AzureDataExplorer.listKustoResultsPost (QueryAndListSchema body)
Parameters:
|
Name |
Type |
Summary |
Required |
Related Action |
|
body |
|
|
True |
Returns:
Type:Table
Summary: Run control show command and list results
Description: Runs the show control command and returns the result as a set of rows which can be iterated over in the following connectors.
Syntax:
AzureDataExplorer.listKustoShowCommandResultsPost (ControlCommandAndListSchema body)
Parameters:
|
Name |
Type |
Summary |
Required |
Related Action |
|
body |
|
|
True |
Returns:
Type:Table
Summary: Query schema
Description: Gets the schema for a query
Syntax:
AzureDataExplorer.listKustoResultsSchemaPost (QueryAndListSchema body)
Parameters:
|
Name |
Type |
Summary |
Required |
Related Action |
|
body |
|
|
True |
Returns:
Type:Object
Summary: Run query and visualize results
Description: Returns the Kusto query result as a chart of your choice.
Syntax:
AzureDataExplorer.runKustoQueryAndVisualizeResultsPost (QueryAndVisualizeSchema body)
Parameters:
|
Name |
Type |
Summary |
Required |
Related Action |
|
body |
|
|
True |
Returns:
Type:VisualizeResults
Summary: Run control command and visualize results
Description: Returns the Kusto control command result as a chart of your choice.
Syntax:
AzureDataExplorer.runKustoCommandAndVisualizeResultsPost (CommandAndVisualizeSchema body)
Parameters:
|
Name |
Type |
Summary |
Required |
Related Action |
|
body |
|
|
True |
Returns:
Type:VisualizeResults
Summary: Retrieve Kusto async result
Description: Retrieve status and result of Kusto async operation
Syntax:
AzureDataExplorer.retrieveKustoAsyncResult (string operationId, [Optional]string Timestamp)
Parameters:
|
Name |
Type |
Summary |
Required |
Related Action |
|
operationId |
string (Operation ID) |
Unique identifier of the async operation |
True |
|
|
Timestamp |
string (Query beginning timestamp) |
The timestamp in which the query begin |
False |
Returns:
Type:Object
Summary:
Description:
Properties:
|
Name |
Type |
Summary |
|
cluster |
string Cluster URL |
Specify the cluster url e.g. https://<yourCluster>.<yourLocation>.kusto.windows.net |
|
db |
string Database Name |
Specify the database name |
|
csl |
string Control Command |
Specify the control command you would like to run |
|
chartType |
string Chart Type |
Specify the resulting chart type Values: [Html Table, Pie Chart, Time Chart, Bar Chart] |
Summary:
Description:
Properties:
|
Name |
Type |
Summary |
|
cluster |
string Cluster URL |
Specify the cluster url e.g. https://<yourCluster>.<yourLocation>.kusto.windows.net |
|
db |
string Database Name |
Specify the database name |
|
csl |
string Control Command |
Specify the show control command you would like to run |
Summary:
Description:
Properties:
|
Name |
Type |
Summary |
Summary:
Description:
Properties:
|
Name |
Type |
Summary |
|
cluster |
string Cluster URL |
Specify the cluster url e.g. https://<yourCluster>.<yourLocation>.kusto.windows.net |
|
db |
string Database Name |
Specify the database name |
|
csl |
string Query |
Specify the query you would like to run |
Summary:
Description:
Properties:
|
Name |
Type |
Summary |
|
cluster |
string Cluster URL |
Specify the cluster url e.g. https://<yourCluster>.<yourLocation>.kusto.windows.net |
|
db |
string Database Name |
Specify the database name |
|
csl |
string Query |
Specify the query you would like to run |
|
chartType |
string Chart Type |
Specify the resulting chart type Values: [Html Table, Pie Chart, Time Chart, Bar Chart] |
Summary:
Description:
Properties:
|
Name |
Type |
Summary |
Summary:
Description:
Properties:
|
Name |
Type |
Summary |
|
value |
array of (Row)
|
|
Summary:
Description:
Properties:
|
Name |
Type |
Summary |
|
body |
string(byte) Body |
The body of the result in base64 encoding. |
|
bodyHtml |
string(HTML) BodyHtml |
The body of the result in html encoding. |
|
attachmentContent |
string(byte) Attachment Content |
The content of the attachment. |
|
attachmentName |
string Attachment Name |
The name of the attachment file. |
|
kustoDeepLink |
string Links to Kusto Explorer |
Links to run the query in Kusto tools, for instance in KustoExplorer. |