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

# POST /ver2/EqlService.svc/query

`POST /ver2/EqlService.svc/query`

## 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/query`
- Auth: none declared
- TypeScript: <https://skmtc.dev/enviance/apis/restapi/docs/ver2/EqlService.svc/query/post.ts> (a function with typed inputs; its response is checked against the schema)

envianceSdk.eql.execute
```
[
    "select wi.name, wi.id from WorkflowType wi  where wi.name like '%lgm%'",
    1,
    100,
    "onsuccess",
    "onerror"
]
```
envianceSdk.eql.executeExt
```
[
  {
    "eql": "select TOP 1 wi.name, wi.id from WorkflowType wi",
    "format": "xls",
    "pageByColumn": "1,2"
  },
  "onsuccess",
  "onerror"
]
```
envianceSdk.eql.executeExtAsync
```
[
  {
    "eql": "select TOP 1 wi.name, wi.id from WorkflowType wi",
    "format": "xlsx",
    "excelTemplateIdOrPath": "/shvets/Colusa Template.xlsm",
    "excelSheetNames": [
      "Raw Data"
    ],
    "excelHeaderCells": [
      {
        "row": 1,
        "column": 1,
        "value": "test",
        "type": "s",
        "style": {
          "font": {
            "bold": true,
            "sz": 11
          }
        }
      }
    ]
  },
  "onsuccess",
  "onerror"
]
```
envianceSdk.packages.eql.ExecuteParametersInfo
```
[
  "path",
  "json",
  1,
  10
]
```
envianceSdk.packages.eql.executeEqlItem
```
[
  {
    "path": "test.eql",
    "format": "json",
    "page": 2,
    "pageSize": 20
  },
  {
    "TimeZone": 5,
    "Name": "X%"
  },
  "onsuccess",
  "onerror"
]
```
envianceSdk.packages.eql.executeEqlItemAsync
```
[
  {
    "path": "test.eql",
    "format": "xls",
    "page": 2,
    "pageSize": 20,
    "filename": "my.xls",
    "cachecontrol": null,
    "excelTemplateIdOrPath": "/shvets/Colusa Template.xlsm",
    "excelSheetNames": [
      "Raw Data"
    ]
  },
  {
    "TimeZone": 5,
    "Name": "X%"
  },
  "onsuccess",
  "onerror"
]
```
envianceSdk.packages.eql.executeEqlItemBinary
```
[
  {
    "path": "test.eql",
    "format": "json",
    "page": 2,
    "pageSize": 20,
    "filename": "my.json",
    "cachecontrol": null
  },
  {
    "TimeZone": 5,
    "Name": "X%"
  },
  "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, stream

---

[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)