YADA Parameters

Categorical Parameter List

Query Processing Parameters

Result Limiting/Extending Parameters

Reference

Name: args
Alias: a
Required: No
Default: empty list
Accepted Values: comma-delimited list of strings
Description: When accompanied by a single plugin or pl parameter, used as the default argument list, per below.
A comma-separated list of values to be passed to the plugin designated in the plugin or pl parameter value. The plugin should be expecting these values as positional arguments, i.e.,arg1,arg2,...argN. When using script plugins, the first argument must contain the path to the registered script (relative to the yada_bin directory,) i.e., myscript.pl,arg1,arg2,...argN. See the Plugin Guide for more info.


Name: bypassargs
Alias: b
Required: No
Default: empty list
Accepted Values: comma-delimited list of strings
Description A comma-separated list of values to be passed to the plugin designated in the plugin or pl parameter value. The plugin should be expecting these values as positional arguments, i.e., arg1,arg2,...argN. When using script plugins, the first argument must contain the path to the registered script (relative to the yada_bin directory,) i.e., myscript.pl,arg1,arg2,...argN. See the Plugin Guide for more info.


Name: colHead
Alias:
Required: No
Default: false
Accepted Values: true, false
Description: PROVISIONAL


Name: commitQuery
Alias: cq
Required: No
Default: false
Accepted Values: true, false
Description: By default, YADA will execute a single commit per connection per request. In other words, if multiple queries for a single data source are passed in a single http request to the YADA server, the QueryManager will execute a single commit for each of these query’s connections after all queries are processed. If queries for multiple data sources are included, a single commit for each source will be executed after all queries for all sources are executed. Setting this parameter to true will cause YADA to issue a commit after each individual query.


Name: compact
Alias:
Required: No
Default: false
Accepted Values: true, false
Description: PROVISIONAL


Name: converter
Alias: cv
Required: No
Default: computed
Accepted Values: Name or FQCN of converter class
Description:


Name: cookies
Alias: ck
Required: No
Default: null
Accepted Values: Comma-delimited list of Strings
Description: FOR REST REQUESTS ONLY A list of cookie names present in the client that should be included in the request sent to the REST source.


Name: count
Alias: c
Required: No
Default: true
Accepted Values: true, false
Description: When true, YADA executes the query twice, the first time to retrieve the first page of records, and the second, to get the total record count, returning this value in the result JSON records key or XML attribute. This is useful for tables which, for example, can display records 1-10 of 50 in the footer. When false, the second query is not executed. This enables better performance for drop down list population, or data analysts who simply want the data as fast as possible.


Name: countOnly
Alias: co
Required: No
Default: false
Accepted Values: true, false
Description: When true, skips the data retrieval query and only returns the record count.


Name: delimiter Alias: d
Required: No
Default: , (comma)
Accepted Values: any string
Description: The character or sequence of characters used to separate data fields in a delimited text file format, as a comma in CSV, or a tab in TSV. Note that comma, tab, and pipe-delimiters are supported natively using the format parameter. Use of this parameter will cause format to be set automatically to delimited. See format.


Name: export
Alias: e
Required: No
Default: false
Accepted Values: true, false
Decription: When true, outputs the result as a file in /files/out/<user>/<YYYYHHMMhhmmss>.<ext> and returns the URL in the response. This is intended to be used in javascript applications with ajax calls, having success handlers that proceed to retrieve exported files using window.location.href


Name: exportlimit
Alias: el
Required: No
Default: -1
Accepted Values: any positive integer
Description:


Name: filters
Alias: fi
Required: No
Default: null
Accepted Values: JSON string conforming to Filter Specification
Description:


Name: format
Alias: f
Required: No
Default: json
Accepted Values: json, csv, tsv or tab, psv or pipe, xml, html, delimited
Description: Retrieve results in JSON, XML, rudimentary HTML, or tab-, csv-, or pipe-delimited files.
Custom delimiters are now supported, which automatically set the format to delimited. See delimiter


Name: harmonyMap
Alias: h
Required: No
Default: null
Accepted Values: JSON string conforming to Harmonizer Specification
Description: A JSON string pairing source-result field names or paths to response field names or paths. See Harmonizer Specification


