---
title: stack es sql get-async cli command
description: Get async SQL search results. Behaviour flags: --dry-run — validate all inputs and exit without performing any action 
url: https://www.elastic.co/elastic/docs-builder/docs/4118/reference/elastic-cli/cli/stack/es/sql/get-async
applies_to:
  - Elastic Cloud Serverless: Preview
  - Elastic Stack: Preview
---

# stack es sql get-async cli command
<cli-modifiers>
</cli-modifiers>

```bash
elastic stack es sql get-async --id <id> [options]
```

Get async SQL search results.
**Behaviour flags:**
`--dry-run` — validate all inputs and exit without performing any action

## Options

<definitions>
  <definition term="--id string required">
    The identifier for the search.
  </definition>
  <definition term="--delimiter string">
    The separator for CSV results.
    The API supports this parameter only for CSV responses.
  </definition>
  <definition term="--format string">
    The 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.
  </definition>
  <definition term="--keep-alive string">
    The retention period for the search and its results.
    It defaults to the `keep_alive` period for the original SQL search.
  </definition>
  <definition term="--wait-for-completion-timeout string">
    The period to wait for complete results.
    It defaults to no timeout, meaning the request waits for complete search results.
  </definition>
  <definition term="--error-trace">
    When set to `true` Elasticsearch will include the full stack trace of errors
    when they occur.
  </definition>
  <definition term="--filter-path string">
    Comma-separated list of filters in dot notation which reduce the response
    returned by Elasticsearch.
    **Repeatable:** pass `--filter-path` multiple times to supply more than one value
  </definition>
  <definition term="--human">
    When set to `true` will return statistics in a format suitable for humans.
    For example `"exists_time": "1h"` for humans and
    `"exists_time_in_millis": 3600000` for computers. When disabled the human
    readable values will be omitted. This makes sense for responses being consumed
    only by machines.
  </definition>
  <definition term="--pretty">
    If set to `true` the returned JSON will be "pretty-formatted". Only use
    this option for debugging only.
  </definition>
  <definition term="--input-file string">
    path to a JSON file to use as command input
  </definition>
  <definition term="--dry-run">
    validate all inputs and exit without performing any action (preview changes without applying them)
  </definition>
</definitions>


## Global Options

<definitions>
  <definition term="--json">
    output as JSON
  </definition>
</definitions>