Mapping a Web Service Response to an ESP Column

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

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 Studio Users Guide for detailed instructions on creating a mapping file in ESP 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.

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.