Name: join
Alias: ij
Required: No
Default: null
Accepted Values: true or comma-separated list of values
Description: YADA uses an in-memory database to create tables containing the results of a multi-query request on-the-fly, then constructs and executes a SELECT...JOIN query and returns the results in the desired format. When set to true, the Joiner class will evaluate all the converted headers and base the in-memory db configuration and join query on matching column names in the results. When set to a comma-delimited string, YADA will construct the query only using the designated columns.

Note: Currently, the original queries must be JDBC ResultSet objects, as the Converter classes ResultSetResultJSONConverter and ResultSetResultDelimitedConverter are the only ones storing converted header and data values utiziled by the Joiner class.


Name: JSONParams
Alias: j
Required: Yes, in the absence of qname or q, otherwise no
Default: null
Accepted Values: JSON string conforming to JSONParams Specification
Description: See JSONParams Specification


Name: labels
Alias:
Required: No
Default: true
Accepted Values: true, false
Description: PROVISIONAL


Name: leftJoin
Alias: lj
Required: No
Default: null
Accepted Values: true or comma-separated list of values
Description: YADA uses an in-memory database to create tables containing the results of a multi-query request on-the-fly, then constructs and executes a SELECT...LEFT JOIN query and returns the results in the desired format. When set to true, the Joiner class will evaluate all the converted headers and base the in-memory db configuration and join query on matching column names in the results. When set to a comma-delimited string, YADA will construct the query only using the designated columns.

Note: Currently, the original queries must be JDBC ResultSet objects, as the Converter classes ResultSetResultJSONConverter and ResultSetResultDelimitedConverter are the only ones storing converted header and data values utiziled by the Joiner class.


Name: mail
Alias:
Required:
Default: null
Accepted Values: JSON string conforming to Mail Specification
Description: See Mail Specification


Name (deprecated): method
Alias (deprecated): m
Required (deprecated): No
Default (deprecated): get Accepted Values (deprecated): get, update, upload
Description (deprecated): Deprecated. method is now auto-detected. Identifies for the com.novartis.opensource.yada.Service object which JDBC method to execute. get, the default, performs a SELECT. update performs any SQL data change action (i.e., update, delete, insert, transactionally or not, using JDBC). upload is explicit to file uploads from a ui to the server. REST and SOAP play by different rules.


Name (deprecated): overargs
Alias (deprecated): o
Required (deprecated): No
Default (deprecated): empty list
Accepted Values (deprecated): comma-delimited list of strings
Description (deprecated): Deprecated. See bypassargs


Name: pagesize
Alias: pz
Required: No
Default: 20
Accepted Values: any positive integer
Description: The number of records to return when implementing pagination. Set pagesize=-1 to retrieve all results (up to 1 billion rows).


Name: pagestart
Alias: page, pg
Required: No
Default: 1
Accepted Values: any positive integer
Description: The current page of data returned, e.g., if pagesize=20, page=2 would return records 21-40.


Name (deprecated): parallel
Alias (deprecated):
Required (deprecated): No
Default (deprecated): false
Accepted Values (deprecated): true, false
Description (deprecated): Deprecated.


Name: params
Alias: p
Required: No
Default: null
Accepted Values: comma-delimited list of strings
Description: The values corresponding to positional parameters in the YADA query, in a comma separated list.


Name: paramset
Alias: ps
Required: No
Default: null
Accepted Values: comma-delimited list of strings
Description: PROVISIONAL a named set of url parameters and values stored in the YADA Index, just like queries


Name: path
Alias:
Required: No
Default: null
Accepted Values:
Description: For internal use only Currently used by Service object when processing uploads.


Name: plugin
Alias: pl
Required: No
Default: empty string
Accepted Values: Name or FQCN of plugin class
Description: For java plugins that are deployed in the YADA server, in the com.novartis.opensource.yada.plugin package, the plugin value is the either the classname, or the fully qualified class name (FQCN) e.g, XSLPostprocessor or com.novartis.opensource.yada.XSLPostprocesor. For script plugins, one can use the preargs, postargs, and bypassargs url parameters to pass the script path. YADA Service will automatically engage the correct script plugin helper, e.g., com.novartis.opensource.yada.plugin.ScriptPreProcessor. See preargs for more info. See the Plugin Guide for more information.


