User Tools

Site Tools


DATA PROCESSING objects


A Child object to DATA PROCESSING→SCALAR performs data manipulation on SCALAR's and/or LIST's and returns a single value as a SCALAR.

DATA PROCESSING→SCALAR

DATA PROCESSING→SCALAR
COMPUTEstore a value of an expression containing a SCALAR
CONTACT DETAILSreturn user name, full name or e-mail address of user
CUSTOM SCALARreturn SCALAR generated using custom Java code within the EASA API
DATE COMPARISONcompare two date SCALAR's against each other
DATE CONVERSIONconvert date SCALAR's from one format to another
EXPANDcreate a single instance of one or more lines of text
FILE SYSTEMdetermine existence of a file or returns its full path or URL
SCALAR DOR VALUEstore a SCALAR, typically for use with a CUSTOM ACTION
FORMATperform formatting on a numerical SCALAR DOR
GET INDEXretrieve an index from a LIST given a value to find in the LIST
GET VALUEretrieve a value from a LIST given a location or index within the LIST
IS VALIDdetermine if another object value is valid
MAPmapping from a LIST (Inputs:) to a new value specified in another LIST (Outputs:)
REPLACEreplace part of a string of text
SEARCHfind the location of text within a string of text
STATISTICScompute a statistic: average, count, maximum, minimum, first, last, standard deviation, sum
STRINGtext operation on a string (eg. converts to upper case)
SUBSTRINGextract part of a string of text based on start and end character positions
SYSTEM PROPERTYgenerate a SCALAR from a Java system property

DATA PROCESSING→LIST

A Child object under DATA PROCESSING→LIST performs data manipulation on SCALAR's and/or LIST's and returns a LIST.

DATA PROCESSING→LIST
AUTO LISTgenerate a LIST of numbers or letters given a list size
CONCATENATEconcatenate LIST's and/or SCALAR's together into one LIST
CUMULATIVE SUMcompute a LIST by cumulatively summing the values of another LIST
CUSTOM LISTreturn LIST of values generated using custom Java code within the EASA API
CUSTOM MULTI-LISTreturn a LIST of new LIST names generated using custom Java code within the EASA API
CUTcut out a subset of values from an existing LIST
DATABASEa READ will retrieve list data from a database
LIST DOR VALUEstore a LIST of values, typically for use with CUSTOM ACTION's
EXTRACTREPEAT and FIND extract LIST data from a file
INTERLEAVEcombine existing lists to produce one interleaved LIST
JSONPATHaccept a JSON string and query and returns data
MAPPED LISTselect a LIST based on a SCALAR input value
OBJECT QUERYretrieve name, value and parameter value information from other objects
REPEATED COMPUTEstores repeated values of an expression based on a given LIST
REPEATED DATE CONVERSIONconvert a LIST of dates from one date format to another
REPEATED EXPANDcreate a LIST containing one or more lines of text for each value of a given LIST
REPEATED FORMATformat a LIST DOR of numerical values
REPEATED GET INDEXretrieve indexes from a LIST given the values to find in the LIST
REPEATED GET VALUEretrieve values from a LIST given locations or indexes within the LIST
REPEATED MAPsame as SCALAR MAP except each value of a LIST is mapped
REPEATED REPLACEreplace text within a string, repeated for each string in LIST.
REPEATED SEARCHfind the location of text within a string, repeated for each string in a LIST
REPEATED STRINGText operation on a string (eg. converts to upper case), repeated for each string in LIST.
REPEATED SUBSTRINGextract part of a string based on start and end character positions, repeated for each string in LIST
SETperform set operations such as intersection on a pair of LIST's
SORTproduce a LIST containing the values of another LIST sorted alpha-numerically based on its own or yet another LIST's values
SPLITsplit a text string into a LIST given a separator found in the text string
UNIQUE LIST DORreduce a LIST of elements into a set of unique elements.
XPATHextract data from XML using XPath