http_request plugin

Applies to: ✅ Azure Data Explorer

The http_request plugin sends an HTTP GET request and converts the response into a table.

Prerequisites

• Run .enable plugin http_request to enable the plugin
• Set the URI to access as an allowed destination for webapi in the Callout policy

Syntax

evaluate http_request ( Uri [, RequestHeaders [, Options]] )

Learn more about syntax conventions.

Parameters

Authentication and authorization

To authenticate, use the HTTP standard Authorization header or any custom header supported by the web service.

Returns

The plugin returns a table that has a single record with the following dynamic columns:

• ResponseHeaders: A property bag with the response header.
• ResponseBody: The response body parsed as a value of type dynamic.

If the HTTP response indicates (via the Content-Type response header) that the media type is application/json, the response body is automatically parsed as-if it's a JSON object. Otherwise, it's returned as-is.

Headers

The RequestHeaders argument can be used to add custom headers to the outgoing HTTP request. In addition to the standard HTTP request headers and the user-provided custom headers, the plugin also adds the following custom headers:

Example

The following example retrieves Azure retails prices for Azure Purview in west Europe:

let Uri = "https://prices.azure.com/api/retail/prices?$filter=serviceName eq 'Azure Purview' and location eq 'EU West'";
evaluate http_request(Uri)
| project ResponseBody.Items
| mv-expand ResponseBody_Items
| evaluate bag_unpack(ResponseBody_Items)

Output