Name (deprecated): plugintype
Alias (deprecated): pt
Required (deprecated): No
Default (deprecated): PreProcess
Accepted Values (deprecated): Preprocess, preprocess, Postprocess, postprocess, Override, override
Description (deprecated): Deprecated. Plugin Type is autodetected via implemented interface.


Name: postargs
Alias: pa
Required: No
Default: empty list Accepted Values: comma-delimited list of strings
Description: A comma-separated list of values to be passed to the plugin designated in the plugin or pl parameter value. The plugin should be expecting these values as positional arguments, i.e., arg1,arg2,...argN. When using script plugins, the first argument must contain the path to the registered script (relative to the yada_bin directory,) i.e., myscript.pl,arg1,arg2,...argN. See the Plugin Guide for more info.


Name: preargs
Alias: pr
Required: No
Default: empty list Accepted Values: comma-delimited list of strings
Description: A comma-separated list of values to be passed to the plugin designated in the plugin or pl parameter value. The plugin should be expecting these values as positional arguments, i.e., arg1,arg2,...argN. When using script plugins, the first argument must contain the path to the registered script (relative to the yada_bin directory,) i.e., myscript.pl,arg1,arg2,...argN. See the Plugin Guide for more info.


Name: pretty
Alias: py
Required: No
Default: false
Accepted Values: true, false
Description: “Pretty prints” JSON output, i.e., formats JSON output with 2-character indents and line feeds


Name: protocol
Alias: pc
Required: No
Default: Parser.JDBC
Accepted Values: Parser.JDBC, Parser.REST, Parser.SOAP, Parser.FILE
Description: For internal use only. This parameter is set internally to facilitate processing. It is only mentioned here as it is conveyed using the same YADARequest object in which other parameter values are stored, and may be noticed in the Java® API.


Name: proxy
Alias: px
Required: No
Default: null
Accepted Values: host:port
Description: A string containing the HTTP proxy and port in the format host:port. This is used only for REST queries which are hosted at otherwise inaccessible sites. For this to work, you may need to set the Java®_OPTSp for proxies, -Dhttp.proxyHost=... and -Dhttp.proxyPort=... in $TOMCAT_HOME/bin/setenv.sh


Name: qname
Alias: q
Required: Yes, in the absence of JSONParams or j, otherwise, no
Default: YADA Dummy
Accepted Values: any registered query
Description:


Name: response
Alias: r
Required: No
Default: computed
Accepted Values: Name or FQCN of response class
Description:


Name: rowDelimiter
Alias: rd
Required: No
Default: \n
Accepted Values: any string
Description: The character or sequence of characters used to separate rows of results, or records, in a delimited text file format, as a comma in CSV, or a tab in TSV. Note that comma, tab, and pipe-delimiters are supported natively using the format parameter.


Name: sortkey
Alias: s
Required: No
Default: null
Accepted Values: any string
Description:


Name: sortorder
Alias: so
Required: No
Default: asc
Accepted Values: asc, desc
Description:


Name: updateStats
Alias: us
Required: No
Default: true
Accepted Values: true, false
Description: When true, Finder will execute an additional JDBC query, updateQueryStatistics, in a separate thread, on each request, to increment the access count for the requested query, and record the current timestamp in as the LAST_ACCESS value. This additional database transaction can cause problems for SQLite®, and is suppressable using this parameter.


Name: uploadItems
Alias:
Required: No
Default: null
Accepted Values:
Description: For internal use only This parameter is set internally when a request is detected to contain multipart content.


Name: user
Alias: u
Required: No
Default: YADABOT
Accepted Values: any String
Description:


Name: viewlimit
Alias: vl
Required: No
Default: -1
Accepted Values: any positive integer
Description: For use in user interfaces when a “View All” selection (vs paginated) would still return too many rows.