Eql

POST /ver2/EqlService.svc/query

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"
]

Request

Headers

EnvApi-Systemidstring

Specify specific system to run instead of Home

EnvApi-Packageidstring

(optional) Clients application/package ID

EnvApi-Udf-DateTime-Iso-In-CustomFieldsstring

Udfs of DateTime should use Iso

EnvApi-Udf-DateTime-ReadInUserTzstring

(obsolete) Udfs of DateTime type whould be in ReadInUserTz

EnvApi-Udf-Value-Invariantstring

(optional) Udfs - Force Non-Localized (invariant) values

EnvApi-Localization-Allstring

(optional) Extend objects with User-given Localizations

x-client-request-idstring

(optional) Client ID for double submit prevention

Request body

eqlstring
namestring
pageinteger
pageSizeinteger
pageByColumnstring
formatstring
filenamestring
cachecontrolstring
excelTemplateIdOrPathstring
excelSheetNamesstring[]

Response

not available

string stream required

Changes

No recorded changes to this operation across all 1 revision of this API.