Integrate Software AG Products Using Digital Event Services : MashZone NextGen Help : Appendix : Operators : Data source operators : XML
XML
Extracts data from an XML file. The data records are identified using a recurring element. The individual values are written to table columns in the data feed based on the specified parameters.
The following parameters are available.
Parameters
Description
Source
XML file or EMML-Mashups
URL: HTTP address for the XML source file. If another operator dynamically supplies the URL, the URL cannot be edited here.
To view a list of available EMML-Mashups type the initial letters of the desired mashup in the input field.
URL alias: Alias of a URL configuration. Only URL aliases for that you have the Usage privilege are available. Select a URL alias. See Manage URL aliases for details.
Local file: loads file from a resource directory. Files must be located in a defined resource directory on the MashZone NextGen server.
Path prefix (alias):
Path prefix (alias): Alias of the resource directory with the path to a directory on the MashZone NextGen server. Select an alias of the local resource directory.
Available for Local file and URL alias as source.
Browse file alias (...)
Enables you to browse the resource directories with the alias defined. Click the Browse file alias (...) button and select the required source file.
At least one resource directory must exist. See Manage resource directories for details.
Parameter options ()
Enables you to set input parameter options
Refresh rate ()
Specifies the time until the source file is read in again. Default value is 12 h.
Authentication
Specifies a HTTP basic access authentication or an existing authentication defined in the MashZone NextGen administration.
User name and password are required for accessing the source file.
HTTP headers
Adds HTTP headers to the URL
Repeating element: Detect
Reads out the repeating element automatically. A repeating element already set by a user will not be considered. The repeating element will be displayed corresponding to the hierarchy of the xml elements, e.g., <element>/<repeating element>. Depending on the repeating element, the requested columns will be displayed in the Columns box.
XML element that is repeated for each row (XPath to repeat element);
You can edit the repeating element manually.
Specify a valid XPath expression, e.g.,
/catalog/journal/article
/data/row
/catalog/book
Advanced parsing options
EMML parsing: EMML compatibility mode. If selected, the XML Data source determines data types analogous to EMML, and parse data the way EMML does.
Default is unselected.
Columns: Detect
Reads out the columns of the data source automatically. The requested columns list will be displayed, based on the specified repeating element.
Configure columns
Configures the columns list. Unselect a column for excluding it from the result data. Entering a New name for a column will cause that to be used instead of the original column name in the result. Clicking Reset columns will reload the column list from the data source and undo all changes in the list.
Upload XML files to the MashZone NextGen Repository
If required, you can upload XML files to the MashZone NextGen Repository.
See Add External Resources as MashZone NextGen Files for details.
To upload a file to the MashZone NextGen Repository administration privileges are required.
If you use an absolute URL, e.g., http://anyhost:8080/mashzone/files/admin_xml?1454486242000, then an authentication has to be set. All requests to the uploaded file will be made with the specified user / password combination.
If you use a relative URL, e.g., /mashzone/files/admin_xml?1454486242000, then an authentication is not required. All requests to the uploaded file will be made with the current logged in user.
In some cases, it might be necessary to grant view permission for a user. This can be done with the API console, e.g.:
{
"version":"1.1",
"sid":"PolicyService",
"svcVersion":"0.1",
"oid":"addPermissions",
"params":[
"fileName","type.entity.file","VIEW",
[{"principalId":"userID","principalTypeId":"User"}]]
}
*fileName is the name that was specified while uploading the file.
*userID is the id of the user, who should get the permission.
Copyright © 2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback