Error in SOAP API request for select records using xtk:queryDef#ExecuteQuery in SOAP UI tool | Community
Skip to main content
nithyanandhanm4
nithyanandhanm4
October 1, 2016
Solved

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

  • October 1, 2016
  • 4 replies
  • 3395 views
<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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by 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 replies

Linda_Stinson
Adobe Employee
Linda_StinsonAdobe Employee
Adobe Employee
October 3, 2016

Can you please post your SOAP request XML as well?

nithyanandhanm4
nithyanandhanm4Author
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éAccepted solution
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.  "                                                                                                                                                                                                                                                                                                                                                                                                                                                 

Terms & ConditionsAccessibility statement

Loading footer...