Qorus Integration Engine® Enterprise Edition 6.0.27_prod
|
Library object hashes have the following keys:
functions:
a list of function objects (can be empty)classes:
a list of class objects (can be empty)constants:
a list of constant objects (can be empty)Library object hash values in the lists assigned to the keys listed above have the following keys:
name:
the name of the objectversion:
the version of the objectid:
the id of the object (corresponding to a function_instanceid
, classid
, or constantid
)lib : hash: (3 members) functions : <EMPTY LIST> classes : <EMPTY LIST> constants : list: (1 element) [0]=hash: (3 members) name : "Errors" version : "1.0" id : 12
Mapper hashes have the following keys:
mapperid:
the ID of the mappername:
the name of the mapperversion:
the version of the mappertype:
the type of the mappermappers : list: (1 element) [0]=hash: (4 members) mapperid : 119 name : "it-32-inv_stock_adj-brep_trans-rrc-dhl-in" version : "1.0" type : "EbsSingleTableInboundMapper"
Value map hashes have the following keys:
id:
the ID of the value mapname:
the name of the value mapthrows_exception:
a boolean value indicating how requests for unknown values should be processedvaluetype:
the data type of the value mapmapsize:
the number of elements in the mapvmaps : list: (1 element) [0]=hash: (5 members) id : 3 name : "it-34-inv_direct_transfer-inventory-tat-smart" throws_exception : False valuetype : "string" mapsize : 2
Options hashes have the following keys:
name:
the name of the optiondesc:
a description for the optionvalue:
the value of the optionoptions : list: (1 element) [0]=hash: (3 members) name : "verbose" desc : "sets verbose level" value : 11
Alert hashes have the following keys:
type:
the type of object directly affected by the alertid:
the ID of the object directly affected by the alertalerttype:
either "ONGOING"
or "TRANSIENT"
when:
the timestamp when the alert was first raisedlocal:
a boolean flag; True if the alert was raised by the local instancealert:
the name or string code of the alertalertid:
a unique identifier for the alert (unique within the instance that raised the alert)reason:
a string giving the reason the alert was raisedwho:
a string describing the user or entity that raised the alertsource:
a string describing the source of the alertobject:
a string describing the object the alert directly affectsinstance:
the instance key of the Qorus instance where the alert was raisedname:
the name of the object directly affected by the alertauditid:
NOTHING if alert auditing is not enabled, otherwise an integer giving the auditid of the alert eventalerts : list: (1 element) [0]=hash: (14 members) type : "GROUP" id : 728 alerttype : "ONGOING" when : 2016-05-22 13:57:03.196796 Sun +02:00 (CEST) local : True alert : "INTERFACE-GROUP-DISABLED" alertid : 3 reason : "\"enabled\" flag for interface group \"SALESFORCE-EXAMPLE-1\" set to false in the DB at system startup" who : "Qorus" source : "system" object : "GROUP SALESFORCE-EXAMPLE-1 (728)" instance : "quark-1" name : "SALESFORCE-EXAMPLE-1" auditid : 4797709
Connection dependency hashes have the following keys:
type:
the type of connection dependency:"DATASOURCE"
: Datasource Connections"QORUS"
: Qorus to Qorus Connections"USER"
: User Connectionsname:
the name of the connectionup:
a boolean flag describing the currently-monitored health of the connectionconnections : list: (1 element) [0]=hash: (3 members) type : "DATASOURCE" name : "staging-ora" up : True
Interface group hashes have the following keys:
name:
the name of the groupenabled:
the status of the group as a boolsize:
the total number of members of the groupgroups : list: (2 elements) [0]=hash: (3 members) name : "IT" enabled : True size : 432 [1]=hash: (3 members) name : "IT-84-EXPORT_ITEM_CROSS_REFERENCE-OUT" enabled : True size : 1
Execution instance hashes have the following keys:
mode:
the workflow execution instance execution modestatus:
always "n/a"
; removed in Qorus 4.0/REST API v3iterations:
always 0
; removed in Qorus 4.0/REST API v3totalSegments:
number of segments in the workflowstarttime:
the date/time the execution instance was startedlogfile:
the log file name (full path)sync:
a boolean flag if the execution instance is synchronous or notexecutionID:
the workflow execution instance IDerrors:
always 0
; removed in Qorus 4.0/REST API v3warnings:
always 0
; removed in Qorus 4.0/REST API v3name : "IT-32-INV_STOCK_ADJ-ROAMERS-SG-IN" version : "1.0" mode : "NORMAL" status : "n/a" iterations : 0 totalSegments : 1 starttime : 2016-05-22 13:58:45.335128 Sun +02:00 (CEST) logfile : "/Users/david/src/Qorus/test/log/OMQ-quark-1-IT-32-INV_STOCK_ADJ-ROAMERS-SG-IN.log" options : <EMPTY HASH> sync : False executionID : 209 workflowid : 607 errors : 0 warnings : 0
Execution instance hashes in the REST v3 API are the same as in the v1 and v2 APIs except that the V3 hash adds the "remote"
and "process"
keys; these hashes have the following keys:
mode:
the workflow execution instance execution modestatus:
the current statustotalSegments:
number of segments in the workflowstarttime:
the date/time the execution instance was startedlogfile:
the log file name (full path)sync:
a boolean flag if the execution instance is synchronous or notexecutionID:
the workflow execution instance IDremote:
if True, the workflow execution instance is running in a remote qwf process, otherwise it is running internally in the qorus-core processprocess:
present when remote
is True; this is a REST Process Execution Info Hashname : "IT-32-INV_STOCK_ADJ-ROAMERS-SG-IN" version : "1.0" mode : "NORMAL" totalSegments : 1 starttime : 2016-05-22 13:58:45.335128 Sun +02:00 (CEST) logfile : "/Users/david/src/Qorus/test/log/OMQ-quark-1-IT-32-INV_STOCK_ADJ-ROAMERS-SG-IN.log" options : <EMPTY HASH> sync : False executionID : 209 workflowid : 607
Audit info hashes have the following keys:
audit_event_code:
the audit event code (see Audit Event Codes for possible values)reason:
the reason for the event (ex: if due to an API call, then the API name, ex "REST PUT api/jobs/myjob?action=run"
, if due to normal system processing, then the string "internal call"
)who:
the user who initiated the action that led to the event, or "Qorus"
if due to normal system processing or no username is availablesource:
the source of the call that led to the event (ex: "source: ipv6[::1]:50653 listener: ipv6[::]:8001"
) or "system"
if due to normal system processinginfo1:
first informational string for the eventinfo2:
second informational string for the eventcreated:
the date/time the event was createdevent:
the event string corresponding to the audit_event_code
audit_event_code : 6 reason : "internal call" who : "Qorus" source : "system" info1 : "I" info2 : "C" created : 2014-06-18 12:49:58.329436 Wed +02:00 (CEST) event : "WORKFLOW-STATUS-CHANGE"
Order note hashes have the following keys:
saved:
a boolean indicating if the note has already been flushed to the DB or notusername:
the user who created the notenote:
the note itselfcreated:
the date/time the note was createdmodified:
the date/time the note was modifiedWorkflow description hashes have the following keys:
workflowid:
the workflow IDname:
the workflow nameversion:
the workflow versiondescription:
the workflow descriptionauthor:
the workflow authoronetimeinit_func_instanceid:
the onetimeinit function ID for the workflow (if defined)attach_func_instanceid:
the attach function ID for the workflow (if defined)detach_func_instanceid:
the detach function ID for the workflow (if defined)errorfunction_instanceid:
the error function ID for the workflow (if defined)errhandler_func_instanceid:
the error handler function ID for the workflow (if defined)created:
the workflow creation datemodified:
the workflow last modified dateautostart:
the workflow autostart valuemanual_autostart:
a boolean flag set if the autostart
value has been changed manually, in which case the manual setting takes precendence over any new definitions loaded with oloadenabled:
a boolean flag indicating if the workflow is enabled or not; disabled workflows cannot be starteddeprecated:
a boolean flag indicating if the workflow is deprecated or not; deprecated workflows are not displayed by default in the UIkeylist:
a list of workflow order keysstepmap:
a hash where keys are step IDs and values are step namessteps:
a hash of step dependencies, where keys are step IDs and values are lists of step IDs that must preceed the step ID given as a keysegment:
a list of segment description hashes, where each segment hash has the following keys:steplist:
a list of step IDs in the segmentsteps:
a hash of step dependencies, where keys are step IDs and values are lists of step IDs that must preceed the step ID given as a keystart
]: the starting step ID for segments other than the initial segmentsubworkflow
]: set to True if the segment is a subworkflow segmentlinksegment
]: the previous segmentlinkstepid
]: the step linking the segment to the previous segmentlib:
a REST Library Object Hashmappers:
a list of mappers associated with the workflow (can be NOTHING); each mapper element is a REST Mapper Hashvmaps:
a list of value maps associated with the workflow (can be NOTHING); each value map element is a REST Value Map Hashstepinfo:
a list of hashes giving information about workflow steps; each hash is a REST Step Hash with the following additional keys:sfname:
the name of the primary step functionvfname
]: the name of the validation function (if any)afname
]: the name of the array function (if any)efname
]: the name of the back end function (if any)wffuncs:
a list of workflow-level functions (may be empty); each list element is a hash with the following keys:type:
the type of workflow function; one of:"onetimeinit"
: workflow execution instance initialization function"errorfunction"
: workflow error function"attachfunction"
: workflow attach function"detachfunction"
: workflow detach function"errorhandlerfunction"
: workflow error handler functionname:
the name of the functionversion:
the version of the functionfunction_instanceid:
the function IDfunction_type:
the type of the functiondescription:
a decsription for the functionauthor:
the author of the functioncreated:
the creation date in the databasemodified:
the last modified date in the databasesource:
the name of the source file for the function (complete path)line:
the line number offset for the function object definition in the fileoptions:
a list of option hashesexec:
a list of execution instance hashes describing any workflow execution instances running for this workflowexec_count:
the number of elements in the exec
listalerts:
a list of alerts raised against the workflow; each list element is a REST Alert Hash (may be empty)connections:
a list of connection objects that this workflow depends on; each list element is a REST Connection Dependency Hash (may be empty)groups:
a list of interface groups that the workflow belongs to; each list element is a REST Interface Group Hash (may be empty)Workflow description hashes in the REST v3 API are the same as in the v1 and v2 APIs except that the V3 hash adds the "sla_threshold"
, "manual_sla_threshold"
, "remote"
, "process"
, and "order_stats"
keys; these hashes have the following keys:
workflowid:
the workflow IDname:
the workflow nameversion:
the workflow versiondescription:
the workflow descriptionauthor:
the workflow authorremote:
if True, the workflow will run as a remote qwf process, otherwise it runs internally in the qorus-core processprocess:
present when remote
is True; this is a REST Process Execution Info Hashonetimeinit_func_instanceid:
the onetimeinit function ID for the workflow (if defined)attach_func_instanceid:
the attach function ID for the workflow (if defined)detach_func_instanceid:
the detach function ID for the workflow (if defined)errorfunction_instanceid:
the error function ID for the workflow (if defined)errhandler_func_instanceid:
the error handler function ID for the workflow (if defined)created:
the workflow creation datemodified:
the workflow last modified dateautostart:
the workflow autostart valuemanual_autostart:
a boolean flag set if the autostart
value has been changed manually, in which case the manual setting takes precendence over any new definitions loaded with oloadsla_threshold:
the workflow SLA threshold valuemanual_sla_threshold:
a boolean flag set if the sla_threshold
value has been changed manually, in which case the manual setting takes precendence over any new definitions loaded with oloadenabled:
a boolean flag indicating if the workflow is enabled or not; disabled workflows cannot be starteddeprecated:
a boolean flag indicating if the workflow is deprecated or not; deprecated workflows are not displayed by default in the UIkeylist:
a list of workflow order keysstepmap:
a hash where keys are step IDs and values are step namessteps:
a hash of step dependencies, where keys are step IDs and values are lists of step IDs that must preceed the step ID given as a keysegment:
a list of segment description hashes, where each segment hash has the following keys:steplist:
a list of step IDs in the segmentsteps:
a hash of step dependencies, where keys are step IDs and values are lists of step IDs that must preceed the step ID given as a keystart
]: the starting step ID for segments other than the initial segmentsubworkflow
]: set to True if the segment is a subworkflow segmentlinksegment
]: the previous segmentlinkstepid
]: the step linking the segment to the previous segmentlib:
a REST Library Object Hashmappers:
a list of mappers associated with the workflow (can be NOTHING); each mapper element is a REST Mapper Hashvmaps:
a list of value maps associated with the workflow (can be NOTHING); each value map element is a REST Value Map Hashstepinfo:
a list of hashes giving information about workflow steps; each hash is a REST Step Hash with the following additional keys:sfname:
the name of the primary step functionvfname
]: the name of the validation function (if any)afname
]: the name of the array function (if any)efname
]: the name of the back end function (if any)wffuncs:
a list of workflow-level functions (may be empty); each list element is a hash with the following keys:type:
the type of workflow function; one of:"onetimeinit"
: workflow execution instance initialization function"errorfunction"
: workflow error function"attachfunction"
: workflow attach function"detachfunction"
: workflow detach function"errorhandlerfunction"
: workflow error handler functionname:
the name of the functionversion:
the version of the functionfunction_instanceid:
the function IDfunction_type:
the type of the functiondescription:
a decsription for the functionauthor:
the author of the functioncreated:
the creation date in the databasemodified:
the last modified date in the databasesource:
the name of the source file for the function (complete path)line:
the line number offset for the function object definition in the fileoptions:
a list of option hashesexec:
a list of execution instance hashes describing any workflow execution instances running for this workflowexec_count:
the number of elements in the exec
listorder_stats:
a list of workflow order processing statistics; list values are OrderSummaryOutputInfo hashes for the given workflowalerts:
a list of alerts raised against the workflow; each list element is a REST Alert Hash (may be empty)connections:
a list of connection objects that this workflow depends on; each list element is a REST Connection Dependency Hash (may be empty)groups:
a list of interface groups that the workflow belongs to; each list element is a REST Interface Group Hash (may be empty)Order note hashes have the following keys:
service_methodid:
the service method IDname:
the name of the methoddescription:
the description of the method (if any)author:
the author of the method (if any)locktype:
the type of locking performed with method calls; see Service Method Lock Attribute Values for possible valuesinternal:
a boolean flag indicating if the method is restricted to internal calls only (if True then the method cannot be called externally)write:
a boolean flag indicating if the method is a "write" method, if True then callers need either OMQ::QR_CALL_USER_SERVICES_RW or OMQ::QR_CALL_SYSTEM_SERVICES_RW to callcreated:
the date/time the method was createdmodified:
the date/time the method was modifiedtags:
any user-defined tags on the methodsource:
the service source file that the method was created fromoffset:
the offset in the service file for the source of the methodhost:
the hostname of the machine where the method was loaded fromuser:
the OS user who loaded the servicehash: (14 members) service_methodid : 301033 name : "init" description : "service init method" author : "Qore Technologies, sro" locktype : "none" internal : False write : False created : 2016-05-20 18:32:57.177490 Fri +02:00 (CEST) modified : 2016-05-20 18:32:57.177490 Fri +02:00 (CEST) tags : <EMPTY HASH> source : "/Users/david/src/Qorus/git/qorus/system/prop-v3.1.qsd" offset : "45" host : "quasar.prague" user : "david"
Service method hashes in the REST v2 API are the same as in the V1 API except that the V2 hash adds the "sla"
key; these hashes have the following keys:
service_methodid:
the service method IDname:
the name of the methoddescription:
the description of the method (if any)author:
the author of the method (if any)locktype:
the type of locking performed with method calls; see Service Method Lock Attribute Values for possible valuesinternal:
a boolean flag indicating if the method is restricted to internal calls only (if True then the method cannot be called externally)write:
a boolean flag indicating if the method is a "write" method, if True then callers need either OMQ::QR_CALL_USER_SERVICES_RW or OMQ::QR_CALL_SYSTEM_SERVICES_RW to callcreated:
the date/time the method was createdmodified:
the date/time the method was modifiedtags:
any user-defined tags on the methodsource:
the service source file that the method was created fromoffset:
the offset in the service file for the source of the methodhost:
the hostname of the machine where the method was loaded fromuser:
the OS user who loaded the servicesla:
the SLA associated with the service method (if any)hash: (14 members) service_methodid : 301033 name : "init" description : "service init method" author : "Qore Technologies, sro" locktype : "none" internal : False write : False created : 2016-05-20 18:32:57.177490 Fri +02:00 (CEST) modified : 2016-05-20 18:32:57.177490 Fri +02:00 (CEST) tags : <EMPTY HASH> source : "/Users/david/src/Qorus/git/qorus/system/prop-v3.1.qsd" offset : "45" host : "quasar.prague" user : "david"
Service resource hashes are keyed by the resource name; each value is a hash with the following keys:
type:
the type of service resourcedesc:
a description of the resourceinfo:
a hash of information about the resource; the format and content of this hash depends on the resource typeresources : hash: (2 members) ui-extension-user-sql-data-view-1-1 : hash: (3 members) type : "UiExtension" desc : "Allows database and table browsing" info : hash: (4 members) url : "http://localhost:8001/UIExtension/user-sql-data-view-1" group : "SQL" menuname : "SQL Data View" desc : "Allows database and table browsing" http-global-2 : hash: (3 members) type : "HttpGlobalHandler" desc : "handling URL: \"db\"" info : hash: (2 members) content : <NOTHING> headers : <NOTHING>
Step hashes have the following keys:
stepid:
the ID of the steptypedesc:
a string describing the step type (ex: "NORMAL ARRAY")steptype:
the type of the steparraytype:
the array type of the stepname:
the name of the stepversion:
the version of the stepauthor:
the author of the step (if any)desc:
the description of the step or the description of the step's primary step function if the step itself has no descriptionstepfunction_instanceid:
the primary step function IDvalidationfunction_instanceid
]: the function ID of the validation function (if any)endfunction_instanceid
]: the function ID of the back end function for asynchronous steps (if any)arrayfunction_instanceid
]: the function ID of the array function (if any)queueid
]: the ID of the async event queue for asynchronous steps (if any)queuename
]: the name of the async event queue for asynchronous steps (if any)workflow_event_typeid
]: the ID of the workflow synchronization event type for workflow synchronization event steps (if any)user_interaction:
True
if the asynchronous step supports user interaction APIs, False
in all other casescreated:
the creation date of the step in the databasemodified:
the last modified date of the step in the databasehash: (11 members) stepid : 509 typedesc : "NORMAL" steptype : "NORMAL" arraytype : "NONE" name : "it_100_delivery_confirmation_update_oracle" version : "1.0" author : "Qore Technologies, s.r.o." stepfunction_instanceid : 508 validationfunction_instanceid : 122 created : 2016-02-05 13:38:26.000000 Fri +01:00 (CET) modified : 2016-02-05 14:00:51.000000 Fri +01:00 (CET)
Step hashes in the V3 REST API have the following keys:
stepid:
the ID of the steptypedesc:
a string describing the step type (ex: "NORMAL ARRAY")steptype:
the type of the steparraytype:
the array type of the stepname:
the name of the stepversion:
the version of the stepauthor:
the author of the step (if any)desc:
the description of the step or the description of the step's primary step function if the step itself has no descriptionconfig:
a hash of config items keyed by config item name with values as hashes with the following keys:type:
the type of the config itemdesc:
the description of the config itemdefault_value:
the default value of the config itemstepfunction_instanceid:
the primary step function IDvalidationfunction_instanceid
]: the function ID of the validation function (if any)endfunction_instanceid
]: the function ID of the back end function for asynchronous steps (if any)arrayfunction_instanceid
]: the function ID of the array function (if any)queueid
]: the ID of the async event queue for asynchronous steps (if any)queuename
]: the name of the async event queue for asynchronous steps (if any)workflow_event_typeid
]: the ID of the workflow synchronization event type for workflow synchronization event steps (if any)created:
the creation date of the step in the databasemodified:
the last modified date of the step in the databasehash: (11 members) stepid : 509 typedesc : "NORMAL" steptype : "NORMAL" arraytype : "NONE" name : "it_100_delivery_confirmation_update_oracle" version : "1.0" author : "Qore Technologies, s.r.o." stepfunction_instanceid : 508 validationfunction_instanceid : 122 created : 2016-02-05 13:38:26.000000 Fri +01:00 (CET) modified : 2016-02-05 14:00:51.000000 Fri +01:00 (CET)
Function hashes have the following keys:
name:
the name of the functionversion:
the version of the functionfunction_instanceid:
the function IDfunction_type:
the type of function object; see Step Function Types for possible valuesdescription:
the description of the functionauthor:
the author of the functionbody:
the source code for the functioncreated:
the date/time the function was createdmodified:
the date/time the function was modifiedcreatedby:
(deprecated) always "omq"
modifiedby:
(deprecated) always "omq"
tags:
any user-defined tags on the function objectsource:
the source file that the function object was created fromoffset:
the offset in the source file for the source of the function objecthost:
the hostname of the machine where the function was loaded fromuser:
the OS user who loaded the function sourcehash: (16 members) name : "it_00_dhl_dispatcher_create_wf" version : "1.0" function_instanceid : 183 function_type : "STEP" description : "binds the subworkflow" author : "Josephine Programmer" body : " %new-style %require-types %enable-all-warnings sub it_00_dhl_dispatcher_create_wf(string workflow) { hash<auto> sd = wf_get_static_data(); hash<auto> ord = ( \"staticdata\": sd, \"orderkeys\": wf_get_order_keys(), ); log(LoggerLevel::INFO, \"binding subworkflow %s\", workflow); wf_bind_subworkflow((\"name\" : workflow), ord); } " created : 2015-12-10 10:35:04.000000 Thu +01:00 (CET) modified : 2016-02-08 14:51:03.000000 Mon +01:00 (CET) createdby : "omq" modifiedby : "omq" tags : <EMPTY HASH> source : "/export/home/dnichols/src/drei/sepl-it/src/00-DHL/isepl/it-00-dhl_dispatcher_create_wf-v1.0.qfd" offset : "123" host : "manatee.prague.qoretechnologies.com" user : "dnichols"
Job result (job instance) hashes have the following keys:
name:
the name of the jobversion:
the version of the jobjob_instanceid:
the job_instanceid (unique ID for the job result)jobid:
the job IDjobstatus:
the status of executing the job; see Job Data Status Descriptions for possible valuesinfo:
a hash of information set by the job code during executionsessionid:
the application session ID that is currently processing the job instance (0 for no session)started:
the date/time the job instance was startedcompleted:
the date/time the job instance completedmodified:
the date/time the job was last modifiedJob description hashes have the following keys:
name:
the name of the jobjobid:
the job IDdescription:
the description of the job (if any)version:
the version of the jobauthor:
the author of the job (if any)sessionid:
If the job is currently active and running on a Qorus instance, then this attribute will have a value, otherwise it will not be setrun_skipped:
A boolean value telling the system if the job should be run immediately if the last scheduled run was missed due to system downtimeenabled:
a boolean flag indicating if the job is enabled or not; disabled jobs cannot be activatedmonth:
the month value in a job cron scheduleday:
the day value in a job cron schedulewday:
the weekday value in a job cron schedulehour:
the hout value in a job cron scheduleminute:
the minute value in a job cron schedulemanually_updated:
a boolean flag set if the job schedule has been changed manually, in which case the manual setting takes precendence over any new definitions loaded with oloadcreated:
the date/time the job was createdmodified:
the date/time the job was modifiedsource:
the complete path of the job source file when loadedline:
the line offset of the job source code in the filemappers:
list of mappers associated with the job (can be NOTHING); each mapper element is a REST Mapper Hashvmaps:
list of value maps associated with the job (can be NOTHING); each value map element is a REST Value Map Hashlib:
a REST Library Object Hashtags:
any user-defined tags on the jobdb_active:
a boolean flag indicating the active status in the databaseactive:
the active status in the current Qorus instanceoptions:
a hash of options set on the job (if any)offset:
the line offset of the job source code in the filehost:
the hostname of the machine where the job was loaded fromuser:
the OS user who loaded the jobsched_type:
the schedule type; one of:"cron"
: uses a job cron schedule"recurring"
: uses a fixed erpeat delaysched_txt:
a string describing the schedule (ex: "minutes: 0, hours: 0, days: *, months: *, wdays: *"
)connections:
a list of connection objects that this job depends on; each list element is a REST Connection Dependency Hash (may be empty)alerts:
a list of alerts raised against the job; each list element is a REST Alert Hash (may be empty)Job description hashes in the REST v2 API are the same as in the V1 API except that the V2 hash adds the "sla"
key; these hashes have the following keys:
name:
the name of the jobjobid:
the job IDdescription:
the description of the job (if any)version:
the version of the jobauthor:
the author of the job (if any)sessionid:
If the job is currently active and running on a Qorus instance, then this attribute will have a value, otherwise it will not be setrun_skipped:
A boolean value telling the system if the job should be run immediately if the last scheduled run was missed due to system downtimeenabled:
a boolean flag indicating if the job is enabled or not; disabled jobs cannot be activatedmonth:
the month value in a job cron scheduleday:
the day value in a job cron schedulewday:
the weekday value in a job cron schedulehour:
the hout value in a job cron scheduleminute:
the minute value in a job cron schedulemanually_updated:
a boolean flag set if the job schedule has been changed manually, in which case the manual setting takes precendence over any new definitions loaded with oloadcreated:
the date/time the job was createdmodified:
the date/time the job was modifiedsource:
the complete path of the job source file when loadedline:
the line offset of the job source code in the filemappers:
list of mappers associated with the job (can be NOTHING); each mapper element is a REST Mapper Hashvmaps:
list of value maps associated with the job (can be NOTHING); each value map element is a REST Value Map Hashlib:
a REST Library Object Hashtags:
any user-defined tags on the jobdb_active:
a boolean flag indicating the active status in the databaseactive:
the active status in the current Qorus instanceoptions:
a hash of options set on the job (if any)offset:
the line offset of the job source code in the filehost:
the hostname of the machine where the job was loaded fromuser:
the OS user who loaded the jobsched_type:
the schedule type; one of:"cron"
: uses a job cron schedule"recurring"
: uses a fixed erpeat delaysched_txt:
a string describing the schedule (ex: "minutes: 0, hours: 0, days: *, months: *, wdays: *"
)connections:
a list of connection objects that this job depends on; each list element is a REST Connection Dependency Hash (may be empty)alerts:
a list of alerts raised against the job; each list element is a REST Alert Hash (may be empty)sla:
the name of the attached SLA (if any, if no SLA is associated, this key is not returned)System option hashes have the following keys:
name:
the name of the option; see System Options for a list of possible optionsvalue:
the value of the optionexpects:
the value type of the optiondesc:
the description of the optiondefault:
the default value of the optionstartup-only
: True if the option can only be set during system startupstatus:
"locked"
if startup-only
is True, "unlocked"
if notworkflow:
True if the option can be overridden at the workflow level, False if notservice:
True if the option can be overridden at the service level, False if notjob:
True if the option can be overridden at the job level, False if notinterval
]: the range of valid values for the option (inclusive)hash: (11 members) name : "verbose" value : 11 expects : "integer" desc : "sets verbose level" default : 2 startup-only : <NOTHING> status : "unlocked" workflow : True service : True job : True interval : list: (2 elements) [0]=1 [1]=6
REST system UI extension hashes have the following keys:
name:
The name of the extensiongroup:
a user-defined extension group nametype:
the type of service serving the extensionservice:
the name of the service serving the extensionmenuname:
the menu string to use for the extensiondesc:
a short descriptive string for the extensionurl:
the full URL to the extensionurl_name:
a label for the URL of the extensionRest permissions hashes have the following keys:
permission_type:
the type of permission; one of:"SYSTEM"
: for system permissions"USER"
: for user permissionsdesc:
a description for the permissionname:
the name of the permission (permission code; ex: "RELOAD-DATASOURCE"
)Listener hashes have the following keys:
name:
the unique name of the listenerhostname:
the bind hostnamehostname_desc:
a description for the hostnameaddress:
the bind addressaddress_desc:
a description for the addressport
]: the port number (not present in UNIX sockets)family:
the network address family code for the socketfamilystr:
a descriptive string for the family
codessl:
True if the listener is a TLS/SSL listenerdesc:
a descriptive string for the listenerproto:
the protocol; either "http"
or "https"
id:
the listener IDbind:
the bind stringInterface group hashes have the following keys:
name:
the name of the groupdescription:
group descriptionid:
the ID for the group; synthetic groups have negative IDsenabled:
a boolean flag indicating if the group is enabled or notsize:
the number of workflow, service, job, mapper, and value map members of the groupis_default
: Falseservices:
a list of hashes of services belonging to the group (can be NOTHING); each element has the following keys:type:
the type of the service; one of:"system"
: for system services"user"
: for user servicesserviceid:
the service IDname:
the name of the serviceversion:
the version of the serviceautostart:
a boolean value indicating if the service should be autostarted or notworkflows:
a list of hashes of workflows belonging to the group (can be NOTHING); each element has the following keys:workflowid:
the workflow IDname:
the name of the workflowversion:
the version of the workflowjobs:
a list of hashes of jobs belonging to the group (can be NOTHING); each element has the following keys:jobid:
the job IDname:
the name of the jobversion:
the version of the jobmappers:
a list of mappers belonging to the group (can be NOTHING); each mapper element is a REST Mapper Hashvmaps:
a list of value maps belonging to the group (can be NOTHING); each value map element is a REST Value Map Hashroles:
a list of string role names that have this group (can be NOTHING)synthetic:
True if the group is a synthetic group (in which case the id
will be negative)User hashes have the following keys:
provider:
the name of the RBAC provider (see also qorus.rbac-external)username:
the unique username of the username:
the descriptive name of the userhas_default:
a boolean flag that indicates if the user has the "DEFAULT"
group or not; if True, then the user has no limitations on the configuration that can be accessedroles:
a list of roles that the user has; roles actually determine system and object access permissions for userspermissions:
a list of permissions that the user has (as inherited through roles)workflows:
a list of workflows that the user is allowed to access (if has_default
is True then this list is empty and the user can access all objects; as inherited through roles)services:
a list of services that the user is allowed to access (if has_default
is True then this list is empty and the user can access all objects; as inherited through roles)jobs:
a list of jobs that the user is allowed to access (if has_default
is True then this list is empty and the user can access all objects; as inherited through roles)mappers:
a list of mappers that the user is allowed to access (if has_default
is True then this list is empty and the user can access all objects; as inherited through roles)vmaps:
a list of value maps that the user is allowed to access (if has_default
is True then this list is empty and the user can access all objects; as inherited through roles)groups:
the interface groups that the user is allowed to access (if has_default
is True then this list is empty and the user can access all objects; as inherited through roles)storage:
an optional hash of user-speficic storage informationhash: (13 members) provider : "db" username : "admin" name : "Administrator" has_default : True roles : list: (1 element) [0]="superuser" permissions : list: (23 elements) [0]="CALL-SYSTEM-SERVICES-RW" [1]="CALL-USER-SERVICES-RW" [2]="DATASOURCE-CONTROL" [3]="EDIT-WORKFLOW-DATA" [4]="EXEC-SYNC-WORKFLOW" [5]="FILESYSTEM-CONTROL" [6]="GROUP-CONTROL" [7]="JOB-CONTROL" [8]="LOGIN" [9]="MAPPER-CONTROL" [10]="OPTION-CONTROL" [11]="ROTATE-LOG-FILES" [12]="SCHEMA-CONTROL" [13]="SERVER-CONNECTION-CONTROL" [14]="SERVER-CONTROL" [15]="SERVICE-CONTROL" [16]="SHUTDOWN" [17]="SUBMIT-ORDER" [18]="USER-CONNECTION-CONTROL" [19]="USER-CONTROL" [20]="VALUE-MAP-CONTROL" [21]="VALUE-SET-CONTROL" [22]="WORKFLOW-CONTROL" workflows : <EMPTY LIST> services : <EMPTY LIST> jobs : <EMPTY LIST> mappers : <EMPTY LIST> vmaps : <EMPTY LIST> groups : list: (1 element) [0]="DEFAULT" storage : hash: (1 member) ui : hash: (1 member) views : hash: (1 member) workflows : hash: (1 member) filters : <EMPTY LIST>
Role hashes have the following keys:
role:
the unique username of the roleprovider:
the name of the RBAC provider (see also qorus.rbac-external)desc:
the description of the rolehas_default:
a boolean flag that indicates if the role has the "DEFAULT"
group or not; if True, then users with this role have no limitations on the configuration that can be accessedpermissions:
a list of permissions that the role hasgroups:
the interface groups that the group restricts access to (if has_default
is True then this list is empty, and the role does not restrict access to any objects)workflows:
a list of workflows that the role restricts access to as determined by its interface groups (if has_default
is True then this list is empty, and the role does not restrict access to any objects)services:
a list of services that the role restricts access to as determined by its interface groups (if has_default
is True then this list is empty, and the role does not restrict access to any objects)jobs:
a list of jobs that the role restricts access to as determined by its interface groups (if has_default
is True then this list is empty, and the role does not restrict access to any objects)mappers:
a list of mappers that the role restricts access to as determined by its interface groups (if has_default
is True then this list is empty, and the role does not restrict access to any objects)vmaps:
a list of value maps that the role restricts access to as determined by its interface groups (if has_default
is True then this list is empty, and the role does not restrict access to any objects)hash: (12 members) role : "maintenance" provider : "db" desc : "user with roles suited to system maintenance only" has_default : True permissions : list: (17 elements) [0]="CALL-SYSTEM-SERVICES-RO" [1]="CALL-USER-SERVICES-RO" [2]="DATASOURCE-CONTROL" [3]="FILESYSTEM-CONTROL" [4]="JOB-CONTROL" [5]="LOGIN" [6]="OPTION-CONTROL" [7]="RELOAD-MAPPER" [8]="RELOAD-VALUE-MAP" [9]="RELOAD-VALUE-SET" [10]="ROTATE-LOG-FILES" [11]="SCHEMA-CONTROL" [12]="SERVER-CONNECTION-CONTROL" [13]="SERVICE-CONTROL" [14]="SHUTDOWN" [15]="USER-CONNECTION-CONTROL" [16]="WORKFLOW-CONTROL" groups : list: (1 element) [0]="DEFAULT" workflows : <EMPTY LIST> services : <EMPTY LIST> job : <EMPTY LIST> mappers : <EMPTY LIST> vmaps : <EMPTY LIST> users : <EMPTY LIST>
Callstack hashes have the following keys:
function:
the function or method name in the stackline:
the starting line numberendline:
the ending line numberfile:
the source label or file namesource:
the full source path (if known)offset:
the offset of the source object within source
(if known)typecode:
see Call Type Constants for possible valuestype:
a string corresponding to typecode
Connection dependency hashes have the following keys:
type:
the interface type; one of "WORKFLOW"
, "SERVICE"
, or "JOB"
workflowid
]: the workflow IDserviceid
]: the service IDjobid
]: the job IDservicetype
]: the service type (only present for services); one of "user"
or "system"
name:
the interface nameversion:
the interface versiondesc:
a description of the interface (ex: "job it-94-ar_payments-piteco-out v1.0 (23)"
)User connection and remote connection hashes have the following keys:
name:
the name of the connectionconntype:
either "REMOTE"
or "USER-CONNETION"
desc:
a description of the connectionurl:
the URL to the remote hostmonitor:
a boolean indicating if the connection is monitored or notlast_check:
the date/time value the connection was last checked (loopback remote connections are not checked)updated:
the date/time the connection was last updatedstatus:
one of the following:"OK"
: the connection is OK"not checked"
: not yet checkedup:
a boolean indicating if the connection was monitored to be up or notloopback
]: (only for remote connections) a boolean indicating if the connection is a loopback connectiontype:
the connection typeurl_hash:
a hash of broken-down URL components as returned by Qore::parse_url()opts:
a hash of options for the connectiondeps:
a list of REST Connection Dependency Hash elements for dependent interfacesalerts:
a list of alerts raised against the connection; each list element is a REST Alert Hash (may be empty)remote
]: (only for remote connections when loopback
= False) a hash with the keys instance-key
, health
, alert-summary
and omq-version
User connection and remote connection hashes have the following keys:
name:
the name of the connectionconntype:
either "REMOTE"
or "USER-CONNETION"
desc:
a description of the connectionurl:
the URL to the remote hostmonitor:
a boolean indicating if the connection is monitored or notlast_check:
the date/time value the connection was last checked (loopback remote connections are not checked)updated:
the date/time the connection was last updatedstatus:
one of the following:"OK"
: the connection is OK"not checked"
: not yet checkedup:
a boolean indicating if the connection was monitored to be up or notloopback
]: (only for remote connections) a boolean indicating if the connection is a loopback connectiontype:
the connection typefeatures:
a hash of features supported by the connectionauth_request_uri
]: a URI to make OAuth2 authorization code grant requests, if supported by the connectionurl_hash:
a hash of broken-down URL components as returned by Qore::parse_url()opts:
a hash of options for the connectiondeps:
a list of REST Connection Dependency Hash elements for dependent interfacesalerts:
a list of alerts raised against the connection; each list element is a REST Alert Hash (may be empty)remote
]: (only for remote connections when loopback
= False) a hash with the keys instance-key
, health
, alert-summary
and omq-version
datasource connection hashes have the following keys:
name:
the name of the datasourceconntype:
"DATASOURCE"
desc:
a technical description of the connection without the password (ex: "freetds:test@mssql"
)monitor:
a boolean indicating if the connection is monitored or notlast_check:
the date/time value the connection was last checked (loopback remote connections are not checked)updated:
the date/time the connection was last updatedstatus:
one of the following:"OK"
: the connection is OK"not checked"
: not yet checkedup:
a boolean indicating if the connection was monitored to be up or nottype:
the database driver for the connectionuser:
the database username for the connectiondb:
the database name for the connectionshared-pool
: a string describing the shared DatasourcePool statuswarning-timeout
: the period in milliseconds after which a warning is raised as a transient alert if a connection cannot be allocated from the DatasourcePool statuserror-timeout
: the period in milliseconds after which an exception is thrown if a connection cannot be allocated from the DatasourcePool statuspool-wait-max
: maximum connection wait time in milliseconds for connections on the pool (0 means no contention)pool-reqs
: the number of requests for connections from the pool (= pool-hits
+ pool-miss
)pool-hits
: the number of connection requests that were immediately satisified with no waiting (= pool-reqs
- pool-miss
)pool-miss
: the number of connection requests that blocked due to contention in the pool (= pool-reqs
- pool-hits
)pool-hit-pct
: the percentage of connection requests that were satisified immediately over all requests (100 means no contention)alerts:
a list of alerts raised against the connection; each list element is a REST Alert Hash (may be empty)deps:
a list of REST Connection Dependency Hash elements for dependent interfacesWorkflow error hashes have the following keys (REST API v1 and v2):
error:
the error code (ex: "SOCKET-SSL-ERROR"
)description:
a description for the errorseverity:
an error severity code (see Error Severity Codes for possible values)retry_flag:
a boolean value indicating if the error should cause the workflow order to get a retry or notbusiness_flag:
a boolean flag indicating of the error is a business errorretry_delay_secs:
if retry_flag
is True, the number of seconds that the order should wait before retryingmanually_updated:
a boolean flag set if the error has been changed manually (if True then subsequent loads with oload: Data Loading Tool and Schema Manager will not overwrite the configuration in the DB)type:
either "global"
or "workflow"
giving the error definition scopeworkflowname
]: (only if type
= "workflow"
) the name of the workflow where the workflow-specific error is definedworkflowversion
]: (only if type
= "workflow"
) the version of the workflow where the workflow-specific error is definedworkflowid
]: (only if type
= "workflow"
) the ID of the workflow where the workflow-specific error is definedWorkflow error hashes have the following keys (REST API v3+):
business_flag:
a boolean flag indicating of the error is a business errordescription:
a description for the errorerror:
the error code (ex: "SOCKET-SSL-ERROR"
)manually_updated:
a boolean flag set if the error has been changed manually (if True then subsequent loads with oload: Data Loading Tool and Schema Manager will not overwrite the configuration in the DB)retry_delay_secs:
if status
is RETRY, the number of seconds that the order should wait before retryingretry_flag:
a boolean value indicating if the error should cause the workflow order to get a retry or notseverity:
an error severity code (see Error Severity Codes for possible values)status:
the status the order enters when this error appears (ERROR, RETRY, CANCELED)type:
either "global"
or "workflow"
giving the error definition scopeworkflowid
]: (only if type
= "workflow"
) the ID of the workflow where the workflow-specific error is definedworkflowname
]: (only if type
= "workflow"
) the name of the workflow where the workflow-specific error is definedworkflowversion
]: (only if type
= "workflow"
) the version of the workflow where the workflow-specific error is definedClass description hashes have the following keys (REST API v3+):
name:
the name of the class objectversion:
the version of the class objectclassid:
the class object IDdescription:
the description of the classauthor:
the author of the classbody:
the source code for the class objectlanguage:
the language of the class; either "qore"
or "java"
created:
the date/time the class was createdmodified:
the date/time the class was modifiedcreatedby:
(deprecated) always "omq"
modifiedby:
(deprecated) always "omq"
tags:
any user-defined tags on the class objectsource:
the source file that the class object was created fromoffset:
the offset in the source file for the source of the class objecthost:
the hostname of the machine where the class object was loaded fromuser:
the OS user who loaded the class objectMapper description hashes have the following keys:
mapperid:
the mapper IDname:
the name of the mapperversion:
the version of the mapperpatch:
the patch string of the mapper (if any)desc:
the description for the mapperparse_options:
a list of symbolic parse options for the mapper program container (if any parse options are defined)created:
the date/time the mapper was createdmodified:
the date/time the mapper was modifiedtype:
the type of the mapperopts:
a hash of mapper options; "input"
and "output"
define the input and output records, respectivelyvalid:
True if the mapper is valid, False if notgroups:
a list of interface groups that the mapper belongs to; each list element is a REST Interface Group Hash (may be empty)Mapper type description hashes have the following keys:
name:
the mapper type nameoptions:
a hash of valid options for the mapper type; keys are option names, values are option descriptionsruntime_options:
a hash of valid runtime options for the mapper type; keys are option names, values are option descriptionsrequired_options:
a list of required options; if any of the options in this list are not provided when creating a mapper of this type, the creation will failrequired_record_options:
a list of mapper options that must be given to create the input or output records for the mapper for mappers that can create either input and/or output descriptions automaticallyrequires_input
: Truerequires_output
: Falsetype:
either "system"
(a mapper type provided by Qorus) "user"
(supplied with a mapper module)module
]: a hash of module info as returned by Qore::get_module_hash() (only present if type
= "user"
)Value map description hashes have the following keys:
id:
the value map IDname:
the name of the value mapauthor:
the author of the value map (if any)throws_exception:
a boolean value indicating if a map lookup failure should throw an exception or notvaluetype:
the data type of the value mapmapsize:
the number of entries in the value mapcreated:
the date/time the value map was createdmodified:
the date/time the value map was modifiedgroups:
a list of interface groups that the value map belongs to; each list element is a REST Interface Group Hash (may be empty)Workflow synchronization event hashes have the following keys:
id:
the workflow synchronization event type ideventname:
the workflow synchronization event type nameeventkey:
synchronization event type keyposted:
a boolean posted statuscreated:
the date/time the event was createdmodified:
the date/time the event was modified (posted)hash: (6 members) id : 2 eventname : "regression-test" eventkey : "c4e0b32b-fec9-40a1-8f95-c8362a2d0abb" posted : True created : 2016-02-11 17:08:09.000000 Thu +01:00 (CET) modified : 2016-02-11 17:08:09.000000 Thu +01:00 (CET)
Workflow synchronization event type hashes have the following keys:
id:
the workflow synchronization event type IDname:
the workflow synchronization event type namedesc:
the description for the workflow synchronization event typeProcess info hashes have the following keys:
id
(string): the unique process ID in the clusternode
(string): the node name where the process is runninghost
(string): the hostname where the process is runningpid
(int): the PID on the hosturls
(list<string>): a list of ZeroMQ URLs for the processstatus
(string): the process's status as a stringpriv
(int): the amount of private memory of the process in bytesrss
(int): the resident size of the process in bytesvsz
(int): the virtual size of the process in bytespriv_str
(string): a string description of the priv
valuepct
(int): the percentage of main memory taken up by the process on the nodeThe cluster process information hash is keyed by cluster process ID; values have the following keys:
id
(string): the unique process ID in the clusternode
(string): the node name where the process is runninghost:
(string) the hostname of the node running the processpid:
(int) the PID of the process on the hosturls
(list<string>): a list of ZeroMQ URLs for the processstatus:
(int) the process status code; 0 = IDLE, 1 = STARTING, 2 = RUNNING, 3 = STOPPING, 4 = ERRORstatus_string
(string) the string description corresponding to status type:
(string) the type of cluster processclient_id:
(string) the type-specific ID for the processpriv:
(int) the amount of private memory (heap + stack + non-shared, non-memory-mapped virtual memory segments) for the process in bytesrss:
(int) the resident size of the process in bytesvsz:
(int) the virtual memory size of the process in bytesOther keys are present depending on the process type.
The workflow info hash has the following keys:
name:
the name of the workflowversion:
the version of the workflowpatch:
the patch string for the workflowdescription:
the description of the workflowworkflowid:
the workflowiderrorfunction_instanceid:
the function_instanceid of the error function, if anyattach_func_instanceid:
the function_instanceid of the attach function, if anydetach_func_instanceid:
the function_instanceid of the detach function, if anyonetimeinit_func_instanceid:
the function_instanceid of the one time init function, if anyerrhandler_func_instanceid:
the function_instanceid of the error handler function, if anycreated:
the date/time the workflow was createdmodified:
the date/time the workflow was last modifiedkeylist:
a list of valid order keys for the workflowstepmap:
a hash where the keys are stepids and the values are step namessteps:
a hash of step dependencies where the keys are stepids and the values are lists of steps are the direct dependent steps (that must be COMPLETE before the step given as the key can be executed)segment:
a list of segment information, where each element in the list is a segment info hashstepseg:
a hash of asynchronous/subworkflow/event stepids and their associated back-end segmentsoptions:
optional: a hash of workflow options where the keys are the option names and values are the descriptionslib:
optional: a hash of library objects where the top-level keys are one of the following strings: "FUNCTION"
, "CLASS"
, "CONSTANT"
and the values are lists of object namesThe step info hash has the following keys:
name:
step nameversion:
step versionpatch:
step patchleveldescription:
step descriptionsteptype:
step typestepfunction_instanceid
]: the function_instanceid for the primary step function (not present for class-based steps)validationfunction_instanceid
]: the function_instanceid for the validation function (if present)endfunction_instanceid
]: the function_instanceid for the asynchronous end function (if present)arrayfunction_instanceid
]: the function_instanceid for the array function (if present)arraytype
]: the type of array step for array steps (only for array steps)step_sourceid
]: the ID of the class for the step class, if the step is a class-based stepqueueid
]: the async event queue ID for asynchronous steps (not present if not an asynchronous step)queuename
]: the name of the async event queue for asynchronous steps (not present if not an asynchronous step)workflow_event_typeid
]: the workflow_event_typeid for workflow event steps (only for workflow event steps)created:
the created date/time of the stepsteplist:
list of stepids in the segmentsteps:
a step dependency hash as aboveprereqfor:
optional: list of segmentid that depend on this segmentstart:
optional: the first stepid in the segmentlinksegment:
optional: the segmentid that directly precedes this segment as linked from an asynchronous/subworkflow/event steplinkstepid:
optional: the stepid of the asynchronous/subworkflow/event step that link this segment to the previous segment