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.
Maximum size of an XML source file
An XML source file is limited to: 80 MB
The following parameters are available.
Parameters | Description |
|---|---|
Source | XML file
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 dynamic value (CTRL + Space) | Inserts a dynamic value into the URL using an ARIS parameter. Place the cursor in the URL, press CTRL + Space and select a parameter from the list. You can specify the parameters, for example the default value. Click ARIS parameters in the editor header > Configure. |
Settings | Displays additional options. |
| Enables the use of a shared cache when multiple users access the same document. This option is available if you specified a document as a data source that is deployed in ARIS Document Storage (ADS). The option is enabled by default. If you disable the option, you must specify HTTP basic authentication instead. |
| Specifies an HTTP basic access authentication. User name and password are required for accessing the source file. The option is available, if you disable Shared caching. |
| Specifies the time until the data source is read in again. Default value is 12 h. |
| Adds HTTP headers to the URL. Click + Add header and specify HTTP headers. |
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 | List of data source columns. Click Click Detect to automatically read the columns of the data source. The requested columns lists are displayed, based on the specified repeating object. |
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.