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
- Base URLhttps://api.enviance.com (the document declares no server; this is the origin it was published from)
- Authnone declared
- TypeScriptA function with typed inputs. Its response is checked against the schema.
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
Response
not available
string stream required
Changes
No recorded changes to this operation across all 1 revision of this API.