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
/documents/rest/links/03388871-367d-4abe-a2c9-37bc9fa44580?tenantid=default&revision=1 The file size is limited to 80 MB. |
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 ( |
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.