Skip to main content
nithyanandhanm4
nithyanandhanm4
Level 2
October 1, 2016
Resuelto

Error in SOAP API request for select records using xtk:queryDef#ExecuteQuery in SOAP UI tool

  • October 1, 2016
  • 4 respuestas
  • 3424 visualizaciones
<SOAP-ENV:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
   <SOAP-ENV:Body>
      <SOAP-ENV:Fault>
         <faultcode>SOAP-ENV:MustUnderstand</faultcode>
         <faultstring xsi:type="xsd:string">'MustUnderstand' attribute not supported (service 'ExecuteQuery', method 'xtk:queryDef').</faultstring>
      </SOAP-ENV:Fault>
   </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

I got the error while using SOAP API for selecting records from Adobe Campaign DB. Please help on the same ASAP. Thanks

Este tema ha sido cerrado para respuestas.
Mejor respuesta de DonMaté

Hi nithyanandhanm47835011 ,

For the schema attribute under "queryDef", you don't need to have "urn" included there too. This should allow your soap call to work "

schema="nms:recipient">"

So your full Soap Call:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:xtk:queryDef">

   <soapenv:Header/>

   <soapenv:Body>

      <urn:ExecuteQuery>

         <urn:sessiontoken>admin/neolane</urn:sessiontoken>

         <urn:entity>

         <queryDef operation="select" schema="nms:recipient">

          <select>

            <node expr="@email"/>

            <node expr="@lastName"/>

            <node expr="@firstName"/>

          </select>

           <where>

            <condition expr="@email = '***********'"/>

         </where>

        </queryDef>

         </urn:entity>

      </urn:ExecuteQuery>

   </soapenv:Body>

</soapenv:Envelope>

Thanks,

Donald

4 respuestas

Linda_Stinson
Adobe Employee
Linda_StinsonAdobe Employee
Adobe Employee
October 3, 2016

Can you please post your SOAP request XML as well?

nithyanandhanm4
nithyanandhanm4Autor
Level 2
October 4, 2016

I tried using SOAP UI. If possible will you please share me a sample program on how to read/write data from adobe campaign. That will be helpful for me. Thanks.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:xtk:queryDef">

   <soapenv:Header/>

   <soapenv:Body>

      <urn:ExecuteQuery>

         <urn:sessiontoken>admin/admin</urn:sessiontoken>

         <urn:entity>

            <!--You may enter ANY elements at this point-->

         <queryDef operation="select" schema="urn:nms:recipient">

          <select>

            <node expr="@email"/>

            <node expr="@lastName"/>

            <node expr="@firstName"/>

          </select>

           <where>

            <condition expr="@email = '#########'"/>

         </where>

        </queryDef>

         </urn:entity>

      </urn:ExecuteQuery>

   </soapenv:Body>

</soapenv:Envelope>

DonMaté
DonMatéRespuesta
Level 2
October 12, 2016

Hi nithyanandhanm47835011 ,

For the schema attribute under "queryDef", you don't need to have "urn" included there too. This should allow your soap call to work "

schema="nms:recipient">"

So your full Soap Call:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:xtk:queryDef">

   <soapenv:Header/>

   <soapenv:Body>

      <urn:ExecuteQuery>

         <urn:sessiontoken>admin/neolane</urn:sessiontoken>

         <urn:entity>

         <queryDef operation="select" schema="nms:recipient">

          <select>

            <node expr="@email"/>

            <node expr="@lastName"/>

            <node expr="@firstName"/>

          </select>

           <where>

            <condition expr="@email = '***********'"/>

         </where>

        </queryDef>

         </urn:entity>

      </urn:ExecuteQuery>

   </soapenv:Body>

</soapenv:Envelope>

Thanks,

Donald

kapilk57908542
kapilk57908542
August 2, 2017

Hi Donald,

I am getting below mention error. I have replace myuserid and mypassword in Soap call.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:xtk:queryDef">

   <soapenv:Header/>

   <soapenv:Body>

      <urn:ExecuteQuery>

         <urn:sessiontoken>myuserid/mypassword</urn:sessiontoken>

         <urn:entity>

         <queryDef operation="select" schema="nms:recipient">

          <select>

            <node expr="@email"/>

            <node expr="@lastName"/>

            <node expr="@firstName"/>

          </select>

           <where>

            <condition expr="@email = 'xyz@gmail.com'"/>

         </where>

        </queryDef>

         </urn:entity>

      </urn:ExecuteQuery>

   </soapenv:Body>

</soapenv:Envelope>

"An error occurred. You don't have the required rights to view the detail.  "                                                                                                                                                                                                                                                                                                                                                                                                                                                 

Términos y condicionesAccessibility statement

Loading footer...