Mapping a Web Service Response to an SAP Event Stream Processor Column

Create a mapping file to map Web service WSDL to ESP columns.

Context

You can also use Studio to generate a mapping file. See Discovering Schema and Creating a Mapping File for the Web Services (SOAP) Adapter in the SAP Event Stream Processor: Studio Users Guide for detailed instructions on creating a mapping file in Studio.

If you choose to manually create the mapping file, run discovery using the Web service’s WSDL. This generates an .xml file with all the possible fields, as well as the default datatypes. The fields in this discovery file are the names that you use as the adapterField values.

Procedure

Create a new file or edit an existing sample mapping file (for example, weatherMappings2.xml).
Within the <columnMappings> section, specify the mappings. For example:
```
<mapping espCol="getCityForecastByZIPResult_state" adapterField="GetCityForecastByZIPResult.State"/>
<mapping espCol="tradeTime" adapterField="transaction.tradeTime" saveAs="lastTime"/> 
```
The saveAs attribute corresponds to the variable name specified in the savedVarName attribute of the request parameter, and must match exactly. This is applicable to the input adapter only and is ignored if specified for the output adapter.