HTTP

This page shows how to use the HTTP destination. The HTTP destination is a generic JSON or CSV stream over HTTP. When running services, the output is returned in the response body of the web service.

HTTP JSON is a default destinations provided by Xtract Universal.iQ. You can change the output format to CSV or create a separate HTTP destination that uses the CSV format.

Assign HTTP to a Service

To assign the HTTP destination to a service:

1. Open the Services menu.
2. Select one or more services.
3. Click [ Edit].
4. Select an existing HTTP connection from the Destination dropdown.
5. Click [Save].

When running the service, the results are returned in the response body of the service.

Next, check if the service-specific destination settings match your needs.

Connection Settings

Connection settings define the output formatting of the HTTP service. To open the connection settings:

1. Open the Connections menu.
2. Select a connection of type HTTP.
3. Click [ Edit].

The connection settings of the HTTP connection open and can be modified.

Output Format

The Output Format section defines how data is formatted in the response body of a web servise.

Content Type

Select a file format for the output of the web service. Xtract Universal.iQ supports the following format:

• JSON
• CSV

CSV Settings

The CSV Settings section is only available for the CSV output format.

Column Separator

Defines how two columns in CSV are separated. Typical column separators:

• , (comma separator)
• ; (semicolon separator)
• \t (tab separator)

Row Separator

Defines how two rows in CSV are separated. Typical row separators:

• \r\n (carriage return + line feed)
• \n (line feed)
• \r (carriage return)

Quote Symbol

Defines which character is used to encase field data. A sequence of characters may be used as the quote symbol. Quotation is applied in these scenarios:

• The column separator is part of the field data.
• The quote symbol is part of the field data.
• The row separator is part of the field data.
• The escape character is part of the field data.

Escape Character

When the escape character is part of the field data, the respective field containing this character is encased by the Quote symbol. The default escape character is the backslash \. The field may remain empty.

Column Names in First Row

Defines if the first row contains the column names. This option is set by default.

Row Separator After Last Row

Defines if the last row contains a row separator. This option is set by default.

Decimal Separator

Defines the decimal separator of decimal number for the output. Dot (.) is the default value.

Date Format

Defines a customized date format (e.g. YYYY-MM-DD or MM/DD/YYYY) for converting valid SAP dates (YYYYMMDD). Default is YYYY-MM-DD.

Time Format

Defines a customized time format (e.g. HH-MM-SS or HH:MM:SS) for converting valid SAP times (HHMMSS). Default is HH:MM:SS.

Destination Settings

Destination settings define the output data of the service, such as the column and date formats.

To open the destination settings:

1. Open the Services menu.
2. Select a service that uses the HTTP connection.
3. Click [ Edit]. The service settings open.
4. Open the tab Destination Settings.

The destination settings for HTTP are open and can be modified.

HTTP Output

Column Name Format

Defines the format of the column name. The following options are available:

Date Conversion

Convert SAP Dates

Converts the SAP date format (YYYYMMDD) to a regular date format (YYYY-MM-DD), e.g., 19900101 becomes 1990-01-01. Target data uses a real date data-type and not the string data-type to store dates.

Replace SAP Dates 0000XXXX with

Converts the SAP date 00000000 to the entered value.

Replace SAP Dates 9999XXXX with

Converts the SAP date 9999XXXX to the entered value.

Replace Invalid SAP Dates with

If an SAP date cannot be converted to a valid date format, the invalid date is converted to the entered value. NULL is supported as a value. When converting the SAP date the two special cases 00000000 and 9999XXXX are checked first.