---
title: "POST /ver2/EqlService.svc/executeAsync"
method: POST
path: "/ver2/EqlService.svc/executeAsync"
tags: ["Eql"]
---

# POST /ver2/EqlService.svc/executeAsync

`POST /ver2/EqlService.svc/executeAsync`

## Request

- Base URL: `https://api.enviance.com` (the document declares no server; this is the origin it was published from)
- URL: `https://api.enviance.com/ver2/EqlService.svc/executeAsync`
- Auth: none declared
- TypeScript: <https://skmtc.dev/enviance/apis/restapi/docs/ver2/EqlService.svc/executeAsync/post.ts> (a function with typed inputs; its response is checked against the schema)

envianceSdk.eql.executeExtAsync
```
[
    {
        "eql": "select TOP 1 wi.name, wi.id from WorkflowType wi",
        "excelHeaderCells": [
            {
                "column": 1,
                "row": 1,
                "style": {
                    "font": {
                        "bold": true,
                        "sz": 11
                    }
                },
                "type": "s",
                "value": "test"
            }
        ],
        "excelSheetNames": [
            "Raw Data"
        ],
        "excelTemplateIdOrPath": "/shvets/Colusa Template.xlsm",
        "format": "xlsx"
    },
    "onsuccess",
    "onerror"
]
```

## Headers

- `EnvApi-Systemid` string
- `EnvApi-Packageid` string
- `EnvApi-Udf-DateTime-Iso-In-CustomFields` string
- `EnvApi-Udf-DateTime-ReadInUserTz` string
- `EnvApi-Udf-Value-Invariant` string
- `EnvApi-Localization-All` string
- `x-client-request-id` string

## Request body

- EnvianceRestServicesVer2EqlDtoEqlExecuteInformation
  - `eql` string
  - `name` string
  - `page` integer
  - `pageSize` integer
  - `pageByColumn` string
  - `format` string
  - `filename` string
  - `cachecontrol` string
  - `excelTemplateIdOrPath` string
  - `excelSheetNames` string[]
  - `excelHeaderCells` EnvianceRestServicesVer2EqlDtoEqlReportCell[]
    - `row` integer
    - `column` integer
    - `value` string
    - `type` string
    - `style` EnvianceRestServicesVer2EqlDtoEqlReportCellStyle
      - `font` EnvianceRestServicesVer2EqlDtoEqlReportCellStyleFont
        - `bold` boolean
        - `sz` integer
      - `numFmt` string
      - `alignment` EnvianceRestServicesVer2EqlDtoEqlReportCellStyleAlignment
        - `horizontal` string
  - `additionalSheets` EnvianceRestServicesVer2EqlDtoEqlReportSheet[]
    - `name` string
    - `cells` EnvianceRestServicesVer2EqlDtoEqlReportCell[]
      - `row` integer
      - `column` integer
      - `value` string
      - `type` string
      - `style` EnvianceRestServicesVer2EqlDtoEqlReportCellStyle
        - `font` EnvianceRestServicesVer2EqlDtoEqlReportCellStyleFont
          - `bold` boolean
          - `sz` integer
        - `numFmt` string
        - `alignment` EnvianceRestServicesVer2EqlDtoEqlReportCellStyleAlignment
          - `horizontal` string

## Response `default`

not available

- string, guid

---

[API](https://skmtc.dev/enviance/apis/restapi.md) - [All operations](https://skmtc.dev/enviance/apis/restapi/llms.txt) - [OpenAPI document](https://skmtc.dev/enviance/apis/restapi/revisions/45b2200a8cf2?raw)