HTTP
This page shows how to use the HTTP destination. The HTTP destination is a generic JSON stream over HTTP. When running services, the output is returned in JSON format in the response body of the web service.
Create an HTTP Destination
HTTP is a default destinations provided by Xtract Universal.iQ. As Xtract Universal.iQ currently only supports the JSON output format, no connection settings are available for HTTP.
Assign HTTP to a Service
To assign the HTTP destination to a service:
- Open the Services menu.
- Select one or more services.
- Click [ Edit].
- Select an existing HTTP connection from the Destination dropdown.
- 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.
Destination Settings
Destination settings define the output data of the service, such as the column and date formats.
To open the destination settings:
- Open the Services menu.
- Select a service that uses the HTTP connection.
- Click [ Edit]. The service settings open.
- 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:
| Option | Description |
|---|---|
| Code | The SAP technical column name is used as column name in the destination e.g., MAKTX. |
| PrefixedCode | The SAP technical column name is prefixed by SAP object name and the tilde character e.g., MAKT~MAKTX |
| CodeAndText | The SAP technical column name and the SAP description separated by an underscore are used as column name in the destination e.g., MAKTX_Material Description (Short Text). |
| TextAndCode | The SAP description and the SAP technical column name description separated by an underscore are used as column name in the destination e.g., Material Description (Short Text)_MAKTX. |
| Text | The SAP description is used as column name in the destination e.g., Material Description (Short Text). |
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.