This documentation contains work-in-progress information for future Elastic Stack and Cloud releases. Use the version selector to view supported release docs. It also contains some Elastic Cloud serverless information. Check out our serverless docs for more details.
Get async SQL search API
editGet async SQL search API
editReturns results for an async SQL search or a stored synchronous SQL search.
resp = client.sql.get_async( id="FmdMX2pIang3UWhLRU5QS0lqdlppYncaMUpYQ05oSkpTc3kwZ21EdC1tbFJXQToxOTI=", format="json", ) print(resp)
response = client.sql.get_async( id: 'FmdMX2pIang3UWhLRU5QS0lqdlppYncaMUpYQ05oSkpTc3kwZ21EdC1tbFJXQToxOTI=', format: 'json' ) puts response
const response = await client.sql.getAsync({ id: "FmdMX2pIang3UWhLRU5QS0lqdlppYncaMUpYQ05oSkpTc3kwZ21EdC1tbFJXQToxOTI=", format: "json", }); console.log(response);
GET _sql/async/FmdMX2pIang3UWhLRU5QS0lqdlppYncaMUpYQ05oSkpTc3kwZ21EdC1tbFJXQToxOTI=?format=json
Request
editGET _sql/async/<search_id>
Prerequisites
edit- If the Elasticsearch security features are enabled, only the user who first submitted the SQL search can retrieve the search using this API.
Limitations
editSee SQL Limitations.
Path parameters
edit-
<search_id>
- (Required, string) Identifier for the search.
Query parameters
edit-
delimiter
-
(Optional, string) Separator for CSV results. Defaults to
,
. The API only supports this parameter for CSV responses. -
format
-
(Required, string) Format for the response. You must specify a format using this
parameter or the
Accept
HTTP header. If you specify both, the API uses this parameter. For valid values, see Response Data Formats. -
keep_alive
-
(Optional, time value) Retention period for the search and its
results. Defaults to the
keep_alive
period for the original SQL search. -
wait_for_completion_timeout
- (Optional, time value) Period to wait for complete results. Defaults to no timeout, meaning the request waits for complete search results.
Response body
editThe get async SQL search API returns the same response body as the SQL search API.