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: Alias of a URL configuration. Only URL aliases for that you have the Usage privilege are available. Select a URL alias. For details, see Manage URL aliases.
  • File alias: Loads file from a resource directory. Files must be located in a defined resource directory on the MashZone NextGen server.

    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.

    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

The file size is limited to 80 MB.

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 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.