Considerations Using Rowsets

Unstructured XML should be transformed to structured if you want to use the full rowset abilities. PeopleSoft recommends transforming the data into a rowset-based message.

If you do not want to transform the data, you need to break it up using the Transaction tag around the equivalent of each level zero rowset, as shown in the example.

   <?xml version="1.0" ?> 
   - <SAMPLE_MSG>
      - <Transaction>
         - <QE_SALES_ORDER class="R">
               <QE_ACCT_ID>26</QE_ACCT_ID> 
               <QE_ACCOUNT_NAME>APG-65</QE_ACCOUNT_NAME> 
               <QE_ADDRESS>F18 HORNET WAY</QE_ADDRESS> 
               <QE_PHONE>(206)544-1264</QE_PHONE> 
               <QE_FROMROWSET /> 
               <QE_TOROWSET /> 
               <QE_SEND_SOA_BTN /> 
               <QE_SEND_SOS_BTN /> 
               <QE_TRAN_SOA_BTN /> 
               <QE_SEND_SQ_BTN /> 
               <QE_TRAN_SOS_BTN /> 
               <QE_TRAN_APCODE_BTN /> 
               <QE_TRAN_SPCODE_BTN /> 
               <QE_PUBXMLDOC_BTN /> 
               <QE_CLEAR_BTN /> 
            <DESCRLONG /> 
         </QE_SALES_ORDER>
      </Transaction>
      - <Transaction>
         - <QE_SALES_ORDER class="R">
               <QE_ACCT_ID>27</QE_ACCT_ID> 
               <QE_ACCOUNT_NAME>JASON ACCOUNT</QE_ACCOUNT_NAME> 
               <QE_ADDRESS>THE ADDRESS</QE_ADDRESS> 
               <QE_PHONE>(PHONE NUMBER</QE_PHONE> 
               <QE_FROMROWSET /> 
               <QE_TOROWSET /> 
               <QE_SEND_SOA_BTN /> 
               <QE_SEND_SOS_BTN /> 
               <QE_TRAN_SOA_BTN /> 
               <QE_SEND_SQ_BTN /> 
               <QE_TRAN_SOS_BTN /> 
               <QE_TRAN_APCODE_BTN /> 
               <QE_TRAN_SPCODE_BTN /> 
               <QE_PUBXMLDOC_BTN /> 
               <QE_CLEAR_BTN /> 
            <DESCRLONG /> 
         </QE_SALES_ORDER>
      </Transaction>
   </SAMPLE_MSG>