Unable to Retrieve Schema Details using SOAP API | Community
Skip to main content
I
ibalbale
Level 2
March 11, 2026
Solved

Unable to Retrieve Schema Details using SOAP API

  • March 11, 2026
  • 1 reply
  • 43 views

Here is the SOAP Call being used 

 

POST /nl/jsp/soaprouter.jsp
SOAPAction: xtk:queryDef#ExecuteQuery
Authorization: Bearer <access_token>
Content-Type: text/xml; charset=utf-8

 

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <ExecuteQuery xmlns="urn:xtk:queryDef">
      <sessiontoken></sessiontoken>
      <entity>
        <queryDef schema="xtk:schema" operation="get">
          <select>
            <node expr="@name"/>
            <node expr="@namespace"/>
            <node expr="@label"/>
            <node expr="md5"/>
          </select>
          <where>
            <condition expr="@name='recipient' and @namespace='nms'"/>
          </where>
        </queryDef>
      </entity>
    </ExecuteQuery>
  </soap:Body>
</soap:Envelope>
 

to get all details.

 

The response is self-closing node 

<schema
  _cs="Recipients (nms)"
  _isMemoNull="0"
  img="nms:recipient.png"
  label="Recipients"
  md5="0121C09BE35FD25B22E8050754134D5E"
  name="recipient"
  namespace="nms"
/>
 

Best answer by ibalbale

@Nolan_Chabert My goal was to get schema details for all existing schema and their attributes and links. The snippet I shared was just one that I used to test and at the time had no success. Finally I was able to query in and get list of schemas, their details including attributes. Appreciate you looking into this, I will go ahead and mark this resolved.

1 reply

Nolan_Chabert
Adobe Employee
Nolan_ChabertAdobe Employee
Adobe Employee
March 12, 2026

Hi ​@ibalbale , i am confused , are you trying to get schema definition or recipient data details? 

Thanks 

I
ibalbaleAuthor
Level 2
March 12, 2026

Trying to get schema definition for recipient table.

Nolan_Chabert
Adobe Employee
Nolan_ChabertAdobe Employee
Adobe Employee
March 12, 2026

Hi ​@ibalbale , I am still a little bit confused, 

the result show 

“<schema
  _cs="Recipients (nms)"
  _isMemoNull="0"
  img="nms:recipient.png"
  label="Recipients"
  md5="0121C09BE35FD25B22E8050754134D5E"
  name="recipient"
  namespace="nms"
/>”

 

correctly show the result of the fieds request in your query. 

“<node expr="@name"/>
            <node expr="@namespace"/>
            <node expr="@label"/>
            <node expr="md5"/>”

 

Below my questions:

  1. where is the issue on the result?
  2. can you add a screenshot of the error message? 
  3. Can you share a little bit more of the business requirement?
  4. Have you try to generate the data model? 
  5. have you try to create you own custom API to generate the table if you would like to get the full table description?

Thanks 

Nolan 

Terms & ConditionsAccessibility statement

Loading footer...