Before you configure a midstream transformation, you must create a business service from the Configure tab. You must select a Coupa V2 connection and an operation when you create a business service.
When you configure the midstream transformation, select the business service and the operation on the Web Service tab.
A Web Services transformation connects to the web service application as a web service client to access, transform, or deliver data. Use the Web Services transformation in the Mapping Designer to construct a web service request and to parse the web service response.
You can map the incoming fields from source file to elements in request structure on the Request Mapping tab.
You can view the response structure on the Response Mapping tab. When you map the elements from the response structure to the output fields, the Secure Agent creates the output groups, along with the primary and foreign keys for the field names.
Fault Group
The Fault group is used to capture the rows where an error occurs in a mapping for a particular web service.
The following image shows a Web Service with response structure and output fields on the Response Mapping tab. You will see the fault group displayed in the output fields.
The response structure displays the fault output group by default. The fault group contains the request XML, error code, and error message. The fault group is displayed for the new business services. To map the fault group for the business services created in the previous version of connector, create new business services and import them again.
Advanced Midstream Properties
The following table describes the advanced properties that you can configure for a midstream transformation:
Property
Description
Cache Size for Web Service Request (KB)
Memory available for the web service request. If the request is more than 100 KB, you can increase the cache size. Default is 100 KB.
Cache Size for Web Service Response (KB)
Memory available for the web service response. If the web service response contains many rows or columns, you might want to increase the cache size. Default is 100 KB.
