# Can't get Web Service Mapping to return any data

**URL:** <https://forum.cloverdx.com/t/cant-get-web-service-mapping-to-return-any-data/1284>\
**Category:** CloverDX Platform\
**Created:** [October 4, 2013, 12:00am UTC](https://forum.cloverdx.com/t/cant-get-web-service-mapping-to-return-any-data/1284 "2013-10-04T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![johnh](https://avatars.discourse-cdn.com/v4/letter/j/e19b73/32.png) [@johnh](https://forum.cloverdx.com/u/johnh)\
**Post date:** [October 4, 2013, 12:00am UTC](https://forum.cloverdx.com/t/cant-get-web-service-mapping-to-return-any-data/1284/1 "2013-10-04T00:00:00Z")

</div>

I am using the WS Client in 3.0.0 r711563.

I have a WS request, that runs and returns a response. It all works fine in SOAP UI.

In Clover though I can’t get any of the mapping to work. I’ve used this component before with no issues.

My request:

```auto
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.endeca.com/MDEX/conversation/2/0" xmlns:typ="http://www.endeca.com/MDEX/lql_parser/types">
   <soapenv:Header/>
   <soapenv:Body>
     
      <Request xmlns:ns2="http://www.endeca.com/MDEX/lql_parser/types" 
    xmlns="http://www.endeca.com/MDEX/conversation/2/0">
 <State>
    <SelectedRefinementFilter Name="DimDate_CalendarYear" Spec="2006"/>
    <SearchFilter Key="All">frame</SearchFilter>
    <RecordKind>data</RecordKind>
  </State>
  
  <ContentElementConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xsi:type="LQLConfig" Id="EQL" 
   HandlerNamespace="" 
   HandlerFunction="LQLHandler">
		   <LQLQueryString>
           RETURN "results" AS SELECT COUNT(1) AS 
           numtransactions group by DimDate_MonthName
           
     </LQLQueryString>
  </ContentElementConfig>
</Request>
      
   </soapenv:Body>
</soapenv:Envelope>

```

The Response:

```auto
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <soapenv:Header/>
   <soapenv:Body>
      <cs:Results xmlns:cs="http://www.endeca.com/MDEX/conversation/2/0" xmlns:mdex="http://www.endeca.com/MDEX/XQuery/2009/09">
         <cs:Request>
            <State xmlns="http://www.endeca.com/MDEX/conversation/2/0" xmlns:ns2="http://www.endeca.com/MDEX/lql_parser/types" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
               <SelectedRefinementFilter Name="DimDate_CalendarYear" Spec="2006"/>
               <SearchFilter Key="All">frame</SearchFilter>
               <RecordKind>data</RecordKind>
            </State>
            <ContentElementConfig xsi:type="LQLConfig" Id="EQL" HandlerNamespace="" HandlerFunction="LQLHandler" xmlns="http://www.endeca.com/MDEX/conversation/2/0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
               <LQLQueryString xmlns:ns2="http://www.endeca.com/MDEX/lql_parser/types" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">RETURN "results" AS SELECT COUNT(1) AS 
           numtransactions group by DimDate_MonthName
           
     ;
DEFINE Base AS SELECT "Class" AS "Class", "Color" AS "Color", "DaysToManufacture" AS "DaysToManufacture", "DealerPrice" AS "DealerPrice", "Description" AS "Description", "DimDate_CalendarQuarter" AS "DimDate_CalendarQuarter", "DimDate_CalendarSemester" AS "DimDate_CalendarSemester", ...
</LQLQueryString>
            </ContentElementConfig>
         </cs:Request>
         <cs:ContentElement xsi:type="cs:LQL" Id="EQL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
            <cs:ResultRecords NumRecords="2" Name="results">
               <cs:DimensionHierarchy/>
               <cs:AttributeMetadata name="DimDate_MonthName" type="mdex:string"/>
               <cs:AttributeMetadata name="numtransactions" type="mdex:long"/>
               <cs:Record>
                  <cs:attribute name="DimDate_MonthName" type="mdex:string">July</cs:attribute>
                  <cs:attribute name="numtransactions" type="mdex:long">86</cs:attribute>
               </cs:Record>
               <cs:Record>
                  <cs:attribute name="DimDate_MonthName" type="mdex:string">February</cs:attribute>
                  <cs:attribute name="numtransactions" type="mdex:long">23</cs:attribute>
               </cs:Record>
            </cs:ResultRecords>
         </cs:ContentElement>
      </cs:Results>
   </soapenv:Body>
</soapenv:Envelope>

```

I want to get the ResultRecords elements.

I either get 0 recs on the edge or null.

Is there any way to:  
1. Just extract the whole element and let me parse it later in the workflow?  
OR  
2. Map in the typical XML fashion to get Records like this:  
DimDate\_MonthName numtransactions  
July 86  
February 23

Tried many different permutations of mappings…I do see this warning (had to select SubType on Content Elements, since it can return different items).

WEB\_SERVICE\_CLIENT1: Mapping error - Unknown element ‘TypeOverride’ is ignored with all it’s child elements.

If I remove the “override” from the source it still runs without that error/warning and still returns nothing.

TIA

---

<div class="post-metadata">

**Author:** ![johnh](https://avatars.discourse-cdn.com/v4/letter/j/e19b73/32.png) [@johnh](https://forum.cloverdx.com/u/johnh)\
**Post date:** [October 8, 2013, 12:42pm UTC](https://forum.cloverdx.com/t/cant-get-web-service-mapping-to-return-any-data/1284/2 "2013-10-08T12:42:56Z")

</div>

Figured it out.

Had to remove the

```auto
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.endeca.com/MDEX/conversation/2/0" xmlns:typ="http://www.endeca.com/MDEX/lql_parser/types">
   <soapenv:Header/>
   <soapenv:Body>

```

parts. Basically just keep what was between the tags. Tricky since it threw no errors.