Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 1
Level 2
nithyanandhanm4
Level 2

Likes

4 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
nithyanandhanm4
Level 2

Likes

4 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
nithyanandhanm4
Level 2

01-10-2016

<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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 3
Level 2
DonMaté
Level 2

Likes

4 likes

Total Posts

5 posts

Correct Reply

4 solutions
Top badges earned
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile

Avatar
Boost 3
Level 2
DonMaté
Level 2

Likes

4 likes

Total Posts

5 posts

Correct Reply

4 solutions
Top badges earned
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile
DonMaté
Level 2

12-10-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

Answers (3)

Answers (3)

Avatar

Avatar
Level 1
kapilk57908542
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
kapilk57908542
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
kapilk57908542
Level 1

01-08-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.  "                                                                                                                                                                                                                                                                                                                                                                                                                                                 

Avatar

Avatar
Validate 1
Level 2
nithyanandhanm4
Level 2

Likes

4 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
nithyanandhanm4
Level 2

Likes

4 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
nithyanandhanm4
Level 2

03-10-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>

Avatar

Avatar
Validate 1
Employee
Linda_Stinson
Employee

Likes

51 likes

Total Posts

250 posts

Correct Reply

77 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 20
Ignite 10
View profile

Avatar
Validate 1
Employee
Linda_Stinson
Employee

Likes

51 likes

Total Posts

250 posts

Correct Reply

77 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 20
Ignite 10
View profile
Linda_Stinson
Employee

03-10-2016

Can you please post your SOAP request XML as well?