Eql

POST /ver2/EqlService.svc/executeAsync

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

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 guid required

Changes

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