How to create an atom xml doc using TSQL

• dndaughtery

  SSChampion

  Points: 11290

  More actions

  April 3, 2019 at 5:52 pm

  #2703693

  hey guys, I need to select data from a table and put it in an atom xml feed sort of like the following. I can't seem to find anything online on how to create such a document.

  <atom:entry xmlns:atom="http://www.w3.org/2005/Atom" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xml:base="http://pmurtpsapd05.pmusa.net:8085/sap/opu/odata/sap/ZCPO01_PROD_ORDER_SRV/">

  <atom:content type="application/xml">

  <m:properties>

  <d:Refnumber>8AD871C1-6DAD-4038-9A36-9997E038F342</d:Refnumber>

  </m:properties>

  </atom:content>

  <atom:link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/prdconfhdritmnav" type="application/atom+xml;type=feed" title="ZCPO01_PROD_ORDER_SRV.PRDCONF_HDR_TO_ITM_ASS">

  <m:inline>

  <atom:feed>

  <atom:entry>

  <atom:content type="application/xml">

  <m:properties>

  <d:Date>20190322</d:Date>

  <d:Place>0042</d:Place>

  </m:properties>

  </atom:content>

  </atom:entry>

  <atom:entry>

  <atom:content type="application/xml">

  <m:properties>

  <d:Date>20190322</d:Date>

  <d:Place>0042</d:Place>

  </m:properties>

  </atom:content>

  </atom:entry>

  </atom:feed>

  </m:inline>

  </atom:link>

  <atom:link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/prodconfretnav" type="application/atom+xml;type=feed" title="ZCPO01_PROD_ORDER_SRV.PRDCONF_HDR_RSLT_ASS">

  <m:inline>

  <atom:feed>

  <atom:entry>

  <atom:content type="application/xml">

  <m:properties>

  <d:RunId />

  <d:Refnumber />

  </m:properties>

  </atom:content>

  </atom:entry>

  </atom:feed>

  </m:inline>

  </atom:link>

  </atom:entry>