Can't get Web Service Mapping to return any data

CloverDX Platform
1

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:

<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:

<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

2

Figured it out.

Had to remove the

<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.