XML

Extracts data from an XML file. The data records are identified using a recurring element. The individual values are written to the table columns in the data feed based on the specified parameters.

The following parameters are available.

Parameters

Description

Source

XML file

  • URL: HTTP address of the source file

    If another operator supplies the URL dynamically, the URL cannot be edited here.

    Example

    http://myhost.company:1080/documents/rest/links/03388871-367d-4abe-a2c9-37bc9fa44580?tenantid=default&revision=1

  • URL alias: Loads the file from a resource directory. Files must be located in a defined resource directory on the server. The data source files are located in a folder or a sub-folder of the ARIS document storage accessible in the ARIS Repository.

    If you have updated ARIS 10.0 Service Release 1 to version 10.0 Service Release 2, you need to recreate the URL alias that WAS defined for ARIS 10.0 Service Release 1. Delete the URL alias at first and add a new URL alias with the same data.

    Path prefix (alias): Alias of the resource directory with the path to a directory on the server. Select an alias of the local resource directory, for example, Feed URL.

    Feed URL is the alias of the resource directory of the default data feeds provided in ARIS.

    In the input box, enter a path to the relevant data source file for the Path prefix (alias) selected.

    Example

    /documents/rest/links/03388871-367d-4abe-a2c9-37bc9fa44580?tenantid=default&revision=1

To configure a Path prefix (alias), see Configure Dashboard server for details.

To store data source files in a resource directory, see Upload file based data sources for details.

To copy the source file URL, see Upload file based data sources for details.

Insert parameter (Insert parameter)

Inserts user defined input parameters at the cursor position. The button is clickable only if at least one user input parameter, for example, Text user input, has been inserted in the feed definition.

Parameter options (Parameter options)

Enables you to set input parameter options.

Refresh rate ()

Specifies the time until the data source is read in again. Default value is 12 h.

Authentication

Specifies the credentials for authenticating to access the source file.

Single Sign-On is preset for authentication if you select URL alias to access the source and Single Sign-On is enabled for the selected Path prefix (alias). Click Authentication if you want to change the settings.

Single Sign-On:

Enables you to access the source file using Single Sign-On (SSO). SSO only works within ARIS and not for files provided by external data sources, such as an external web page. For details on how to configure SSO, see Configure single sign-on.

HTTP basic authentication:

Specifies an HTTP basic access authentication.

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 is not considered. The repeating element is displayed corresponding to the hierarchy of the XML elements, for example, <element>/<repeating element>. The requested columns are displayed in the Columns box depending on the repeating element.

XML element that is repeated for each row (XPath to repeat element);

You can edit the repeating element manually.

Specify a valid XPath expression, for example,

/catalog/journal/article

/data/row

/catalog/book

Columns: Detect

Automatically reads out the columns of the data source. The requested columns list is displayed, based on the specified repeating element.

Configure columns

Configures the columns list. You can unselect a column to exclude it from the result data. If you enter a new name for a column, this name is used in the result instead of the original column name. If you click Reset columns, the column list is reloaded from the data source and all changes in the list are undone.

For detailed information on configuring the time zone used by this operator, see the chapter Configure feed processing time zone.

If you use an absolute URL, for example, http://myhost.company:1080/documents/rest/links/03388871-367d-4abe-a2c9-37bc9fa44580, an authentication has to be set. All requests to the uploaded file are made with the specified user/password combination.

If you use a relative URL, for example, /documents/rest/links/03388871-367d-4abe-a2c9-37bc9fa44580, an authentication is not required. All requests to the uploaded file are made with the current logged in user.